IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Ignore:
Timestamp:
Mar 23, 2010, 3:31:48 PM (16 years ago)
Author:
bills
Message:

revert back to the previous version, by skycell update isn't ready yet

File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/ippTools/share/warptool_towarped.sql

    r27391 r27418  
    1 SELECT
    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
    14 FROM (
    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'
     1SELECT 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
     14FROM warpRun
     15JOIN warpSkyCellMap
     16    USING(warp_id)
     17JOIN warpImfile
     18    ON warpSkyCellMap.warp_id = warpImfile.warp_id
     19    AND warpSkyCellMap.skycell_id = warpImfile.skycell_id
     20JOIN fakeRun
     21    USING(fake_id)
     22JOIN camRun
     23    USING(cam_id)
     24JOIN chipRun
     25    USING(chip_id)
     26JOIN chipProcessedImfile
     27    USING(chip_id)
     28JOIN rawExp
     29    ON chipRun.exp_id = rawExp.exp_id
     30LEFT 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
     34LEFT JOIN warpMask
     35    ON warpRun.label = warpMask.label
     36WHERE
     37    ((warpRun.state = 'new'
    5238        AND warpSkyfile.warp_id IS NULL
    5339        AND warpSkyfile.skycell_id IS NULL
    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
    62 UNION
    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         -- where hook 2 %s
    93     GROUP BY warp_id, skycell_id
    94     HAVING COUNT(warpSkyCellMap.class_id) = COUNT(chipProcessedImfile.class_id)
    95 ) as towarped
    96 
     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
Note: See TracChangeset for help on using the changeset viewer.