[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [Xen-devel] [OSSTEST PATCH 05/13] sg-report-host-history: Get job status from mainquery
We are going to need this as part of our data reuse cache key, so we need it this early. This change hardly slows the query down. Signed-off-by: Ian Jackson <ian.jackson@xxxxxxxxxxxxx> --- sg-report-host-history | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/sg-report-host-history b/sg-report-host-history index d47784d9..81a7a8d8 100755 --- a/sg-report-host-history +++ b/sg-report-host-history @@ -122,8 +122,9 @@ sub mainquery () { our @params = keys %hosts; our $runvarq //= db_prepare(<<END); - SELECT flight, job, name, val + SELECT flight, job, name, val, status FROM runvars + JOIN jobs USING (flight, job) WHERE $namecond AND ($valcond) AND $flightcond @@ -186,10 +187,9 @@ sub reporthost ($) { END our $infoq //= db_prepare(<<END); - SELECT blessing, branch, intended, status + SELECT blessing, branch, intended FROM flights - JOIN jobs USING (flight) - WHERE flight=? AND job=? + WHERE flight=? AND ?!='X' END our $allocdq //= db_prepare(<<END); -- 2.11.0 _______________________________________________ Xen-devel mailing list Xen-devel@xxxxxxxxxxxxxxxxxxxx https://lists.xenproject.org/mailman/listinfo/xen-devel
|
![]() |
Lists.xenproject.org is hosted with RackSpace, monitoring our |