IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changeset 26815 for trunk/ippTools/share


Ignore:
Timestamp:
Feb 8, 2010, 4:06:45 PM (16 years ago)
Author:
watersc1
Message:

Edits for detrend cleanup.

Location:
trunk/ippTools/share
Files:
8 edited

Legend:

Unmodified
Added
Removed

  • trunk/ippTools/share/dettool_pendingcleanup_normalizedexp.sql

    r25324 r26815  
    1 SELECT
     1SELECT DISTINCT
    22    detNormalizedExp.*,
    33    rawExp.camera   
    4 FROM detRunSummary
    5 JOIN detNormalizedExp
    6     USING(det_id,iteration)
     4FROM detNormalizedExp
    75JOIN detInputExp
    8      USING(det_id,iteration)
     6     USING(det_id,exp_id)
    97JOIN rawExp
    108     USING(exp_id)
    119WHERE
    12     ((detRunSummary.data_state = 'goto_cleaned'
    13       AND detNormalizedExp.data_state = 'full')
    14      OR (detRunSummary.data_state = 'goto_scrubbed'
    15       AND detNormalizedExp.data_state = 'full')
    16      OR (detRunSummary.data_state = 'goto_purged'
    17       AND detNormalizedExp.data_state = 'full')
    18      OR detNormalizedExp.data_state = 'goto_cleaned'
     10    (detNormalizedExp.data_state = 'goto_cleaned'
    1911     OR detNormalizedExp.data_state = 'goto_scrubbed'
    2012     OR detNormalizedExp.data_state = 'goto_purged')

  • trunk/ippTools/share/dettool_pendingcleanup_normalizedimfile.sql

    r25324 r26815  
    22    detNormalizedImfile.*,
    33    rawExp.camera
    4 FROM detRunSummary
    5 JOIN detNormalizedImfile
    6     USING(det_id,iteration)
     4FROM detNormalizedImfile
    75JOIN detInputExp
    8      USING(det_id,iteration)
     6     USING(det_id,exp_id)
    97JOIN rawExp
    108     USING(exp_id)
    119WHERE
    12     ((detRunSummary.data_state = 'goto_cleaned'
    13       AND detNormalizedImfile.data_state = 'full')
    14      OR (detRunSummary.data_state = 'goto_scrubbed'
    15       AND detNormalizedImfile.data_state = 'full')
    16      OR (detRunSummary.data_state = 'goto_purged'
    17       AND detNormalizedImfile.data_state = 'full')
    18      OR detNormalizedImfile.data_state = 'goto_cleaned'
     10    (detNormalizedImfile.data_state = 'goto_cleaned'
    1911     OR detNormalizedImfile.data_state = 'goto_scrubbed'
    2012     OR detNormalizedImfile.data_state = 'goto_purged')

  • trunk/ippTools/share/dettool_pendingcleanup_normalizedstat.sql

    r25324 r26815  
    22    detNormalizedStatImfile.*,
    33    rawExp.camera
    4 FROM detRunSummary
    5 JOIN detNormalizedStatImfile
    6     USING(det_id,iteration)
     4FROM detNormalizedStatImfile
    75JOIN detInputExp
    8      USING(det_id,iteration)
     6     USING(det_id,exp_id)
    97JOIN rawExp
    108     USING(exp_id)
    119WHERE
    12     ((detRunSummary.data_state = 'goto_cleaned'
    13       AND detNormalizedStatImfile.data_state = 'full')
    14      OR (detRunSummary.data_state = 'goto_scrubbed'
    15       AND detNormalizedStatImfile.data_state = 'full')
    16      OR (detRunSummary.data_state = 'goto_purged'
    17       AND detNormalizedStatImfile.data_state = 'full')
    18      OR detNormalizedStatImfile.data_state = 'goto_cleaned'
     10    (detNormalizedStatImfile.data_state = 'goto_cleaned'
    1911     OR detNormalizedStatImfile.data_state = 'goto_scrubbed'
    2012     OR detNormalizedStatImfile.data_state = 'goto_purged')

  • trunk/ippTools/share/dettool_pendingcleanup_processedexp.sql

    r25324 r26815  
    11-- need to restrict to a single detRunSummary (require all to say 'cleaned'?)
    2 SELECT
     2SELECT DISTINCT
    33    detProcessedExp.*,
    44    rawExp.camera
    5 FROM detRunSummary
    6 JOIN detProcessedExp
    7     USING(det_id)
     5FROM detProcessedExp
     6JOIN detInputExp
     7     USING(det_id,exp_id)
    88JOIN rawExp
    99     USING(exp_id)
    1010WHERE
    11     ((detRunSummary.data_state = 'goto_cleaned'
    12       AND detProcessedExp.data_state = 'full')
    13      OR (detRunSummary.data_state = 'goto_scrubbed'
    14          AND detProcessedExp.data_state = 'full')
    15      OR (detRunSummary.data_state = 'goto_purged'
    16          AND detProcessedExp.data_state = 'full')
    17      OR detProcessedExp.data_state = 'goto_cleaned'
     11    (detProcessedExp.data_state = 'goto_cleaned'
    1812     OR detProcessedExp.data_state = 'goto_scrubbed'
    1913     OR detProcessedExp.data_state = 'goto_purged')

  • trunk/ippTools/share/dettool_pendingcleanup_processedimfile.sql

    r25324 r26815  
    1 SELECT
     1SELECT DISTINCT
    22    detProcessedImfile.*,
    33    rawExp.camera
    4 FROM detRunSummary
    5 JOIN detProcessedImfile
    6     USING(det_id)
     4    FROM detProcessedImfile
    75JOIN detInputExp
    8      USING(det_id,iteration,exp_id)
     6     USING(det_id,exp_id)
    97JOIN rawExp
    108     USING(exp_id)

  • trunk/ippTools/share/dettool_pendingcleanup_residexp.sql

    r25324 r26815  
    1 SELECT
     1SELECT DISTINCT
    22    detResidExp.*,
    33    rawExp.camera
    4 FROM detRunSummary
    5 JOIN detResidExp
    6     USING(det_id,iteration)
     4FROM detResidExp
    75JOIN detInputExp
    8      USING(det_id,iteration,exp_id)
     6     USING(det_id,exp_id)
    97JOIN rawExp
    108    USING(exp_id)
    119WHERE
    12     ((detRunSummary.data_state = 'goto_cleaned'
    13       AND detResidExp.data_state = 'full')
    14      OR (detRunSummary.data_state = 'goto_scrubbed'
    15          AND detResidExp.data_state = 'full')
    16      OR (detRunSummary.data_state = 'goto_purged'
    17          AND detResidExp.data_state = 'full')
    18      OR detResidExp.data_state = 'goto_cleaned'
     10    (detResidExp.data_state = 'goto_cleaned'
    1911     OR detResidExp.data_state = 'goto_scrubbed'
    2012     OR detResidExp.data_state = 'goto_purged')

  • trunk/ippTools/share/dettool_pendingcleanup_residimfile.sql

    r25324 r26815  
    1 SELECT
     1SELECT DISTINCT
    22    detResidImfile.*,
    33    rawExp.camera
    4 FROM detRunSummary
    5 JOIN detResidImfile
    6     USING(det_id,iteration)
     4FROM detResidImfile
    75JOIN detInputExp
    8     USING(det_id,iteration,exp_id)
     6    USING(det_id,exp_id)
    97JOIN rawExp
    108    USING(exp_id)
    119WHERE
    12     ((detRunSummary.data_state = 'goto_cleaned'
    13       AND detResidImfile.data_state = 'full')
    14      OR (detRunSummary.data_state = 'goto_scrubbed'
    15       AND detResidImfile.data_state = 'full')
    16      OR (detRunSummary.data_state = 'goto_purged'
    17       AND detResidImfile.data_state = 'full')
    18      OR detResidImfile.data_state = 'goto_cleaned'
     10    (detResidImfile.data_state = 'goto_cleaned'
    1911     OR detResidImfile.data_state = 'goto_scrubbed'
    2012     OR detResidImfile.data_state = 'goto_purged')

  • trunk/ippTools/share/dettool_pendingcleanup_stacked.sql

    r25324 r26815  
    1 SELECT DISTINCT
     1ySELECT DISTINCT
    22    detStackedImfile.*,
    33    rawExp.camera
    4 FROM detRunSummary
    5 JOIN detStackedImfile
    6      USING(det_id,iteration)
     4FROM detStackedImfile
    75JOIN detInputExp
    8      USING(det_id,iteration)
     6     USING(det_id,exp_id)
    97JOIN rawExp
    108     USING(exp_id)
    119WHERE
    12     ((detRunSummary.data_state = 'goto_cleaned'
    13       AND detStackedImfile.data_state = 'full')
    14      OR (detRunSummary.data_state = 'goto_scrubbed'
    15       AND detStackedImfile.data_state = 'full')
    16      OR (detRunSummary.data_state = 'goto_purged'
    17       AND detStackedImfile.data_state = 'full')
    18      OR detStackedImfile.data_state = 'goto_cleaned'
     10    (detStackedImfile.data_state = 'goto_cleaned'
    1911     OR detStackedImfile.data_state = 'goto_scrubbed'
    2012     OR detStackedImfile.data_state = 'goto_purged')
Note: See TracChangeset for help on using the changeset viewer.