1#!/usr/bin/python 2""" 3Further display the tests in a matrix of the form tests X machines 4to help understand the results selected from the previous form. 5""" 6 7print "Content-type: text/html\n" 8import cgi, cgitb, os, sys, re 9sys.stdout.flush() 10cgitb.enable() 11 12import common 13from autotest_lib.tko import db, display, frontend 14 15db = db.db() 16 17def main(): 18 display.print_main_header() 19 20 form = cgi.FieldStorage() 21 22 if form.has_key('sql'): 23 sql = form['sql'].value 24 25 if form.has_key('values'): 26 values = [val for val in form['values'].value.split(',')] 27 28 if not sql: 29 return 30 if not values: 31 return 32 33 tests = frontend.test.select_sql(db, sql, values) 34 35 # get the list of tests/machines to populate the row and column header. 36 testname = [test.testname for test in tests] 37 machine_idx = [test.machine_idx for test in tests] 38 39 # We dont want repetitions in the table row/column headers, 40 # so eliminate the dups. 41 uniq_test = list(set(testname)) 42 uniq_machine_idx = list(set(machine_idx)) 43 44 header_row = [ display.box('', header = True) ] 45 for test_name in uniq_test: 46 header_row.append(display.box(test_name, header=True)) 47 matrix = [header_row] 48 for machine in uniq_machine_idx: 49 mach_name = db.select_sql('hostname', 'machines', 50 ' where machine_idx=%s', [str(machine)]) 51 row = [display.box(mach_name[0][0])] 52 for test_name in uniq_test: 53 testlist = [test for test in tests 54 if test.machine_idx == machine 55 and test.testname == test_name] 56 # url link to the first test. 57 # TODO: provide another level to show the different 58 # test results. 59 link = None 60 if testlist and testlist[0]: 61 link = testlist[0].url 62 box = display.status_count_box(db, testlist, link=link) 63 row.append(box) 64 matrix.append(row) 65 display.print_table(matrix) 66 67main() 68