def test2():
ids = []
names = []
start, end, step = [0, 150, 5]
scopes = range(start, end, step)
for index, scope in enumerate(scopes[0:-1]):
ids.append([scope, scopes[index + 1]])
names.append("(%d, %d]" % (scope, scopes[index + 1]))
if scopes[-1] < end:
ids.append([scopes[-1], end])
names.append("(%d, %d]" % (scopes[-1], end))
names[0] = "[%d, %d]" % (scopes[0], scopes[1])
greater_equal_where = qa.Where("sum", symbol=">=")
greater_where = qa.Where("sum", symbol=">")
less_equal_where = qa.Where("sum", symbol="<=")
cell1 = qa.Cell(
"COUNT(*)", stu_dimen_table,
[[greater_equal_where, less_equal_where], exam_where, subject_where])
cell2 = qa.Cell(
"COUNT(*)", stu_dimen_table,
[[greater_where, less_equal_where], exam_where, subject_where])
row1 = qa.RowSeriesCell(cell1, ids[0:1])
row2 = qa.RowSeriesCell(cell2, ids[1:])
table = qa.TableRows(["分数段", names], ['个数'], [row1, row2])
for table_row in table.get_values():
print(table_row)
def test1():
district_subject_cell = qa.CellWithOrders(subject_avg_null_item,
district_dimen_table,
[district_where, exam_where],
subject_item, subject_ids)
district_subject_row = qa.ColSeriesCell(district_subject_cell,
district_ids)
district_sum_cell = qa.Cell(sum_avg_null_item, district_sum_table,
[district_where, exam_where])
district_sum_row = qa.ColSeriesCell(district_sum_cell, district_ids)
school_subject_cell = qa.CellWithOrders(subject_avg_rank_item,
school_dimen_table,
[school_where, exam_where],
subject_item, subject_ids)
school_subject_row = qa.ColSeriesCell(school_subject_cell, school_ids)
school_sum_cell = qa.Cell(sum_avg_rank_item, school_sum_table,
[school_where, exam_where])
school_sum_row = qa.ColSeriesCell(school_sum_cell, school_ids)
first_row = [
'类别', '语文', '排名', '数学', '英语', '排名', '物理', '排名', '化学', '排名', '总分', '排名'
]
datarows = [[district_subject_row, district_sum_row],
[school_subject_row, school_sum_row]]
table_rows = qa.TableRows(first_row, district_school_names, *datarows)
for table_row in table_rows.get_values():
print(table_row)
def test8_2():
class_sum_avg_rank_cell = qa.Cell(
sum_avg_rank_item, class_sum_table,
[[school_where, class_where], exam_where])
class_subject_avg_rank_cell = qa.Cell(
subject_avg_rank_item, class_dimen_table,
[[school_where, class_where], subject_where, exam_where])
class_sum_avg_rank_row = qa.ColSeriesCell(class_sum_avg_rank_cell,
school_class_ids)
class_subject_rank_row = qa.BlockSeriesCell(class_subject_avg_rank_cell,
school_class_ids, subject_ids)
first_row = [
'学校',
'班级',
'总分',
'排名',
'语文',
'排名',
'数学',
'英语',
'排名',
'物理',
'排名',
'化学',
'排名',
]
datarows = [class_sum_avg_rank_row, class_subject_rank_row]
table_rows = qa.TableRows(first_row, school_class_names, datarows)
for table_row in table_rows.get_values():
print(table_row)
def test6():
school_sum_line_cell = qa.Cell(line_items, school_line_table,
[school_where, exam_where])
school_sum_line_row = qa.ColSeriesCell(school_sum_line_cell, school_ids)
first_row = ['学校', line_names]
datarows = school_sum_line_row
table_rows = qa.TableRows(first_row, school_names, datarows)
for table_row in table_rows.get_values():
print(table_row)
def test7():
district_dimen_avg_cell = qa.Cell(
dimen_avg_items, district_dimen_table,
[district_where, exam_where, subject_where])
district_dimen_avg_row = qa.ColSeriesCell(district_dimen_avg_cell,
district_ids)
school_dimen_avg_cell = qa.Cell(dimen_avg_items, school_dimen_table,
[school_where, exam_where, subject_where])
school_dimen_avg_row = qa.ColSeriesCell(school_dimen_avg_cell, school_ids)
first_row = ['学校', dimen_names]
datarows = [district_dimen_avg_row, school_dimen_avg_row]
table_rows = qa.TableRows(first_row, district_school_names, *datarows)
for table_row in table_rows.get_values():
print(table_row)