Das deutsche Python-Forum

Code: Alles auswählen

with self.managed_query() as query: 
        query.prepare("SELECT name FROM sqlite_master WHERE type='table' AND name != 'sqlite_sequence'") # Tabellenamen herrausfinden.
        query.exec()                
        while query.next():                      
                table_name=query.value("name")
                with self.managed_query() as query1: 
                       query1.prepare(f"SELECT * FROM {table_name} WHERE {table_name}Link LIKE :link)
                       query1.bindValue(":link", f"{link}%")                                       
                       query1.exec()