def populate_temp_table(self, cursor: connection.cursor, temp_table: TempTableName) -> None: sql_template = "INSERT INTO {0} SELECT * FROM ({1}) AS {0}_contents;" with Timer(f"Populate '{temp_table.value}'"): cursor.execute( sql_template.format(temp_table.value, TEMP_TABLE_CONTENTS[temp_table]))
def dictfetchall(cursor: connection.cursor) -> List[Dict[str, Any]]: "Returns all rows from a cursor as a dict" desc = cursor.description return [ dict(list(zip([col[0] for col in desc], row))) for row in cursor.fetchall() ]
def dictfetchall(cursor: connection.cursor) -> List[Dict[str, Any]]: "Returns all rows from a cursor as a dict" desc = cursor.description return [ dict(list(zip([col[0] for col in desc], row))) for row in cursor.fetchall() ]