Join the 1-day Testing & QA Summit featuring 15+ Expert Speakers.Register for FREE! Join TestMu Conference

How to use escape_user_sql method in autotest

Best Python code snippet using autotest_python

models.py

Source:models.py

...469                                                   '')470        if include_attributes_where:471            query_set = self._add_attribute_join(472                query_set,473                join_condition=self.escape_user_sql(include_attributes_where))474            joined = True475        if exclude_attributes_where:476            query_set = self._add_attribute_join(477                query_set,478                join_condition=self.escape_user_sql(exclude_attributes_where),479                exclude=True)480            joined = True481        if not joined:482            filter_data['no_distinct'] = True483        if 'tko_test_attributes_host_labels' in extra_where:484            query_set = self._add_attribute_join(485                query_set, suffix='_host_labels',486                join_condition='tko_test_attributes_host_labels.attribute = '487                               '"host-labels"')488        return query_set489    def query_test_ids(self, filter_data, apply_presentation=True):490        """Queries for test IDs.491        @param filter_data: Data by which to filter.492        @param apply_presentation: Whether or not to apply presentation493            parameters.494        @return A list of test IDs.495        """496        query = self.model.query_objects(filter_data,497                                         apply_presentation=apply_presentation)498        dicts = query.values('test_idx')499        return [item['test_idx'] for item in dicts]500    def query_test_label_ids(self, filter_data):501        """Queries for test label IDs.502        @param filter_data: Data by which to filter.503        @return A list of test label IDs.504        """505        query_set = self.model.query_objects(filter_data)506        query_set = self._add_label_joins(query_set, suffix='_list')507        rows = self._custom_select_query(query_set, ['tko_test_labels_list.id'])508        return [row[0] for row in rows if row[0] is not None]509    def escape_user_sql(self, sql):510        sql = super(TestViewManager, self).escape_user_sql(sql)511        return sql.replace('test_idx', self.get_key_on_this_table('test_idx'))512class TestView(dbmodels.Model, model_logic.ModelExtensions):513    """Models a test view."""514    extra_fields = {515            'DATE(job_queued_time)': 'job queued day',516            'DATE(test_finished_time)': 'test finished day',517    }518    group_fields = [519            'test_name',520            'status',521            'kernel',522            'hostname',523            'job_tag',524            'job_name',...

Automation Testing Tutorials

Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.