def get_components(): if not hasattr(get_components, "components"): cur = connection.get_cursor() cur.execute("""SELECT name FROM COMPONENTS""") rows = cur.fetchall() get_components.components = set([row[0] for row in rows]) return get_components.components
def crash_and_burn(self, queries): answers = [] cur = connection.get_cursor() for query in queries: try: cur.execute(query) result = cur.fetchall() df = DataFrame(result) answers.append(df[0].tolist()) except (Exception): pass cur.close() return answers