IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changeset 23389 for trunk/ippTools/share


Ignore:
Timestamp:
Mar 18, 2009, 10:18:37 AM (17 years ago)
Author:
bills
Message:

change states from 'run' and 'stop' to 'new' and 'full'
add label to magicDSRun

Location:
trunk/ippTools/share
Files:
14 edited

Legend:

Unmodified
Added
Removed

  • trunk/ippTools/share/magicdstool_completed_runs.sql

    r20973 r23389  
    1212        AND magicDSFile.component = rawImfile.class_id
    1313    WHERE
    14         magicDSRun.state = 'run'
     14        magicDSRun.state = 'new'
    1515        AND magicDSRun.stage = 'raw'
    1616    GROUP BY
    … …  
    3030        AND magicDSFile.component = chipProcessedImfile.class_id
    3131    WHERE
    32         magicDSRun.state = 'run'
     32        magicDSRun.state = 'new'
    3333        AND magicDSRun.stage = 'chip'
    3434    GROUP BY
    … …  
    4848        AND magicDSFile.component = warpSkyfile.skycell_id
    4949    WHERE
    50         magicDSRun.state = 'run'
     50        magicDSRun.state = 'new'
    5151        AND magicDSRun.stage = 'warp'
    5252        AND warpSkyfile.fault = 0
    … …  
    7272        AND magicDSFile.component = diffSkyfile.skycell_id
    7373    WHERE
    74         magicDSRun.state = 'run'
     74        magicDSRun.state = 'new'
    7575        AND magicDSRun.stage = 'diff'
    7676        AND diffSkyfile.fault = 0

  • trunk/ippTools/share/magicdstool_todestreak.sql

    r20973 r23389  
    2626    AND magicDSFile.component = rawImfile.class_id
    2727WHERE
    28     magicDSRun.state = 'run'
     28    magicDSRun.state = 'new'
    2929    AND magicDSRun.stage = 'raw'
    3030    AND magicDSFile.component IS NULL
    … …  
    5757    AND magicDSFile.component = chipProcessedImfile.class_id
    5858WHERE
    59     magicDSRun.state = 'run'
     59    magicDSRun.state = 'new'
    6060    AND magicDSRun.stage = 'chip'
    6161    AND chipRun.state = 'full'
    … …  
    9191    AND magicDSFile.component = warpSkyfile.skycell_id
    9292WHERE
    93     magicDSRun.state = 'run'
     93    magicDSRun.state = 'new'
    9494    AND magicDSRun.stage = 'warp'
    9595    AND warpRun.state = 'full'
    … …  
    127127    AND magicDSFile.component = diffSkyfile.skycell_id
    128128WHERE
    129     magicDSRun.state = 'run'
     129    magicDSRun.state = 'new'
    130130    AND magicDSRun.stage = 'diff'
    131131    AND diffSkyfile.fault = 0

  • trunk/ippTools/share/magictool_addmask.sql

    r18526 r23389  
    22    magicRun
    33SET
    4     state = 'stop'
     4    state = 'full'
    55WHERE
    6     state != 'stop'
     6    state != 'full'

  • trunk/ippTools/share/magictool_chipprocessedimfile.sql

    r20706 r23389  
    2626    chipRun.state = 'full'
    2727    AND chipProcessedImfile.fault = 0
    28 --   AND magicRun.state = 'stop'
     28--   AND magicRun.state = 'full'
    2929--   AND magicMask.fault = 0

  • trunk/ippTools/share/magictool_diffskyfile.sql

    r20701 r23389  
    2424    diffRun.state = 'full'
    2525    AND diffSkyfile.fault = 0
    26 --   AND magicRun.state = 'stop'
     26--   AND magicRun.state = 'full'
    2727--   AND magicMask.fault = 0

  • trunk/ippTools/share/magictool_inputskyfile.sql

    r20973 r23389  
    99    AND magicInputSkyfile.node = diffSkyfile.skycell_id
    1010WHERE
    11     magicRun.state = 'run'
     11    magicRun.state = 'new'

  • trunk/ippTools/share/magictool_mask.sql

    r20735 r23389  
    66    USING(magic_id)
    77WHERE
    8     magicRun.state = 'stop'
     8    magicRun.state = 'full'
    99    AND magicMask.fault = 0

  • trunk/ippTools/share/magictool_rawimfile.sql

    r20706 r23389  
    2424WHERE
    2525    rawImfile.fault = 0
    26 --   AND magicRun.state = 'stop'
     26--   AND magicRun.state = 'full'
    2727--   AND magicMask.fault = 0

  • trunk/ippTools/share/magictool_tomask.sql

    r18781 r23389  
    1010LEFT JOIN magicNodeResult USING(magic_id, node)
    1111WHERE
    12     magicRun.state = 'run'
     12    magicRun.state = 'new'
    1313    AND magicNodeResult.node = 'root'
    1414    AND magicNodeResult.fault = 0

  • trunk/ippTools/share/magictool_toprocess_inputs.sql

    r21004 r23389  
    1919    AND magicTree.node = magicNodeResult.node
    2020WHERE
    21     magicRun.state = 'run'
     21    magicRun.state = 'new'
    2222    AND magicNodeResult.magic_id IS NULL
    2323    AND magicNodeResult.node IS NULL

  • trunk/ippTools/share/magictool_toprocess_tree.sql

    r21099 r23389  
    1515    AND magicTree.node = magicNodeResult.node
    1616WHERE
    17     magicRun.state = 'run'
     17    magicRun.state = 'new'
    1818    -- where hook %s
    1919ORDER BY

  • trunk/ippTools/share/magictool_toskyfilemask.sql

    r15348 r23389  
    77    USING(magic_id)
    88WHERE
    9     magicRun.state = 'run'
     9    magicRun.state = 'new'
    1010    AND magicSkyfileMask.magic_id IS NULL

  • trunk/ippTools/share/magictool_totree.sql

    r20474 r23389  
    1212    USING(magic_id)
    1313WHERE
    14     magicRun.state = 'run'
     14    magicRun.state = 'new'
    1515    AND magicTree.node IS NULL
    1616    AND magicRun.fault = 0

  • trunk/ippTools/share/magictool_warpskyfile.sql

    r20701 r23389  
    2121    warpRun.state = 'full'
    2222    AND warpSkyfile.fault = 0
    23 --   AND magicRun.state = 'stop'
     23--   AND magicRun.state = 'full'
    2424--   AND magicMask.fault = 0
Note: See TracChangeset for help on using the changeset viewer.