IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Ignore:
Timestamp:
Apr 7, 2009, 4:19:58 PM (17 years ago)
Author:
bills
Message:

changes to make building distribution bundles for camera and fake stages work

File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/ippTools/share/disttool_toadvance.sql

    r23717 r23737  
    44    stage_id,
    55    outroot,
    6     label
     6    label,
     7    clean
    78FROM
    89    (
    … …  
    1314    stage_id,
    1415    outroot,
    15     label
     16    label,
     17    clean
    1618    FROM distRun
    1719    JOIN rawImfile ON stage_id = rawImfile.exp_id
    … …  
    3638    stage_id,
    3739    outroot,
    38     label
     40    label,
     41    clean
    3942    FROM distRun
    4043    JOIN chipProcessedImfile ON stage_id = chipProcessedImfile.chip_id
    … …  
    5356        AND SUM(distComponent.fault) = 0
    5457UNION
     58-- camera stage
     59SELECT distRun.dist_id,
     60    stage,
     61    stage_id,
     62    outroot,
     63    distRun.label,
     64    clean
     65    FROM distRun
     66    JOIN camRun ON stage_id = cam_id
     67    JOIN chipRun USING(chip_id)
     68    LEFT JOIN distComponent  USING(dist_id)
     69    WHERE
     70        distRun.state = 'new'
     71        AND distRun.fault = 0
     72        AND distComponent.fault = 0
     73        AND distRun.stage = 'camera'
     74--        AND ((chipRun.magicked AND camRun.state = 'full') OR distRun.no_magic)
     75--        AND (camRun.state = 'full' OR (distRun.clean and camRun.state = 'cleaned'))
     76UNION
     77-- fake stage
     78SELECT
     79    distRun.dist_id,
     80    stage,
     81    stage_id,
     82    outroot,
     83    label,
     84    clean
     85    FROM distRun
     86    JOIN fakeProcessedImfile ON stage_id = fakeProcessedImfile.fake_id
     87    LEFT JOIN distComponent
     88        ON distComponent.dist_id = distRun.dist_id
     89        AND distComponent.component = fakeProcessedImfile.class_id
     90    WHERE
     91        distRun.state = 'new'
     92        AND distRun.fault = 0
     93        AND distRun.stage = 'fake'
     94    GROUP BY
     95        dist_id,
     96        fakeProcessedImfile.fake_id
     97    HAVING
     98        COUNT(fakeProcessedImfile.class_id) = COUNT(distComponent.component)
     99        AND SUM(distComponent.fault) = 0
     100UNION
    55101-- warp stage
    56102SELECT
    … …  
    59105    stage_id,
    60106    outroot,
    61     label
     107    label,
     108    clean
    62109    FROM distRun
    63110    JOIN warpSkyfile on stage_id = warp_id
    … …  
    84131    stage_id,
    85132    outroot,
    86     label
     133    label,
     134    clean
    87135    FROM distRun
    88136    JOIN diffSkyfile
    … …  
    109157    stage_id,
    110158    outroot,
    111     label
     159    label,
     160    clean
    112161    FROM distRun
    113162    JOIN stackSumSkyfile on stage_id = stack_id
Note: See TracChangeset for help on using the changeset viewer.