def multirow(sql, level=0, extra_vars = None): db_cursor = _get_cursor() _cursor_execute(db_cursor,sql, utils.parent_vars(level+1, extra_vars)) rows= db_cursor.fetchall() colnames = [t[0] for t in db_cursor.description] dict_rows = [dict(zip(colnames, row)) for row in rows] # if we'er not in a transaction, commit since pyscopg2 opens a transaction on every query _done() return dict_rows
def perform(sql, level=0, extra_vars= None): db_cursor = _get_cursor() _cursor_execute(db_cursor,sql, utils.parent_vars(level+1,extra_vars)) _done()