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()
