Changeset 24149 for branches/pap_magic/ippTools/share/magictool_toprocess_tree.sql

Timestamp:

May 12, 2009, 4:07:48 PM (17 years ago)

Author:

Paul Price

Message:

Reworking magic (and some diff) to be ready for performing magic on warp-warp diffs. Several database changes to diff and magic tables because we can no longer assume that a diff is associated with a single exposure. Ready for testing.

File:

• branches/pap_magic/ippTools/share/magictool_toprocess_tree.sql (modified) (2 diffs)

branches/pap_magic/ippTools/share/magictool_toprocess_tree.sql

@@ -1 +1 @@
 SELECT
     magicTree.*,
-    exp_id,
-    camera,
     magicRun.workdir,
+    rawExp.exp_id,
+    rawExp.camera,
     -- convert magic_id into a boolean value (1 or 0)
     -- note that the type stays a 64 bit int
-    magicNodeResult.magic_id IS TRUE as done,
-    magicNodeResult.fault IS TRUE as bad,
-    'notused' as template_uri
+    magicNodeResult.magic_id IS TRUE AS done,
+    magicNodeResult.fault IS TRUE AS bad,
 FROM magicTree
 JOIN magicRun USING(magic_id)
@@ -17 +16 @@
 WHERE
     magicRun.state = 'new'
-    -- where hook %s
+-- WHERE hook %s
 ORDER BY
     magicRun.magic_id