Changeset 29365

Timestamp:

Oct 8, 2010, 12:21:31 PM (16 years ago)

Author:

bills

Message:

implement ordering by priority in difftool -todiffskyfile

Location:

trunk/ippTools

Files:

• share/difftool_todiffskyfile.sql (modified) (4 diffs)
• src/difftool.c (modified) (1 diff)

trunk/ippTools/share/difftool_todiffskyfile.sql

@@ -13 +13 @@
     diffRun.bothways,
     diffRun.diff_mode,
-    diffSkyfile.path_base
+    diffSkyfile.path_base,
+    IFNULL(priority, 10000) AS priority
 FROM diffRun
 JOIN diffInputSkyfile USING(diff_id)
@@ -62 +63 @@
     ON diffInputSkyfile.diff_id = diffSkyfile.diff_id
     AND diffInputSkyfile.skycell_id = diffSkyfile.skycell_id
+LEFT JOIN Label ON Label.label = diffRun.label
 WHERE
 -- Ready to be processed
@@ -70 +72 @@
     AND diffSkyfile.data_state = 'update')
     )
+    AND (Label.active OR Label.active IS NULL)
 -- Ensure input warps are available
     AND (diffInputSkyfile.warp1 IS NULL
@@ -93 +96 @@
     AND stackTemplateSkyfile.quality = 0))
 
-
-

trunk/ippTools/src/difftool.c

@@ -480 +480 @@
     }
     psFree(where);
+
+     psStringAppend(&query, "\nORDER by priority DESC, diff_id");
 
     // treat limit == 0 as "no limit"