Changeset 35308 for trunk/ippTools/share

Timestamp:

Mar 12, 2013, 3:29:45 PM (13 years ago)

Author:

bills

Message:

sript, ippTools, and database changes to support queuing staticsky runs
on the basis of lapGroups collections of lapRuns that have finished for
each of a list of filters

Location:

trunk/ippTools/share

Files:

• Makefile.am (modified) (1 diff)
• laptool_filtersforgroup.sql (added)
• laptool_pendinggroup.sql (added)
• laptool_revertgroup.sql (added)
• pxadmin_create_tables.sql (modified) (1 diff)

trunk/ippTools/share/Makefile.am

@@ -457 +457 @@
         laptool_WSdiff_check.sql \
         laptool_stacks.sql \
+        laptool_pendinggroup.sql \
+        laptool_revertgroup.sql \
+        laptool_filtersforgroup.sql \
         vptool_find_rawexp.sql \
         vptool_pendingimfile.sql \

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -2258 +2258 @@
 CREATE TABLE lapGroup  (
     seq_id  BIGINT,
+    tess_id VARCHAR(64),
     projection_cell VARCHAR(64),
     state   VARCHAR(16),
+    label   VARCHAR(64),
+    registered TIMESTAMP DEFAULT CURRENT_TIMESTAMP, -- time group was registered
     fault   SMALLINT,
-    PRIMARY KEY(seq_id, projection_cell),
+    PRIMARY KEY(seq_id, tess_id, projection_cell),
     KEY(state),
     KEY(fault),