IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Ignore:
Timestamp:
Mar 23, 2010, 4:08:29 PM (16 years ago)
Author:
bills
Message:

restore sql

File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/ippTools/share/warptool_towarped.sql

    r27418 r27419  
    1 SELECT DISTINCT
    2     warpSkyCellMap.warp_id,
    3     warpImfile.warp_skyfile_id,
    4     warpSkyCellMap.skycell_id,
    5     warpSkyCellMap.tess_id,
    6     warpRun.fake_id,
    7     warpRun.state,
    8     warpRun.reduction,
    9     camRun.cam_id,
    10     rawExp.camera,
    11     rawExp.exp_tag,
    12     warpRun.workdir,
    13     chipRun.magicked
    14 FROM warpRun
    15 JOIN warpSkyCellMap
    16     USING(warp_id)
    17 JOIN warpImfile
    18     ON warpSkyCellMap.warp_id = warpImfile.warp_id
    19     AND warpSkyCellMap.skycell_id = warpImfile.skycell_id
    20 JOIN fakeRun
    21     USING(fake_id)
    22 JOIN camRun
    23     USING(cam_id)
    24 JOIN chipRun
    25     USING(chip_id)
    26 JOIN chipProcessedImfile
    27     USING(chip_id)
    28 JOIN rawExp
    29     ON chipRun.exp_id = rawExp.exp_id
    30 LEFT JOIN warpSkyfile
    31     ON warpRun.warp_id = warpSkyfile.warp_id
    32     AND warpSkyCellMap.skycell_id = warpSkyfile.skycell_id
    33     AND warpSkyCellMap.tess_id = warpSkyfile.tess_id
    34 LEFT JOIN warpMask
    35     ON warpRun.label = warpMask.label
    36 WHERE
    37     ((warpRun.state = 'new'
     1SELECT
     2    warp_id,
     3    warp_skyfile_id,
     4    skycell_id,
     5    tess_id,
     6    fake_id,
     7    state,
     8    reduction,
     9    cam_id,
     10    camera,
     11    exp_tag,
     12    workdir,
     13    magicked
     14FROM (
     15    SELECT
     16        warpSkyCellMap.warp_id,
     17        warpImfile.warp_skyfile_id,
     18        warpSkyCellMap.skycell_id,
     19        warpSkyCellMap.tess_id,
     20        warpRun.fake_id,
     21        warpRun.state,
     22        warpRun.reduction,
     23        camRun.cam_id,
     24        rawExp.camera,
     25        rawExp.exp_tag,
     26        warpRun.workdir,
     27        chipRun.magicked
     28    FROM warpRun
     29    JOIN warpSkyCellMap
     30        USING(warp_id)
     31    JOIN warpImfile
     32        ON warpSkyCellMap.warp_id = warpImfile.warp_id
     33        AND warpSkyCellMap.skycell_id = warpImfile.skycell_id
     34    JOIN fakeRun
     35        USING(fake_id)
     36    JOIN camRun
     37        USING(cam_id)
     38    JOIN chipRun
     39        USING(chip_id)
     40    JOIN chipProcessedImfile
     41        USING(chip_id)
     42    JOIN rawExp
     43        ON chipRun.exp_id = rawExp.exp_id
     44    LEFT JOIN warpSkyfile
     45        ON warpRun.warp_id = warpSkyfile.warp_id
     46        AND warpSkyCellMap.skycell_id = warpSkyfile.skycell_id
     47        AND warpSkyCellMap.tess_id = warpSkyfile.tess_id
     48    LEFT JOIN warpMask
     49        ON warpRun.label = warpMask.label
     50    WHERE
     51        warpRun.state = 'new'
    3852        AND warpSkyfile.warp_id IS NULL
    3953        AND warpSkyfile.skycell_id IS NULL
    40         AND warpSkyfile.tess_id IS NULL)
    41     OR (warpRun.state = 'update'
    42         AND warpSkyfile.data_state = 'cleaned')
    43     )
    44     AND fakeRun.state = 'full'
    45     AND camRun.state = 'full'
    46     AND chipRun.state = 'full'
    47     AND warpMask.label IS NULL
    48     AND warpSkyCellMap.fault = 0
     54        AND warpSkyfile.tess_id IS NULL
     55        AND fakeRun.state = 'full'
     56        AND camRun.state = 'full'
     57        AND chipRun.state = 'full'
     58        AND warpMask.label IS NULL
     59        AND warpSkyCellMap.fault = 0
     60        -- where hook 1 %s
     61    GROUP BY warp_id, skycell_id
     62UNION
     63    SELECT
     64        warpSkyCellMap.warp_id,
     65        warpImfile.warp_skyfile_id,
     66        warpSkyCellMap.skycell_id,
     67        warpSkyCellMap.tess_id,
     68        warpRun.fake_id,
     69        warpRun.state,
     70        warpRun.reduction,
     71        camRun.cam_id,
     72        rawExp.camera,
     73        rawExp.exp_tag,
     74        warpRun.workdir,
     75        MIN(chipProcessedImfile.magicked) AS magicked
     76    FROM warpRun
     77    JOIN warpSkyCellMap USING(warp_id)
     78    JOIN warpImfile USING(warp_id, skycell_id)
     79    JOIN warpSkyfile USING(warp_id, skycell_id)
     80    JOIN fakeRun USING(fake_id)
     81    JOIN camRun USING(cam_id)
     82    JOIN chipRun USING(chip_id)
     83    JOIN rawExp USING(exp_id)
     84    LEFT JOIN chipProcessedImfile USING(chip_id, class_id)
     85    WHERE warpRun.state = 'update'
     86        AND warpSkyfile.data_state = 'update'
     87        AND camRun.state = 'full'
     88        AND chipProcessedImfile.data_state = 'full'
     89        -- if warpSkyfile was magicked previously require inputs to be magicked
     90        -- this blocks processing until all the chip inputs have been destreaked
     91        AND (warpSkyfile.magicked = 0 OR chipProcessedImfile.magicked >= 0)
     92        AND (warpSkyfile.magicked = 0 OR chipRun.magicked >= 0)
     93        -- where hook 2 %s
     94    GROUP BY warp_id, skycell_id
     95    HAVING COUNT(warpSkyCellMap.class_id) = COUNT(chipProcessedImfile.class_id)
     96) as towarped
     97
Note: See TracChangeset for help on using the changeset viewer.