Changeset 20734 for trunk/ippTools/share

Timestamp:

Nov 13, 2008, 2:56:00 PM (18 years ago)

Author:

Paul Price

Message:

Cleaning up magictool -definebyquery so that part1 and part2 queries aren't required (psDBRunQuery takes %s etc). Adding '-available' flag which says 'don't worry if all the diffs didn't make it, just do it with whatever's immediately available.'

Location:

trunk/ippTools/share

Files:

• Makefile.am (modified) (1 diff)
• magictool_definebyquery_select.sql (added)
• magictool_definebyquery_select_part1.sql (deleted)
• magictool_definebyquery_select_part2.sql (deleted)
• magictool_definebyquery_temp_insert.sql (modified) (1 diff)
• magictool_definebyquery_temp_insert_groupby.sql (deleted)

trunk/ippTools/share/Makefile.am

@@ -101 +101 @@
      magictool_definebyquery.sql \
      magictool_definebyquery_insert.sql \
-     magictool_definebyquery_select_part1.sql \
-     magictool_definebyquery_select_part2.sql \
+     magictool_definebyquery_select.sql \
      magictool_definebyquery_select_test.sql \
      magictool_definebyquery_temp_create.sql \
      magictool_definebyquery_temp_insert.sql \
-     magictool_definebyquery_temp_insert_groupby.sql \
      magictool_inputs.sql \
      magictool_inputskyfile.sql \

trunk/ippTools/share/magictool_definebyquery_temp_insert.sql

@@ -21 +21 @@
 WHERE
     diffSkyfile.fault = 0
+---- WHERE hook %s
+GROUP BY
+    exp_id,
+    warpSkyfile.skycell_id