IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changeset 28428 for trunk/ippTools/share


Ignore:
Timestamp:
Jun 22, 2010, 10:02:25 PM (16 years ago)
Author:
Paul Price
Message:

Make diffphot respect/propagate magic status. No 'destreaking' set up to run on diffphot yet; we just inherit the magic status of the parent diffRun.

Location:
trunk/ippTools/share
Files:
6 edited

Legend:

Unmodified
Added
Removed

  • trunk/ippTools/share/diffphottool_advance.sql

    r28414 r28428  
    11SELECT
    2     diff_phot_id
     2    diff_phot_id,
     3    magicked
    34FROM diffPhotRun
    45JOIN diffSkyfile USING(diff_id)

  • trunk/ippTools/share/diffphottool_input.sql

    r28367 r28428  
    22    diffPhotRun.*,
    33    diffSkyfile.path_base,
     4    diffSkyfile.magicked,
    45    diffRun.bothways,
    56    rawExp.camera

  • trunk/ippTools/share/diffphottool_pending.sql

    r28367 r28428  
    99WHERE diffPhotSkyfile.skycell_id IS NULL
    1010    AND diffRun.state = 'full'
     11    AND diffSkyfile.magicked >= 0
    1112    AND diffSkyfile.fault = 0
    1213    AND diffSkyfile.quality = 0

  • trunk/ippTools/share/pubtool_definerun.sql

    r28411 r28428  
    5656        AND publishClient.active = 1
    5757        AND diffPhotRun.state IN ('full', 'cleaned', 'goto_cleaned')
    58         AND (diffRun.diff_mode = 4 OR publishClient.magicked = 0) -- diffPhotRun doesn't respect magic
     58        AND (diffPhotRun.magicked != 0 OR diffRun.diff_mode = 4 OR publishClient.magicked = 0)
    5959    -- WHERE hook %s
    6060    ) AS publishToDo

  • trunk/ippTools/share/pubtool_pending.sql

    r28411 r28428  
    7474        AND publishRun.state = 'new'
    7575        AND diffPhotRun.state IN ('full', 'cleaned', 'goto_cleaned')
    76         AND (diffRun.diff_mode = 4 OR publishClient.magicked = 0) -- diffPhotRun doesn't respect magic
     76        AND (diffPhotRun.magicked != 0 OR diffRun.diff_mode = 4 OR publishClient.magicked = 0)
    7777        -- WHERE hook %s
    7878) AS publishToDo

  • trunk/ippTools/share/pxadmin_create_tables.sql

    r28375 r28428  
    17551755    quality SMALLINT NOT NULL,       -- bad quality flag
    17561756    software_ver VARCHAR(16),                       -- software version
     1757    magicked BIGINT NOT NULL DEFAULT 0, -- magic mask applied
    17571758    PRIMARY KEY(diff_phot_id, skycell_id),
    17581759    KEY(fault),
Note: See TracChangeset for help on using the changeset viewer.