IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changeset 25513


Ignore:
Timestamp:
Sep 23, 2009, 2:14:11 PM (17 years ago)
Author:
bills
Message:

add magic_ds_id to distRun so that we can find them to censor
if necessary

Location:
trunk
Files:
12 edited

Legend:

Unmodified
Added
Removed

  • trunk/dbconfig/changes.txt

    r25500 r25513  
    12961296-- This change is new
    12971297ALTER TABLE pstampRequest ADD COLUMN label VARCHAR(64) AFTER reqType;
     1298
     1299ALTER TABLE distRun ADD COLUMN magic_ds_id BIGINT AFTER stage_id;

  • trunk/dbconfig/dist.md

    r24725 r25513  
    1414    stage       STR         64
    1515    stage_id    S64         0
     16    magic_ds_id S64         0
    1617    label       STR         64      # Key
    1718    outroot     STR         255

  • trunk/ippTools/share/disttool_definebyquery_camera.sql

    r24789 r25513  
    33    camRun.cam_id as stage_id,
    44    rawExp.exp_name as run_tag,
     5    camRun.magicked,
    56    distTarget.label,
    67    distTarget.target_id,

  • trunk/ippTools/share/disttool_definebyquery_chip.sql

    r24789 r25513  
    22    'chip' as stage,
    33    chipRun.chip_id as stage_id,
     4    chipRun.magicked,
    45    rawExp.exp_name as run_tag,
    56    chipRun.label,

  • trunk/ippTools/share/disttool_definebyquery_diff.sql

    r24725 r25513  
    22    'diff' as stage,
    33    diffRun.diff_id AS stage_id,
     4    diffRun.magicked,
    45    rawExp.exp_name as run_tag,
    56    distTarget.label,

  • trunk/ippTools/share/disttool_definebyquery_fake.sql

    r24789 r25513  
    22    'fake' as stage,
    33    fakeRun.fake_id AS stage_id,
     4    CAST(0 AS BIGINT) AS magicked,
    45    rawExp.exp_name as run_tag,
    56    distTarget.label,

  • trunk/ippTools/share/disttool_definebyquery_raw.sql

    r24725 r25513  
    33    rawExp.exp_id AS stage_id,
    44    rawExp.exp_name AS run_tag,
     5    rawExp.magicked,
    56    distTarget.label,
    67    distTarget.target_id,

  • trunk/ippTools/share/disttool_definebyquery_stack.sql

    r25428 r25513  
    22    'stack' as stage,
    33    stackRun.stack_id AS stage_id,
     4    CAST(0 AS BIGINT AS magicked,
    45    -- run tag in the form 'stack.$skycell_id.$stack_id'
    56    CONCAT_WS('.', 'stack', stackRun.skycell_id, convert(stackRun.stack_id, CHAR)) as run_tag,

  • trunk/ippTools/share/disttool_definebyquery_warp.sql

    r24789 r25513  
    22    'warp' as stage,
    33    warpRun.warp_id AS stage_id,
     4    warpRun.magicked,
    45    rawExp.exp_name as run_tag,
    56    distTarget.label,

  • trunk/ippTools/share/pxadmin_create_tables.sql

    r25493 r25513  
    12711271    stage       VARCHAR(64),
    12721272    stage_id    BIGINT,
     1273    magic_ds_id BIGINT,
    12731274    label       VARCHAR(64),
    12741275    outroot     VARCHAR(255),

  • trunk/ippTools/src/disttool.c

    r25510 r25513  
    150150            stage,
    151151            stage_id,
     152            0,
    152153            set_label,
    153154            outroot,
    … …  
    376377        psString run_tag = psMetadataLookupStr(NULL, md, "run_tag");
    377378        psS64 stage_id = psMetadataLookupS64(NULL, md, "stage_id");
     379        psS64 magic_ds_id = psMetadataLookupS64(NULL, md, "magicked");
    378380        psS64 target_id = psMetadataLookupS64(NULL, md, "target_id");
    379381        psString target_label = psMetadataLookupStr(NULL, md, "label");
    … …  
    394396                stage,
    395397                stage_id,
     398                magic_ds_id,
    396399                new_label,
    397400                outroot,

  • trunk/ippTools/src/magicdstool.c

    r25492 r25513  
    269269                outroot,
    270270                recoveryroot,
    271                 noreplace ? 0 :1,
     271                noreplace ? 0 :1,   // re_place
    272272                0); // remove
    273273
Note: See TracChangeset for help on using the changeset viewer.