Changeset 33172

Timestamp:

Jan 27, 2012, 2:02:45 PM (14 years ago)

Author:

bills

Message:

don't change components with bad quality to cleaned leave them full

Location:

trunk/ippTools/share

Files:

• chiptool_definecopy.sql (modified) (1 diff)
• difftool_change_run_state.sql (modified) (1 diff)
• warptool_change_run_state.sql (modified) (1 diff)

trunk/ippTools/share/chiptool_definecopy.sql

@@ -1 +1 @@
 SELECT
     rawExp.*,
-    newExp.label
+    newExp.label,
+    chipOld.workdir AS old_workdir,
+    chipOld.data_group AS old_data_group,
+    chipOld.state AS old_state
 FROM chipRun AS chipOld
 JOIN rawExp USING(exp_id)

trunk/ippTools/share/difftool_change_run_state.sql

@@ -14 +14 @@
             diffSkyfile.diff_id = diffRun.diff_id
             AND data_state != '%s'
+            AND diffSkyfile.quality = 0
         ) = 0

trunk/ippTools/share/warptool_change_run_state.sql

@@ -17 +17 @@
             warpSkyfile.warp_id = warpRun.warp_id
             AND warpSkyfile.data_state != '%s'
+            AND warpSkyfile.quality = 0
         ) = 0