Context Navigation

Changeset 28768

Timestamp:

Jul 29, 2010, 12:04:03 PM (16 years ago)

Author:

bills

Message:

order work to do by priority

Location:

trunk/ippTools

Files:

-              r27276
+              r28768
     -- note that the type stays a 64 bit int
     magicNodeResult.magic_id IS TRUE AS done,
+    magicNodeResult.fault IS TRUE AS bad
+    magicNodeResult.fault IS TRUE AS bad,
+    IFNULL(Label.priority, 10000) AS priority
 FROM magicRun
 JOIN magicTree USING(magic_id)
 …
     ON diffRun.diff_id =  diffSkyfile.diff_id
 LEFT JOIN magicNodeResult USING(magic_id, node)
+LEFT JOIN Label ON magicRun.label = Label.label
 WHERE
     magicRun.state = 'new'
 …
     AND magicNodeResult.node IS NULL
     AND diffRun.state = 'full'
+    AND (Label.active OR Label.active IS NULL)
 -- WHERE hook %s

-              r24949
+              r28768
 SELECT DISTINCT
+    magic_id
+    magic_id,
+    IFNULL(priority, 10000) AS priority
 FROM magicTree
 JOIN magicRun USING(magic_id)
 LEFT JOIN magicNodeResult USING(magic_id, node)
+LEFT JOIN Label ON magicRun.label = Label.label
 WHERE
     magicRun.state = 'new'
 …
 -- WHERE hook %s
 ORDER BY
     magicRun.magic_id
+    priority DESC, magicRun.magic_id

-              r24174
+              r28768
     -- note that the type stays a 64 bit int
     magicNodeResult.magic_id IS TRUE AS done,
+    magicNodeResult.fault IS TRUE AS bad
+    magicNodeResult.fault IS TRUE AS bad,
+    IFNULL(Label.priority, 10000) AS priority
 FROM magicTree
 JOIN magicRun USING(magic_id)
 JOIN rawExp USING(exp_id)
 LEFT JOIN magicNodeResult USING(magic_id, node)
+LEFT JOIN Label ON magicRun.label = Label.label
 WHERE
     magicRun.state = 'new'
 -- WHERE hook %s
 ORDER BY
     magicRun.magic_id
+    priority, magicRun.magic_id

-              r24174
+              r28768
     ra,
     decl,
+    diffRun.tess_id
+    diffRun.tess_id,
+    IFNULL(priority, 10000) AS priority
 FROM magicRun
 JOIN diffRun USING(diff_id)
 …
 LEFT JOIN magicTree
     USING(magic_id)
+LEFT JOIN Label ON magicRun.label = Label.label
 WHERE
     magicRun.state = 'new'

-              r28765
+              r28768
     psFree(where);
+    psStringAppend(&query, "\nORDER BY priority DESC, magic_id");
     // treat limit == 0 as "no limit"
     if (limit) {
 …
     psFree(where);
+    psStringAppend(&query, "\nORDER BY priority DESC, magic_id");
     // treat limit == 0 as "no limit"
     if (limit) {

Note: See TracChangeset for help on using the changeset viewer.