IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changeset 27945


Ignore:
Timestamp:
May 13, 2010, 10:55:26 AM (16 years ago)
Author:
bills
Message:

include stageRun.magicked for magicdstool -todestreak and -torevert.
(It will be -1 if the data was destreaked but cleaned up)

Location:
trunk/ippTools/share
Files:
10 edited

Legend:

Unmodified
Added
Removed

  • trunk/ippTools/share/magicdstool_todestreak_camera.sql

    r27301 r27945  
    33    magicDSRun.magic_id,
    44    chipRun.exp_id,
     5    camRun.magicked,
    56    magicDSRun.label,
    67    camera,

  • trunk/ippTools/share/magicdstool_todestreak_chip.sql

    r27747 r27945  
    33    magicDSRun.magic_id,
    44    chipRun.exp_id,
     5    chipRun.magicked,
    56    magicDSRun.label,
    67    camera,

  • trunk/ippTools/share/magicdstool_todestreak_diff.sql

    r27476 r27945  
    1010    stage,
    1111    magicRun.diff_id AS stage_id,
     12    diffRun.magicked,
    1213    diffSkyfile.skycell_id AS component,
    1314    CAST(NULL AS CHAR(255)) AS uri,
    … …  
    4748    magicDSRun.label,
    4849    rawExp.camera,
    49     magicMask.uri as streaks_uri,
     50    magicMask.uri AS streaks_uri,
    5051    (SELECT uri from magicMask where magic_id = inv_magic_id) AS inv_streaks_uri,
    5152    stage,
    52     magicRun.diff_id as stage_id,
    53     diffSkyfile.skycell_id as component,
     53    magicRun.diff_id AS stage_id,
     54    diffRun.magicked,
     55    diffSkyfile.skycell_id AS component,
    5456    CAST(NULL AS CHAR(255)) AS uri,
    5557    diffSkyfile.path_base,
    5658    magicRun.inverse,
    57     CAST(NULL AS CHAR(255)) as cam_path_base,
     59    CAST(NULL AS CHAR(255)) AS cam_path_base,
    5860    CAST(NULL AS CHAR(255)) AS cam_reduction,
    5961    outroot,
    … …  
    8082    AND diffSkyfile.quality = 0
    8183    AND magicDSFile.component IS NULL
    82 ) as magicDSRun
     84) AS magicDSRun
    8385-- we need the following so this query is compatible with the other stages
    8486WHERE magic_ds_id IS NOT NULL

  • trunk/ippTools/share/magicdstool_todestreak_raw.sql

    r27454 r27945  
    44    magicRun.exp_id,
    55    magicDSRun.label,
    6     camera,
     6    rawExp.camera,
    77    magicMask.uri as streaks_uri,
    88    CAST(NULL AS CHAR(255)) AS inv_streaks_uri,
    99    stage,
    1010    stage_id,
     11    rawExp.magicked,
    1112    class_id as component,
    1213    rawImfile.uri AS uri,
    … …  
    2526JOIN camRun USING(cam_id)
    2627JOIN camProcessedExp USING(cam_id)
    27 JOIN rawImfile ON magicRun.exp_id = rawImfile.exp_id
     28JOIN rawExp ON magicRun.exp_id = rawExp.exp_id
     29JOIN rawImfile ON rawExp.exp_id = rawImfile.exp_id
    2830LEFT JOIN magicDSFile
    2931    ON magicDSRun.magic_ds_id = magicDSFile.magic_ds_id

  • trunk/ippTools/share/magicdstool_todestreak_warp.sql

    r27301 r27945  
    99    stage,
    1010    stage_id,
     11    warpRun.magicked,
    1112    warpSkyfile.skycell_id as component,
    1213    warpSkyfile.uri,

  • trunk/ippTools/share/magicdstool_torevert_camera.sql

    r27015 r27945  
    1313    0 AS bothways,
    1414    0 AS bytes,
    15     0 AS md5sum
     15    0 AS md5sum,
     16    camRun.magicked
    1617FROM magicDSRun
    1718    JOIN magicDSFile using(magic_ds_id)

  • trunk/ippTools/share/magicdstool_torevert_chip.sql

    r27015 r27945  
    1313    0 AS bothways,
    1414    0 AS bytes,
    15     0 AS md5sum
     15    0 AS md5sum,
     16    chipRun.magicked
    1617FROM magicDSRun
    1718    JOIN magicDSFile using(magic_ds_id)
    1819    JOIN camProcessedExp using(cam_id)
    19     JOIN chipProcessedImfile ON (stage_id = chipProcessedImfile.chip_id AND component = class_id)
     20    JOIN chipRun ON (stage_id = chipRun.chip_id)
     21    -- JOIN chipProcessedImfile ON (stage_id = chipProcessedImfile.chip_id AND component = class_id)
     22    JOIN chipProcessedImfile USING(chip_id, exp_id)
    2023    JOIN rawExp using(exp_id)
    2124WHERE magicDSRun.stage = 'chip'

  • trunk/ippTools/share/magicdstool_torevert_diff.sql

    r27015 r27945  
    1313    CAST(diffRun.bothways AS SIGNED) AS bothways,
    1414    0 AS bytes,
    15     0 AS md5sum
     15    0 AS md5sum,
     16    diffRun.magicked
    1617FROM magicDSRun
    1718    JOIN magicRun using(magic_id)

  • trunk/ippTools/share/magicdstool_torevert_raw.sql

    r27015 r27945  
    1010    outroot,
    1111    rawImfile.uri AS path_base,
    12     NULL AS cam_path_base,
     12    CAST(NULL AS CHAR(255)) AS cam_path_base,
    1313    0 AS bothways,
    1414    bytes,
    15     md5sum
     15    md5sum,
     16    0 AS magicked
    1617FROM magicDSRun
    1718    JOIN magicDSFile using(magic_ds_id)

  • trunk/ippTools/share/magicdstool_torevert_warp.sql

    r27015 r27945  
    1313    0 AS bothways,
    1414    0 AS bytes,
    15     0 AS md5sum
     15    0 AS md5sum,
     16    warpRun.magicked
    1617FROM magicDSRun
    1718    JOIN magicDSFile USING(magic_ds_id)
Note: See TracChangeset for help on using the changeset viewer.