Changeset 24882 for trunk/ippTools/share

Timestamp:

Jul 21, 2009, 12:57:48 PM (17 years ago)

Author:

bills

Message:

Added magicdstool -definebyquery and fixed a bug in magicdstool_torevert_diff.sql

Location:

trunk/ippTools/share

Files:

• Makefile.am (modified) (1 diff)
• magicdstool_definebyquery_camera.sql (added)
• magicdstool_definebyquery_chip.sql (added)
• magicdstool_definebyquery_diff.sql (added)
• magicdstool_definebyquery_raw.sql (added)
• magicdstool_definebyquery_warp.sql (added)
• magicdstool_getrunids.sql (modified) (1 diff)
• magicdstool_torevert_diff.sql (modified) (1 diff)

trunk/ippTools/share/Makefile.am

@@ -154 +154 @@
      magictool_revertnode.sql \
      magicdstool_completed_runs.sql \
+     magicdstool_definebyquery_raw.sql \
+     magicdstool_definebyquery_chip.sql \
+     magicdstool_definebyquery_camera.sql \
+     magicdstool_definebyquery_warp.sql \
+     magicdstool_definebyquery_diff.sql \
      magicdstool_getrunids.sql \
      magicdstool_getskycells.sql \

trunk/ippTools/share/magicdstool_getrunids.sql

@@ -5 +5 @@
     chip_id,
     cam_id,
-    warp_id 
+    warp_id,
+    diffSkyfile.diff_id
 FROM magicRun 
 JOIN magicInputSkyfile USING(magic_id)

trunk/ippTools/share/magicdstool_torevert_diff.sql

@@ -9 +9 @@
     outroot,
     diffSkyfile.path_base,
-    NULL AS cam_path_base,
+    "NULL" AS cam_path_base,
     0 AS bytes,
     0 AS md5sum