]> xenbits.xensource.com Git - osstest.git/commit
sg-report-job-history: Show which host test ran on
authorIan Jackson <ian.jackson@eu.citrix.com>
Mon, 9 Feb 2015 17:55:05 +0000 (17:55 +0000)
committerIan Jackson <Ian.Jackson@eu.citrix.com>
Fri, 13 Feb 2015 14:01:17 +0000 (14:01 +0000)
commit7d77f64bbb448f0b59d425ead15b64aeac8ee5b4
tree53ba820d6569b68e5c86d029cb6430f650586fd3
parente99c73854bfe7ea90706c7dd4322b03d0ad02036
sg-report-job-history: Show which host test ran on

Add a column listing the host(s) used.  We first find the relevant set
of host runvars (with a SELECT DISTINCT) and then look up each var for
each actual flight.

We do the pattern-matching on runvar names in perl to avoid giving the
postgresql optimiser a chance to turn this query into a full table
scan of the runvars table.  (A previous iteration of this patch
searched, in the per-flight loop, for all runvars whose name was
appropriately LIKE, with appalling performance.)

Signed-off-by: Ian Jackson <Ian.Jackson@eu.citrix.com>
Acked-by: Ian Campbell <ian.campbell@citrix.com>
sg-report-job-history