Changeset 18561 for trunk/ippTools/share

Timestamp:

Jul 15, 2008, 10:30:59 AM (18 years ago)

Author:

eugene

Message:

completely deprecate config->where; make all command-line handling consistent; move nearly all sql into share/*.sql; ensure consistency between args supplied and used

Location:

trunk/ippTools/share

Files:

• Makefile.am (modified) (6 diffs)
• dettool_addprocessedexp.sql (added)
• dettool_childlessrun.sql (added)
• dettool_definebydetrun.sql (added)
• dettool_detrunsummary.sql (added)
• dettool_input.sql (added)
• dettool_normalizedexp.sql (added)
• dettool_normalizedimfile.sql (added)
• dettool_pending.sql (added)
• dettool_processedimfile.sql (added)
• dettool_residexp.sql (added)
• dettool_residimfile.sql (added)
• dettool_stacked.sql (added)
• dettool_tonormalize.sql (added)
• dettool_tonormalizedexp.sql (modified) (1 diff)
• dettool_toresidexp.sql (modified) (1 diff)
• dettool_toresidimfile.sql (modified) (2 diffs)
• difftool_queue.sql (modified) (1 diff)
• magictool_create_tmp_warpcomplete.sql (added)
• pstamptool_addjob_otherjob.sql (added)
• pstamptool_addjob_stampjob.sql (added)
• pstamptool_datastore.sql (added)
• pstamptool_pendingjob.sql (added)
• pstamptool_pendingreq.sql (added)

trunk/ippTools/share/Makefile.am

@@ -10 +10 @@
         chiptool_donecleanup.sql \
         chiptool_find_rawexp.sql \
-        chiptool_find_unprocessed_imfile.pl \
+        chiptool_pendingcleanupimfile.sql \
         chiptool_pendingcleanuprun.sql \
-        chiptool_pendingcleanupimfile.sql \
         chiptool_pendingimfile.sql \
         chiptool_processedimfile.sql \
+        chiptool_revertprocessedimfile.sql \
         chiptool_run.sql \
-        chiptool_revertprocessedimfile.sql \
         chiptool_unmasked.sql \
         detselect_search.sql \
         detselect_select.sql \
+        dettool_addprocessedexp.sql \
+        dettool_childlessrun.sql \
+        dettool_definebydetrun.sql \
+        dettool_detrunsummary.sql \
         dettool_find_completed_runs.sql \
+        dettool_input.sql \
+        dettool_normalizedexp.sql \
+        dettool_normalizedimfile.sql \
         dettool_normalizedstat.sql \
+        dettool_pending.sql \
+        dettool_processedimfile.sql \
         dettool_raw.sql \
+        dettool_residexp.sql \
+        dettool_residimfile.sql \
         dettool_revertdetrunsummary.sql \
         dettool_revertnormalizedexp.sql \
@@ -33 +43 @@
         dettool_revertstacked.sql \
         dettool_runs.sql \
+        dettool_stacked.sql \
         dettool_start_new_iteration.sql \
         dettool_stop_completed_correct_runs.sql \
@@ -38 +49 @@
         dettool_tocorrectimfile.sql \
         dettool_todetrunsummary.sql \
+        dettool_tonormalize.sql \
         dettool_tonormalizedexp.sql \
         dettool_tonormalizedstat.sql \
@@ -62 +74 @@
         flatcorr_find_completed_floatcorruns.sql \
         flatcorr_find_processedimfiles.sql \
+        flatcorr_pending.sql \
+        magictool_create_tmp_warpcomplete.sql \
         magictool_find_complete_diffed_exposures.sql \
         magictool_find_complete_warpruns.sql \
+        magictool_find_unmagiced.sql \
         magictool_inputskyfile.sql \
         magictool_totree.sql \
@@ -73 +88 @@
         magictool_addmask.sql \
         magictool_mask.sql \
+        pstamptool_addjob_otherjob.sql \
+        pstamptool_addjob_stampjob.sql \
+        pstamptool_datastore.sql \
+        pstamptool_pendingjob.sql \
+        pstamptool_pendingreq.sql \
         pxadmin_create_tables.sql \
         pxadmin_drop_tables.sql \
         pztool_find_completed_exp.sql \
         pztool_pendingimfile.sql \
-        pztool_revertcopied.sql \
         pztool_revert_downloadimfile_faults.sql \
         pztool_revert_fileset_faults.sql \
+        pztool_revertcopied.sql \
         regtool_create_dup_table.sql \
         regtool_pendingexp.sql \
@@ -95 +115 @@
         warptool_exp.sql \
         warptool_imfile.sql \
+        warptool_revertwarped.sql \
         warptool_scmap.sql \
         warptool_tooverlap.sql \
-        warptool_revertwarped.sql \
         warptool_towarped.sql \
         warptool_warped.sql

trunk/ippTools/share/dettool_tonormalizedexp.sql

@@ +1 @@
+-- this is used by both 'tonormalizedexp' and 'addnormalizedexp'
+
 SELECT
     *

trunk/ippTools/share/dettool_toresidexp.sql

@@ +1 @@
+-- this is used by both 'toresidexp' and 'addresidexp'
+
 -- which returns a list of exposures for which all component class ids have had
 -- residuals created.  This list includes the detrend id, iteration, exposure

trunk/ippTools/share/dettool_toresidimfile.sql

@@ -40 +40 @@
     AND detRun.mode = 'master'
     AND detNormalizedImfile.fault = 0
+    AND detNormalizedExp.fault = 0
     AND detResidImfile.det_id IS NULL
     AND detResidImfile.iteration IS NULL
@@ -73 +74 @@
     detRun.state = 'run'
     AND detRun.mode = 'verify'
+    -- AND detNormalizedImfile.fault = 0
+    -- AND detNormalizedExp.fault = 0
     AND detResidImfile.det_id IS NULL
     AND detResidImfile.iteration IS NULL

trunk/ippTools/share/difftool_queue.sql

@@ -3 +3 @@
         stackRun.tess_id,
         stackRun.stack_id,
+        diffInputSkyfile.template,
         warpSkyfile.warp_id
 FROM stackSumSkyfile