Changeset 27149 for trunk/ippTools/share

Timestamp:

Mar 2, 2010, 6:29:45 PM (16 years ago)

Author:

watersc1

Message:

Code and regtool rewrites to enable the lossy compression of old data that aren't scientifically useful.

Location:

trunk/ippTools/share

Files:

• Makefile.am (modified) (1 diff)
• pxadmin_create_tables.sql (modified) (2 diffs)
• regtool_finishcompressexp.sql (added)
• regtool_pendingcompressimfile.sql (added)
• regtool_updatebyquery.sql (added)
• regtool_updatebyqueryimfile.sql (added)
• regtool_updateprocessedimfile.sql (modified) (1 diff)

trunk/ippTools/share/Makefile.am

@@ -256 +256 @@
      regtool_revertprocessedimfile.sql \
      regtool_updateprocessedimfile.sql \
+     regtool_pendingcompressimfile.sql \
+     regtool_finishcompressexp.sql \
+     regtool_updatebyquery.sql \
+     regtool_updatebyqueryimfile.sql \
      stacktool_definebyquery_insert.sql \
      stacktool_definebyquery_insert_random_part1.sql \

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -117 +117 @@
     filelevel VARCHAR(64),
     workdir VARCHAR(255),
+    state VARCHAR(64),
     reduction VARCHAR(64),
     dvodb VARCHAR(255),
@@ -189 +190 @@
     class_id VARCHAR(64),
     uri VARCHAR(255),
+    data_state VARCHAR(64),
     exp_type VARCHAR(64),
     filelevel VARCHAR(64),

trunk/ippTools/share/regtool_updateprocessedimfile.sql

@@ -1 +1 @@
 UPDATE rawImfile
-  SET burntool_state = %d
+    SET %s
   WHERE
     rawImfile.exp_id = %lld