Method search_columns

database/PostgreSQL.py:309–316

(self, filter:str,operator:str='ilike', logic_operator:str='or')

            return result
    
    def search_columns(self, filter:str,operator:str='ilike', logic_operator:str='or') -> Result:
        result = Result(headers=['table_name','column_name'])
        sentence = self._get_sentence(filter, operator, logic_operator).format(object_name='table_name')
        columns = self._select(f"Select table_name,column_name from information_schema.columns where (column_name ilike {sentence}) and table_schema='public'", showColumns=True)
        if columns:
            for col in columns:
                result.rows.append([col["table_name"], col["column_name"]])
            return result
    
    def get_rows(self, tablename:str, limit:int=10)->Result:
        result = Result(table_name=tablename)