IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changeset 19258


Ignore:
Timestamp:
Aug 27, 2008, 5:57:36 PM (18 years ago)
Author:
eugene
Message:

do not join against tess_id

Location:
trunk/ippTools/share
Files:
12 edited

Legend:

Unmodified
Added
Removed

  • trunk/ippTools/share/difftool_definebyquery.sql

    r18673 r19258  
    2424        diffTemplates.stack_id AS current_stack_id
    2525    FROM warpSkyfile
    26     JOIN warpRun USING(warp_id, tess_id)
    27     JOIN fakeRun USING(fake_id, tess_id)
    28     JOIN camRun USING(cam_id, tess_id)
    29     JOIN chipRun USING(chip_id, tess_id)
    30     JOIN rawExp USING(exp_id, tess_id)
     26    JOIN warpRun USING(warp_id)
     27    JOIN fakeRun USING(fake_id)
     28    JOIN camRun USING(cam_id)
     29    JOIN chipRun USING(chip_id)
     30    JOIN rawExp USING(exp_id)
    3131    -- Check if it has an associated diff
    3232    LEFT JOIN diffInputSkyfile AS diffInputs
    3333        ON diffInputs.warp_id = warpSkyfile.warp_id
    3434        AND diffInputs.skycell_id = warpSkyfile.skycell_id
    35         AND diffInputs.tess_id = warpSkyfile.tess_id
    3635        AND diffInputs.template = 0 -- only join input files
    3736    -- Get the stack_id currently used as a template, if any
    … …  
    5655    GROUP BY
    5756        skycell_id,
    58         tess_id,
    5957        filter
    60     ) AS stacksForDiff USING(skycell_id, tess_id, filter)
     58    ) AS stacksForDiff USING(skycell_id, filter)

  • trunk/ippTools/share/faketool_find_camrun.sql

    r19092 r19258  
    2525        rawExp.posang,
    2626        rawExp.object,
    27         rawExp.solang
     27        rawExp.solang,
     28        rawExp.comment
    2829    FROM camRun
    2930    JOIN chipRun

  • trunk/ippTools/share/magictool_definebyquery.sql

    r18672 r19258  
    88--------------------------------------------------------------------
    99-- NOTE: THIS FILE IS NOT USED BY magictool
     10-- NOTE : thi sfile contains examples of tess_id as a join qualifier which are wrong
    1011--------------------------------------------------------------------
    1112

  • trunk/ippTools/share/magictool_definebyquery_select_part1.sql

    r18669 r19258  
    1313        COUNT(skycell_id) AS num_todo
    1414    FROM rawExp
    15     JOIN chipRun USING(exp_id, tess_id)
    16     JOIN camRun USING(chip_id, tess_id)
    17     JOIN fakeRun USING(cam_id, tess_id)
    18     JOIN warpRun USING(fake_id, tess_id)
    19     JOIN warpSkyCellMap USING(warp_id, tess_id)
    20     JOIN warpSkyfile USING(warp_id, skycell_id, tess_id)
     15    JOIN chipRun USING(exp_id)
     16    JOIN camRun USING(chip_id)
     17    JOIN fakeRun USING(cam_id)
     18    JOIN warpRun USING(fake_id)
     19    JOIN warpSkyCellMap USING(warp_id)
     20    JOIN warpSkyfile USING(warp_id, skycell_id)
    2121    WHERE
    2222        warpSkyfile.ignored = 0

  • trunk/ippTools/share/magictool_definebyquery_select_test.sql

    r18663 r19258  
    1818        COUNT(skycell_id) AS num_todo
    1919    FROM rawExp
    20     JOIN chipRun USING(exp_id, tess_id)
    21     JOIN camRun USING(chip_id, tess_id)
    22     JOIN fakeRun USING(cam_id, tess_id)
    23     JOIN warpRun USING(fake_id, tess_id)
    24     JOIN warpSkyCellMap USING(warp_id, tess_id)
    25     JOIN warpSkyfile USING(warp_id, skycell_id, tess_id)
     20    JOIN chipRun USING(exp_id)
     21    JOIN camRun USING(chip_id)
     22    JOIN fakeRun USING(cam_id)
     23    JOIN warpRun USING(fake_id)
     24    JOIN warpSkyCellMap USING(warp_id)
     25    JOIN warpSkyfile USING(warp_id, skycell_id)
    2626    WHERE
    2727        warpSkyfile.ignored = 0

  • trunk/ippTools/share/magictool_definebyquery_temp_insert.sql

    r19134 r19258  
    77    MAX(diffSkyfile.diff_id) AS diff_id
    88FROM rawExp
    9 JOIN chipRun USING(exp_id, tess_id)
    10 JOIN camRun USING(chip_id, tess_id)
    11 JOIN fakeRun USING(cam_id, tess_id)
    12 JOIN warpRun USING(fake_id, tess_id)
    13 JOIN warpSkyCellMap USING(warp_id, tess_id)
    14 JOIN warpSkyfile USING(warp_id, skycell_id, tess_id)
     9JOIN chipRun USING(exp_id)
     10JOIN camRun USING(chip_id)
     11JOIN fakeRun USING(cam_id)
     12JOIN warpRun USING(fake_id)
     13JOIN warpSkyCellMap USING(warp_id)
     14JOIN warpSkyfile USING(warp_id, skycell_id)
    1515JOIN diffInputSkyfile
    1616    ON diffInputSkyfile.warp_id = warpSkyfile.warp_id
    1717    AND diffInputSkyfile.skycell_id = warpSkyfile.skycell_id
    18     AND diffInputSkyfile.tess_id = warpSkyfile.tess_id
    1918    AND diffInputSkyfile.template = 0 -- selecting inputs only
    2019JOIN diffSkyfile USING(diff_id)

  • trunk/ippTools/share/stacktool_definebyquery_insert.sql

    r19152 r19258  
    1818WHERE
    1919    warpSkyfile.skycell_id = '%s'
    20     AND warpRun.tess_id = '%s'
     20    AND warpRun.state = 'full'
    2121    AND rawExp.filter = '%s'
    2222    AND warpSkyfile.fault = 0

  • trunk/ippTools/share/stacktool_definebyquery_insert_random_part1.sql

    r19249 r19258  
    1414    FROM warpSkyfile
    1515    JOIN warpRun
    16         USING(warp_id, tess_id)
     16        USING(warp_id)
    1717    JOIN fakeRun
    18         USING(fake_id, tess_id)
     18        USING(fake_id)
    1919    JOIN camRun
    20         USING(cam_id, tess_id)
     20        USING(cam_id)
    2121    JOIN chipRun
    22         USING(chip_id, tess_id)
     22        USING(chip_id)
    2323    JOIN rawExp
    24         USING(exp_id, tess_id)
     24        USING(exp_id)
    2525    WHERE
    2626        skycell_id = '%s'
    27         AND tess_id = '%s'
    28         AND rawExp.filter = '%s'
     27        AND warpRun.state = 'full'
     28        AND rawExp.filter = '%s' -- the result of the query is grouped by filter and inserted for one at a time
    2929        AND warpSkyfile.fault = 0
    3030        AND warpSkyfile.ignored = 0

  • trunk/ippTools/share/stacktool_definebyquery_part1.sql

    r19105 r19258  
    55SELECT
    66    skycell_id,
     7    filter,
    78    tess_id,
    8     filter,
    99    num_warp,
    1010    MAX(num_stack) AS num_stack
    … …  
    1313    SELECT
    1414        skycell_id,
    15         warpSkyfile.tess_id,
     15        warpSkyfile.tess_id as tess_id,
    1616        rawExp.filter,
    1717        COUNT(warpSkyfile.skycell_id) AS num_warp -- number of warps that can be stacked

  • trunk/ippTools/share/stacktool_definebyquery_part2.sql

    r19104 r19258  
    1313    SELECT
    1414        skycell_id,
    15         tess_id,
     15        stackRun.tess_id as stack_tess_id,
    1616        filter,
    1717        COUNT(stackInputSkyfile.warp_id) as num_stack -- number of warps in a stack
    … …  
    2222        ) AS stackSizes
    2323    -- JOINing the warpsToStack and stackSizes tables
    24         USING(skycell_id, tess_id, filter)
     24        USING(skycell_id, filter)
    2525        )
    2626    GROUP BY
    2727        skycell_id,
    28         tess_id,
    2928        filter

  • trunk/ippTools/share/stacktool_definebyquery_test.sql

    r19092 r19258  
    2424        COUNT(warpSkyfile.skycell_id) AS num_warp -- number of warps that can be stacked
    2525    FROM warpRun
    26         JOIN warpSkyfile USING(warp_id, tess_id)
    27         JOIN fakeRun USING(fake_id, tess_id)
    28         JOIN camRun USING(cam_id, tess_id)
    29         JOIN chipRun USING(chip_id, tess_id)
    30         JOIN rawExp USING(exp_id, tess_id)
     26        JOIN warpSkyfile USING(warp_id)
     27        JOIN fakeRun USING(fake_id)
     28        JOIN camRun USING(cam_id)
     29        JOIN chipRun USING(chip_id)
     30        JOIN rawExp USING(exp_id)
    3131    WHERE
    3232        warpRun.state = 'full'
    … …  
    5252        ) AS stackSizes
    5353    -- JOINing the warpsToStack and stackSizes tables
    54         USING(skycell_id, tess_id, filter)
     54        USING(skycell_id, filter)
    5555        )
    5656    GROUP BY
    5757        skycell_id,
    58         tess_id,
    5958        filter
    6059;

  • trunk/ippTools/share/stacktool_find_complete_warps.sql

    r19092 r19258  
    77FROM warpRun
    88JOIN warpSkyfile
    9     USING(warp_id, tess_id)
     9    USING(warp_id)
    1010JOIN fakeRun
    11     USING(fake_id, tess_id)
     11    USING(fake_id)
    1212JOIN camRun
    13     USING(cam_id, tess_id)
     13    USING(cam_id)
    1414JOIN chipRun
    15     USING(chip_id, tess_id)
     15    USING(chip_id)
    1616JOIN rawExp
    17     USING(exp_id, tess_id)
     17    USING(exp_id)
    1818LEFT JOIN stackInputSkyfile
    1919    ON warpSkyfile.warp_id = stackInputSkyfile.warp_id
    2020LEFT JOIN stackRun
    21     ON stackRun.tess_id = warpSkyfile.tess_id
    22     AND stackRun.skycell_id = warpSkyfile.skycell_id
     21    ON stackRun.skycell_id = warpSkyfile.skycell_id
    2322    AND stackRun.stack_id = stackInputSkyfile.stack_id
    2423WHERE
    … …  
    2625    AND warpSkyfile.ignored = 0
    2726GROUP BY
    28     warpSkyfile.skycell_id, warpSkyfile.tess_id, stackRun.stack_id
     27    warpSkyfile.skycell_id, stackRun.stack_id
    2928HAVING
    3029    num_avail > num_extant
Note: See TracChangeset for help on using the changeset viewer.