Changeset 23177

Timestamp:

Mar 4, 2009, 8:55:04 AM (17 years ago)

Author:

eugene

Message:

stop using the sql to enforce valid state changes: too many are possible

Location:

branches/eam_branches/eam_branch_20090303/ippTools/share

Files:

• chiptool_change_imfile_data_state.sql (modified) (1 diff)
• warptool_change_skyfile_data_state.sql (modified) (1 diff)

branches/eam_branches/eam_branch_20090303/ippTools/share/chiptool_change_imfile_data_state.sql

@@ -7 +7 @@
     chip_id = %lld
     AND class_id = '%s'
-    -- only update if chipRun.state has the expected value
-    AND (
-        SELECT state from chipRun where chipRun.chip_id = chipProcessedImfile.chip_id
-    ) = '%s'
-    
-
+--    -- only update if chipRun.state has the expected value
+--    AND (
+--        SELECT state from chipRun where chipRun.chip_id = chipProcessedImfile.chip_id
+--    ) = '%s'

branches/eam_branches/eam_branch_20090303/ippTools/share/warptool_change_skyfile_data_state.sql

@@ -9 +9 @@
     AND skycell_id = '%s'
     -- only update if chipRun.state has the expected value
-    AND (
-        SELECT state from warpRun where warpRun.warp_id = warpSkyfile.warp_id
-    ) = '%s'
-    
-
+--    AND (
+--        SELECT state from warpRun where warpRun.warp_id = warpSkyfile.warp_id
+--    ) = '%s'