[Xen-devel] [OSSTEST PATCH 21/33] sg-check-tested: New --pass-job= option

[Ian Jackson <ian.jackson@xxxxxxxxxxxxx>]

Specifies that returned information should relate to a flight in which
a particular job existed and passed.  The option can be repeated if
desired (to specify flights in which _all_ those jobs passed).

Signed-off-by: Ian Jackson <Ian.Jackson@xxxxxxxxxxxxx>
---
v2: New patch
---
 sg-check-tested |   10 ++++++++++
 1 file changed, 10 insertions(+)

diff --git a/sg-check-tested b/sg-check-tested
index e503cf0..1a3afa3 100755
--- a/sg-check-tested
+++ b/sg-check-tested
@@ -86,6 +86,16 @@ END
         my @blessings= split /\,/, $1;
         push @conds_vars, @blessings;
         push @conds, "(". (join " OR ", map { "blessing=?" } @blessings). ")";
+    } elsif (m/^--pass-job=(.*)$/) {
+        push @conds_vars, $1;
+       push @conds, <<END;
+            EXISTS
+            (SELECT 1
+               FROM jobs j
+              WHERE j.job = ?
+                AND j.flight = flights.flight
+                AND j.status = 'pass')
+END
     } elsif (m/^--print-revision=(.*)$/) {
         die if $prrev;
         $prrev= $1;
-- 
1.7.10.4


_______________________________________________
Xen-devel mailing list
Xen-devel@xxxxxxxxxxxxx
http://lists.xen.org/xen-devel