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 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 total_cases(self, product_id):
     return get_groupby_result(sqls.component_total_cases,
                               (product_id,),
                               key_name='component_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 caseruns_count(self, product_id):
     return get_groupby_result(sqls.build_caseruns_count,
                               (product_id,),
                               key_name='build_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 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 case_runs_count(self, component_id):
     return get_groupby_result(sqls.component_case_runs_count,
                               (component_id,),
                               key_name='name',
                               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 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 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 finished_runs_count(self, product_id):
     return get_groupby_result(sqls.build_builds_finished_runs_count,
                               (product_id,),
                               key_name='build_id')

 def finished_case_runs_count(self, product_id):
     return get_groupby_result(sqls.component_finished_case_runs_count,
                               (product_id,),
                               key_name='component_id')