Changeset 28058 for branches/haf_branches/ipp.20100512/ippTools/share

Timestamp:

May 20, 2010, 6:27:48 PM (16 years ago)

Author:

heather

Message:

added minidvodb_id, flipmindvodbrun etc

Location:

branches/haf_branches/ipp.20100512/ippTools/share

Files:

• addtool_find_minidvodbprocessed.sql (modified) (1 diff)
• addtool_find_pendingmergeprocess.sql (modified) (1 diff)
• addtool_queue_cam_id.sql (modified) (1 diff)
• addtool_reset_faulted_minidvodbruns.sql (modified) (1 diff)
• addtool_revertminidvodbprocessed.sql (modified) (1 diff)

branches/haf_branches/ipp.20100512/ippTools/share/addtool_find_minidvodbprocessed.sql

@@ -1 +1 @@
 SELECT
     minidvodbProcessed.*,
-    addRun.minidvodb_group
+    minidvodbRun.minidvodb_name 
+    minidvodbRun.minidvodb_group
 FROM minidvodbProcessed
 JOIN minidvodbRun
-    USING(minidvodb_name)
-JOIN addRun
-    USING(minidvodb_name)
+    USING(minidvodb_id)
 

branches/haf_branches/ipp.20100512/ippTools/share/addtool_find_pendingmergeprocess.sql

@@ -2 +2 @@
 FROM minidvodbRun 
 LEFT JOIN minidvodbProcessed
-USING(minidvodb_name)
-WHERE (minidvodbRun.state = 'to_be_merged' AND minidvodbProcessed.minidvodb_name IS NULL)
+USING(minidvodb_id)
+WHERE (minidvodbRun.state = 'to_be_merged' AND minidvodbProcessed.minidvodb_id IS NULL)

branches/haf_branches/ipp.20100512/ippTools/share/addtool_queue_cam_id.sql

@@ -11 +11 @@
         '%s',           -- dvodb 
         '%s',           -- note
-        %d              -- image_only
+        %d,             -- image_only
+        %d,             -- minidvodb
+        '%s',           -- minidvodb_group 
+        '%s'            -- minidvodb_name
     FROM camRun
     WHERE

branches/haf_branches/ipp.20100512/ippTools/share/addtool_reset_faulted_minidvodbruns.sql

@@ -2 +2 @@
 SET minidvodbRun.state = 'to_be_merged'
 WHERE
-    minidvodbProcessed.minidvodb_name = minidvodbRun.minidvodb_name
-    AND addRun.minidvodb_name = minidvodbRun.minidvodb_name
+    minidvodbProcessed.minidvodb_id = minidvodbRun.minidvodb_id
+    AND addRun.minidvodb_id = minidvodbRun.minidvodb_id
     AND minidvodbProcessed.fault != 0

branches/haf_branches/ipp.20100512/ippTools/share/addtool_revertminidvodbprocessed.sql

@@ -2 +2 @@
 USING minidvodbProcessed, minidvodbRun, addRun
 WHERE
-    minidvodbProcessed.minidvodb_name = minidvodbRun.minidvodb_name
+    minidvodbProcessed.minidvodb_id = minidvodbRun.minidvodb_id
     AND addRun.minidvodb_name = minidvodbRun.minidvodb_name
     AND minidvodbProcessed.fault != 0