IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changeset 12259 for trunk/ippTools/share


Ignore:
Timestamp:
Mar 5, 2007, 5:41:11 PM (19 years ago)
Author:
jhoblitt
Message:

split detselect SQL out into their own files
add rawExp.filelevel field

Location:
trunk/ippTools/share
Files:
2 added
7 edited

Legend:

Unmodified
Added
Removed

  • trunk/ippTools/share/Makefile.am

    r12237 r12259  
    1111        chiptool_queuerawexp.sql \
    1212        chiptool_queuerawimfile.sql \
     13        detselect_search.sql \
     14        detselect_select.sql \
    1315        regtool_find_unprocessed_exp.sql \
    1416        regtool_find_unprocessed_imfile.sql \
    … …  
    1820        regtool_processedimfile.sql \
    1921        warptool_tooverlap.sql
     22

  • trunk/ippTools/share/camtool_find_pendingexp.sql

    r12254 r12259  
    77    rawExp.exp_id,
    88    rawExp.camera,
    9     rawExp.telescope
     9    rawExp.telescope,
     10    rawExp.filelevel
    1011FROM camPendingExp
    1112JOIN chipProcessedExp

  • trunk/ippTools/share/camtool_find_pendingimfile.sql

    r12233 r12259  
    1414        rawExp.exp_id,
    1515        rawExp.camera,
    16         rawExp.telescope
     16        rawExp.telescope,
     17        rawExp.filelevel
    1718    FROM camPendingExp
    1819    JOIN chipProcessedExp

  • trunk/ippTools/share/camtool_find_processedexp.sql

    r12189 r12259  
    11SELECT
    22    camProcessedExp.*,
     3    rawExp.exp_id,
    34    rawExp.camera,
    4     rawExp.workdir
     5    rawExp.telescope,
     6    rawExp.filelevel
    57FROM camProcessedExp
    68JOIN chipProcessedExp

  • trunk/ippTools/share/chiptool_pendingimfile.sql

    r12226 r12259  
    55    rawExp.exp_id,
    66    rawExp.camera,
    7     rawExp.telescope
     7    rawExp.telescope,
     8    rawExp.filelevel
    89FROM chipPendingImfile
    910JOIN chipPendingExp

  • trunk/ippTools/share/chiptool_processedimfile.sql

    r12226 r12259  
    99    rawExp.exp_id,
    1010    rawExp.camera,
    11     rawExp.telescope
     11    rawExp.telescope,
     12    rawExp.filelevel
    1213FROM chipProcessedImfile
    1314JOIN chipProcessedExp

  • trunk/ippTools/share/regtool_processedimfile.sql

    r12086 r12259  
    11SELECT
    2     *
     2    rawImfile.*
     3    rawExp.exp_id,
     4    rawExp.camera,
     5    rawExp.telescope,
     6    rawExp.filelevel,
     7    rawExp.workdir
    38FROM rawImfile
     9JOIN rawExp
     10    USING(exp_tag)
    411-- bogus conditional so there is a where clause to append to
    512WHERE rawImfile.exp_tag is NOT NULL
Note: See TracChangeset for help on using the changeset viewer.