cli/compose_query

   1 #!/usr/bin/python
   2 """
   3 Selects all rows and columns that satisfy the condition specified
   4 and prints the matrix.
   5 """
   6 import sys, os, re, optparse
   7 import common
   8 from autotest_lib.client.common_lib import kernel_versions
   9 from autotest_lib.tko import display, frontend, db, query_lib
  10
  11 # First do all the options parsing
  12 parser = optparse.OptionParser()
  13 parser.add_option('-x', '--x_axis', action='store', dest='x_axis',
  14                                                 default='machine_group')
  15 parser.add_option('-y', '--y_axis', action='store', dest='y_axis',
  16                                                 default='kernel')
  17 parser.add_option('-c', '--condition', action='store', dest='condition')
  18 (options, args) = parser.parse_args()
  19
  20 if options.condition:
  21     where = query_lib.parse_scrub_and_gen_condition(
  22                 options.condition, frontend.test_view_field_dict)
  23     # print("where clause:" % where)
  24 else:
  25     where = None
  26
  27 # Grab the data
  28 db = db.db()
  29 test_data = frontend.get_matrix_data(db, options.x_axis, options.y_axis, where)
  30
  31 # Print everything
  32 widest_row_header = max([len(y) for y in test_data.y_values])
  33 data_column_width = max([max(13,len(x)) for x in test_data.x_values])
  34 column_widths = [widest_row_header] + [data_column_width] * len(test_data.x_values)
  35 format = ' | '.join(['%%%ds' % i for i in column_widths])
  36 # Print headers
  37 print format % tuple([''] + test_data.x_values)
  38
  39 # print data
  40 for y in test_data.y_values:
  41     line = [y]
  42     for x in test_data.x_values:
  43         try:
  44             data_point = test_data.data[x][y]
  45             good_status = db.status_idx['GOOD']
  46             good = data_point.status_count.get(good_status, 0)
  47             total = sum(data_point.status_count.values())
  48             line.append('%5d / %-5d' % (good, total))
  49         except:
  50             line.append('')
  51     print format % tuple(line)