Changeset 29493 for trunk/ippTools/share

Timestamp:

Oct 20, 2010, 9:39:26 AM (16 years ago)

Author:

bills

Message:

changes to implment saving magic streaks file and verify outputs in nebulous and to add data_state to Background tables to support cleanup

Location:

trunk/ippTools/share

Files:

• magictool_toprocess_inputs.sql (modified) (1 diff)
• magictool_toprocess_tree.sql (modified) (2 diffs)
• magictool_totree.sql (modified) (1 diff)

trunk/ippTools/share/magictool_toprocess_inputs.sql

@@ -3 +3 @@
     magicRun.workdir,
     rawExp.exp_id,
+    rawExp.exp_name,
+    rawExp.workdir AS raw_workdir,
     rawExp.camera,
     -- convert magic_id into a boolean value (1 or 0)

trunk/ippTools/share/magictool_toprocess_tree.sql

@@ -3 +3 @@
     magicRun.workdir,
     rawExp.exp_id,
+    rawExp.exp_name,
+    rawExp.workdir AS raw_workdir,
     rawExp.camera,
     -- convert magic_id into a boolean value (1 or 0)
@@ -16 +18 @@
 WHERE
     magicRun.state = 'new'
+    AND (Label.active OR Label.active IS NULL)
 -- WHERE hook %s
 ORDER BY

trunk/ippTools/share/magictool_totree.sql

@@ -18 +18 @@
     AND magicTree.node IS NULL
     AND magicRun.fault = 0
+    AND (Label.active OR Label.active IS NULL)