IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Ignore:
Timestamp:
Jan 12, 2007, 12:24:34 PM (19 years ago)
Author:
jhoblitt
Message:

catch renaming raw*Exp -> rawExp conversions
update p3tool to the 'new' fault handling semantics

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/ippTools/src/chiptool.c

    r11034 r11075  
    9999            "SELECT"
    100100            "   p2PendingImfile.*,"
    101             "   rawScienceExp.camera"
     101            "   rawExp.camera"
    102102            " FROM p2PendingImfile"
    103103            " JOIN p2PendingExp"
    104104            "   USING(exp_tag)"
    105             " JOIN rawScienceExp"
     105            " JOIN rawExp"
    106106            "   USING(exp_tag)"
    107107            " LEFT JOIN p2Mask"
     
    353353            "SELECT"
    354354            "   p2ProcessedImfile.*,"
    355             "   rawScienceExp.camera"
     355            "   rawExp.camera"
    356356            " FROM p2ProcessedImfile"
    357             " JOIN rawScienceExp"
     357            " JOIN rawExp"
    358358            "   USING(exp_tag)"
    359359            " WHERE "
     
    554554    // where exp_tag is not in p2PendingImfile
    555555    // where the number of entries in p2ProccessedImfile matches the .imfiles
    556     // entry in rawScienceExp
     556    // entry in rawExp
    557557    psString query = psStringCopy(
    558558        "SELECT DISTINCT"
    559559        "   p2PendingExp.*,"
    560         "   rawScienceExp.imfiles,"
     560        "   rawExp.imfiles,"
    561561        "   p2ProcessedImfile.class_id"
    562562        " FROM p2PendingExp"
    563         " JOIN rawScienceExp"
    564         "   ON p2PendingExp.exp_tag = rawScienceExp.exp_tag"
     563        " JOIN rawExp"
     564        "   ON p2PendingExp.exp_tag = rawExp.exp_tag"
    565565        " LEFT JOIN p2ProcessedExp"
    566566        "   ON p2PendingExp.exp_tag = p2ProcessedExp.exp_tag"
     
    575575        " GROUP BY"
    576576        "   p2PendingExp.exp_tag"
    577         " HAVING rawScienceExp.imfiles = COUNT(p2ProcessedImfile.class_id)"
     577        " HAVING rawExp.imfiles = COUNT(p2ProcessedImfile.class_id)"
    578578        );
    579579
     
    773773        pendingExp->p1_version,
    774774        pendingExp->p2_version,
    775         pendingExp->label,
    776         0   // fault code
     775        pendingExp->label
    777776    );
    778777}
Note: See TracChangeset for help on using the changeset viewer.