351     def _add_attribute_join(self, query_set, join_condition,  argument
355         return self.add_join(query_set, 'tko_test_attributes',
361     def _add_label_pivot_table_join(self, query_set, suffix, join_condition='',  argument
363         return self.add_join(query_set, 'tko_test_labels_tests',
370     def _add_label_joins(self, query_set, suffix=''):  argument
371         query_set = self._add_label_pivot_table_join(
372                 query_set, suffix=suffix, force_left_join=True)
380         query_set.query.add_custom_join('tko_test_labels',
382                                         query_set.query.LOUTER,
384         return query_set
397     def _include_or_exclude_labels(self, query_set, label_names, exclude=False):  argument
403         return self._add_label_pivot_table_join(query_set,
409     def _add_custom_select(self, query_set, select_name, select_sql):  argument
410         return query_set.extra(select={select_name: select_sql})
413     def _add_select_value(self, query_set, alias):  argument
414         return self._add_custom_select(query_set, alias,
418     def _add_select_ifnull(self, query_set, alias, non_null_value):  argument
421         return self._add_custom_select(query_set, alias, select_sql)
424     def _join_test_label_column(self, query_set, label_name, label_id):  argument
427         query_set = Test.objects.join_custom_field(query_set, label_query,
430         query_set = self._add_select_ifnull(query_set, alias, label_name)
431         return query_set
434     def _join_test_label_columns(self, query_set, label_names):  argument
437             query_set = self._join_test_label_column(query_set, label_name,
439         return query_set
442     def _join_test_attribute(self, query_set, attribute, alias=None,  argument
455         query_set = Test.objects.join_custom_field(query_set, attribute_query,
458         query_set = self._add_select_value(query_set, alias)
459         return query_set
462     def _join_machine_label_columns(self, query_set, machine_label_names):  argument
467             query_set = self._join_test_attribute(
468                     query_set, 'host-labels',
470             query_set = self._add_select_ifnull(query_set, alias, label_name)
471         return query_set
474     def _join_one_iteration_key(self, query_set, result_key, first_alias=None):  argument
485         query_set = Test.objects.join_custom_field(query_set, iteration_query,
488         query_set = self._add_select_value(query_set, alias)
491             query_set = self._add_custom_select(
492                     query_set, 'iteration_index',
495         return query_set, alias
518         query_set, first_alias = self._join_one_iteration_key(
521             query_set, _ = self._join_one_iteration_key(query_set, result_key,
523         return query_set
526     def _join_job_keyvals(self, query_set, job_keyvals):  argument
530             query_set = Job.objects.join_custom_field(query_set, keyval_query,
532             query_set = self._add_select_value(query_set, alias)
533         return query_set
536     def _join_iteration_attributes(self, query_set, iteration_attributes):  argument
541             query_set = Test.objects.join_custom_field(query_set,
543             query_set = self._add_select_value(query_set, alias)
544         return query_set
588         query_set = self.get_query_set()
592             query_set = self._join_test_attribute(query_set, attribute)
595         query_set = self._join_test_label_columns(query_set, test_labels)
598         query_set = self._join_machine_label_columns(query_set, machine_labels)
601         query_set = self._join_iteration_results(query_set, iteration_keys)
604         query_set = self._join_job_keyvals(query_set, job_keyvals)
607         query_set = self._join_iteration_attributes(query_set,
616             query_set = self._add_label_joins(query_set)
622             query_set = self._include_or_exclude_labels(query_set,
626             query_set = self._include_or_exclude_labels(query_set,
636             query_set = self._add_attribute_join(
637                 query_set,
641             query_set = self._add_attribute_join(
642                 query_set,
651             query_set = self._add_attribute_join(
652                 query_set, suffix='_host_labels',
656         return query_set
683         query_set = self.model.query_objects(filter_data)
684         query_set = self._add_label_joins(query_set, suffix='_list')
685         rows = self._custom_select_query(query_set, ['tko_test_labels_list.id'])