def runs_subtotal(self, form):
sql, params = self._prepare_sql(form,
sqls.testing_report_runs_subtotal)
return get_groupby_result(sql,
params,
key_name='build_id',
with_rollup=True)
def cases_isautomated_subtotal(self):
sql, params = self._prepare_sql(
sqls.custom_builds_cases_isautomated_subtotal)
return get_groupby_result(sql,
params,
key_name='isautomated',
with_rollup=True)
def runs_subtotal(self, form):
sql, params = self._prepare_sql(form,
sqls.by_case_run_tester_runs_subtotal)
return get_groupby_result(sql, params, key_name='tested_by_id')
def case_runs_subtotal(self):
sql, params = self._prepare_sql(sqls.custom_builds_case_runs_subtotal)
return get_groupby_result(sql, params, key_name='build_id')
def total_cases(self, product_id):
return get_groupby_result(sqls.component_total_cases,
(product_id,),
key_name='component_id')
def caserun_status_subtotal(self, product_id, build_id):
return get_groupby_result(sqls.build_caserun_status_subtotal,
(product_id, build_id),
key_name='name',
with_rollup=True)
def runs_subtotal(self, form):
sql, params = self._prepare_sql(form,
sqls.testing_report_runs_subtotal)
return get_groupby_result(sql, params, key_name='build_id')
def cases_isautomated_subtotal(self):
sql, params = self._prepare_sql(
sqls.custom_builds_cases_isautomated_subtotal)
return get_groupby_result(sql, params, key_name='isautomated')
def overview_view_get_running_runs_count(product_id):
return get_groupby_result(sqls.overview_running_runs_count,
(product_id,),
key_name='stop_status',
with_rollup=True)
def plans_subtotal(self):
sql, params = self._prepare_sql(sqls.custom_builds_plans_subtotal)
return get_groupby_result(sql, params,
key_name='build_id',
with_rollup=True)
def case_runs_status_subtotal(self, product_id, version_id):
return get_groupby_result(sqls.version_case_run_status_subtotal,
(product_id, version_id),
key_name='name',
with_rollup=True)
def failed_case_runs_subtotal(self, product_id):
return get_groupby_result(sqls.version_failed_case_runs_subtotal,
(product_id,),
key_name='product_version_id')
def running_runs_subtotal(self, product_id):
return get_groupby_result(sqls.version_running_runs_subtotal,
(product_id,),
key_name='product_version_id')
def case_runs_count(self, component_id):
return get_groupby_result(sqls.component_case_runs_count,
(component_id,),
key_name='name',
with_rollup=True)
def finished_case_runs_count(self, product_id):
return get_groupby_result(sqls.component_finished_case_runs_count,
(product_id,),
key_name='component_id')
def runs_subtotal(self, form):
sql, params = self._prepare_sql(form, sqls.by_plan_tags_runs_subtotal)
return get_groupby_result(sql, params, key_name='tag_id')
def case_runs_subtotal(self):
sql, params = self._prepare_sql(sqls.custom_builds_case_runs_subtotal)
return get_groupby_result(sql, params, key_name='build_id')
def overview_view_get_case_run_status_count(product_id):
return get_groupby_result(sqls.overview_case_run_status_count,
(product_id,),
key_name='name',
with_rollup=True)
def runs_subtotal(self, form):
sql, params = self._prepare_sql(
form, sqls.by_case_run_tester_runs_subtotal)
return get_groupby_result(sql, params,
key_name='tested_by_id')
def finished_runs_count(self, product_id):
return get_groupby_result(sqls.build_builds_finished_runs_count,
(product_id,),
key_name='build_id')
def runs_subtotal(self, form):
sql, params = self._prepare_sql(form,
sqls.by_plan_tags_runs_subtotal)
return get_groupby_result(sql, params, key_name='tag_id')
def caseruns_count(self, product_id):
return get_groupby_result(sqls.build_caseruns_count,
(product_id,),
key_name='build_id')
