IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Ignore:
Timestamp:
Oct 7, 2009, 4:25:35 PM (17 years ago)
Author:
watersc1
Message:

Updates to various tools to fix errors in cleanup.

File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/ippTools/share/difftool_pendingcleanuprun.sql

    r24186 r25800  
    11-- does this result in too many entries (one for each diffInputSkyfile?)
    22-- all of this is just to get the camera used for the diff run
    3 SELECT
    4     diffRun.diff_id,
    5     rawExp.camera,
    6     diffRun.state
    7 FROM diffRun
    8 JOIN diffInputSkyfile
    9     USING(diff_id)
    10 JOIN warpSkyfile
    11     ON  diffInputSkyfile.warp1    = warpSkyfile.warp_id
    12     AND diffInputSkyfile.skycell_id = warpSkyfile.skycell_id
    13     AND diffInputSkyfile.tess_id    = warpSkyfile.tess_id
    14 JOIN warpRun
    15     ON warpRun.warp_id = warpSkyfile.warp_id
    16 JOIN fakeRun
    17     USING(fake_id)
    18 JOIN camRun
    19     USING(cam_id)
    20 JOIN chipRun
    21     USING(chip_id)
    22 JOIN rawExp
    23     USING(exp_id)
    24 WHERE
    25     (diffRun.state = 'goto_cleaned' OR diffRun.state = 'goto_scrubbed' OR diffRun.state = 'goto_purged')
     3SELECT DISTINCT * FROM
     4   (SELECT
     5            diffRun.diff_id,
     6            rawExp.camera,
     7            diffRun.state,
     8            diffRun.label
     9        FROM diffRun
     10        JOIN diffInputSkyfile
     11            USING(diff_id)
     12        JOIN warpSkyfile
     13            ON  diffInputSkyfile.warp1    = warpSkyfile.warp_id
     14            AND diffInputSkyfile.skycell_id = warpSkyfile.skycell_id
     15            AND diffInputSkyfile.tess_id    = warpSkyfile.tess_id
     16        JOIN warpRun
     17            ON warpRun.warp_id = warpSkyfile.warp_id
     18        JOIN fakeRun
     19            USING(fake_id)
     20        JOIN camRun
     21            USING(cam_id)
     22        JOIN chipRun
     23            USING(chip_id)
     24        JOIN rawExp
     25            USING(exp_id)
     26        WHERE
     27            (diffRun.state = 'goto_cleaned' OR
     28             diffRun.state = 'goto_scrubbed' OR
     29             diffRun.state = 'goto_purged')
     30     UNION
     31     SELECT
     32            diffRun.diff_id,
     33            rawExp.camera,
     34            diffRun.state,
     35            diffRun.label
     36        FROM diffRun
     37        JOIN diffInputSkyfile
     38            USING(diff_id)
     39        JOIN warpSkyfile
     40            ON  diffInputSkyfile.warp2    = warpSkyfile.warp_id
     41            AND diffInputSkyfile.skycell_id = warpSkyfile.skycell_id
     42            AND diffInputSkyfile.tess_id    = warpSkyfile.tess_id
     43        JOIN warpRun
     44            ON warpRun.warp_id = warpSkyfile.warp_id
     45        JOIN fakeRun
     46            USING(fake_id)
     47        JOIN camRun
     48            USING(cam_id)
     49        JOIN chipRun
     50            USING(chip_id)
     51        JOIN rawExp
     52            USING(exp_id)
     53        WHERE
     54            (diffRun.state = 'goto_cleaned' OR
     55             diffRun.state = 'goto_scrubbed' OR
     56             diffRun.state = 'goto_purged')
     57     UNION
     58     SELECT
     59            diffRun.diff_id,
     60            rawExp.camera,
     61            diffRun.state,
     62            diffRun.label
     63        FROM diffRun
     64        JOIN diffInputSkyfile
     65            USING(diff_id)
     66        JOIN stackSumSkyfile
     67            ON  diffInputSkyfile.stack1 = stackSumSkyfile.stack_id
     68        JOIN stackInputSkyfile
     69            ON diffInputSkyfile.stack1 = stackInputSkyfile.stack_id
     70        JOIN warpRun
     71            ON warpRun.warp_id = stackInputSkyfile.warp_id
     72        JOIN fakeRun
     73            USING(fake_id)
     74        JOIN camRun
     75            USING(cam_id)
     76        JOIN chipRun
     77            USING(chip_id)
     78        JOIN rawExp
     79            USING(exp_id)
     80        WHERE
     81            (diffRun.state = 'goto_cleaned' OR
     82             diffRun.state = 'goto_scrubbed' OR
     83             diffRun.state = 'goto_purged')
     84     UNION
     85     SELECT
     86            diffRun.diff_id,
     87            rawExp.camera,
     88            diffRun.state,
     89            diffRun.label
     90        FROM diffRun
     91        JOIN diffInputSkyfile
     92            USING(diff_id)
     93        JOIN stackSumSkyfile
     94            ON  diffInputSkyfile.stack2 = stackSumSkyfile.stack_id
     95        JOIN stackInputSkyfile
     96            ON diffInputSkyfile.stack2 = stackInputSkyfile.stack_id
     97        JOIN warpRun
     98            ON warpRun.warp_id = stackInputSkyfile.warp_id
     99        JOIN fakeRun
     100            USING(fake_id)
     101        JOIN camRun
     102            USING(cam_id)
     103        JOIN chipRun
     104            USING(chip_id)
     105        JOIN rawExp
     106            USING(exp_id)
     107        WHERE
     108            (diffRun.state = 'goto_cleaned' OR
     109             diffRun.state = 'goto_scrubbed' OR
     110             diffRun.state = 'goto_purged')
     111        ) as Foo
     112        WHERE 1
Note: See TracChangeset for help on using the changeset viewer.