IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changeset 18573 for trunk/ippTools/share


Ignore:
Timestamp:
Jul 15, 2008, 4:16:16 PM (18 years ago)
Author:
Paul Price
Message:

Adding revert options, fault code handling.

Location:
trunk/ippTools/share
Files:
3 edited

Legend:

Unmodified
Added
Removed

  • trunk/ippTools/share/magictool_inputs.sql

    r18526 r18573  
    33-- Single skycells
    44SELECT
     5    magicRun.magic_id,
     6    magicRun.state,
    57    magicInputSkyfile.node,
    6     magicRun.state,
    78    diffSkyfile.uri,
    89    diffSkyfile.fault
    910FROM magicInputSkyfile
    1011JOIN diffSkyfile
    11     using(diff_id)
     12    USING(diff_id)
    1213JOIN magicRun
    1314    USING(magic_id)
    … …  
    1516-- Merged skycells
    1617SELECT
     18    magicRun.magic_id,
     19    magicRun.state,
    1720    magicTree.node,
    18     magicRun.state,
    1921    magicNodeResult.uri,
    2022    magicNodeResult.fault

  • trunk/ippTools/share/magictool_tomask.sql

    r15351 r18573  
    1010    magicRun.state = 'run'
    1111    AND magicNodeResult.node = 'root'
     12    AND magicNodeResult.fault = 0
    1213GROUP BY
    1314    magic_id

  • trunk/ippTools/share/magictool_toprocess_tree.sql

    r18524 r18573  
    33    -- convert magic_id into a boolean value (1 or 0)
    44    -- note that the type stays a 64 bit int
    5     magicNodeResult.magic_id IS TRUE as done
     5    magicNodeResult.magic_id IS TRUE as done,
     6    magicNodeResult.fault IS TRUE as bad
    67FROM magicTree
    78JOIN magicRun
Note: See TracChangeset for help on using the changeset viewer.