(self, filter:str,operator:str='or', logic_operator:str='or')
| 146 | return self._select(query, showColumns=True) |
| 147 | |
| 148 | def create_query_to_all_values(self, filter:str,operator:str='or', logic_operator:str='or') -> List[Query]: |
| 149 | rows = self.get_tables_and_columns() |
| 150 | if rows is not None: |
| 151 | queries:List[Query] = [] |
| 152 | for row in rows: |
| 153 | tablename = row[0] |
| 154 | columns = row[1] |
| 155 | sentence = "" |
| 156 | columns_list = "" |
| 157 | for index, col in enumerate(columns): |
| 158 | definition = col.split(':') |
| 159 | column_name = f'"{definition[0]}"' |
| 160 | columns_list+=f"{column_name}," |
| 161 | data_type = definition[1] |
| 162 | if data_type not in Settings.exclude_data_type: |
| 163 | if index == 0: |
| 164 | sentence+=f"{CastDB.cast_column(column_name, data_type)} ilike '%{filter}%' " |
| 165 | else: |
| 166 | sentence+=f"{operator} {CastDB.cast_column(column_name, data_type)} ilike '%{filter}%' " |
| 167 | sentence=f"Select {columns_list[:-1]} from {tablename} where {sentence}" |
| 168 | queries.append(Query(word=filter, sentence=sentence, tablename=tablename)) |
| 169 | |
| 170 | return queries |
| 171 | |
| 172 | return [] |
| 173 | |
| 174 | def get_tables_count(self)->Result: |
| 175 | result = Result(headers=['Table', "Rows"]) |
nothing calls this directly
no test coverage detected