Changeset 35188

Timestamp:

Feb 20, 2013, 3:48:48 PM (13 years ago)

Author:

eugene

Message:

update test to include addProcessedExp.fault & camProcessedExp.fault

Location:

trunk/ippToPsps/test

Files:

• fulltest.sh (modified) (1 diff)
• mkgpc1.sh (modified) (2 diffs)
• mkgpc1data.dvo (modified) (1 diff)

trunk/ippToPsps/test/fulltest.sh

@@ -25 +25 @@
 # mkgpc1.sh user localhost eam eam
 
-set mkgpc1       = 1
+set mkgpc1       = 0
 set initdb       = 1
-set mkdummy      = 1
 set initscratch  = 1
 set camqueue     = 1
 set initbatch    = 1
 set cambatch     = 1
-set stackqueue   = 1
-set stackbatch   = 1
+set stackqueue   = 0
+set stackbatch   = 0
 set objectqueue  = 0
 set objectbatch  = 0

trunk/ippToPsps/test/mkgpc1.sh

@@ -61 +61 @@
   CREATE TABLE camProcessedExp (
     path_base CHAR(255),
-    cam_id INT
+    cam_id INT,
+    fault INT
   );
   CREATE TABLE fakeRun (
@@ -98 +99 @@
   );
   CREATE TABLE addRun (
+    add_id INT,
     stage CHAR(64),
     state CHAR(64),
     stage_id INT,
     minidvodb_name CHAR(64)
+  );
+  CREATE TABLE addProcessedExp (
+    add_id INT,
+    fault INT
   );
   CREATE TABLE minidvodbRun (

trunk/ippToPsps/test/mkgpc1data.dvo

@@ -291 +291 @@
   dbinsert chipRun (exp_id, chip_id) values ($myID, $myID)
   dbinsert camRun (chip_id, cam_id, dist_group, software_ver) values ($myID, $myID, "testgroup", "testsoft")
-  dbinsert camProcessedExp (cam_id, path_base) values ($myID, "$filename")
+  dbinsert camProcessedExp (cam_id, path_base, fault) values ($myID, "$filename", 0)
   dbinsert fakeRun (fake_id, cam_id) values ($myID, $myID)
   dbinsert warpRun (warp_id, fake_id) values ($myID, $myID)
   dbinsert warpSkyCellMap (warp_id, skycell_id, class_id) values ($myID, "skycell.0000.000", "XY00")
 
-  dbinsert addRun (stage, state, stage_id, minidvodb_name) values ("cam", "full", $myID, "catdir.cam")
+  dbinsert addRun (add_id, stage, state, stage_id, minidvodb_name) values ($myID, "cam", "full", $myID, "catdir.cam")
+  dbinsert addProcessedExp (add_id, fault) values ($myID, 0)
 end