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 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()
def renderString(string): return Template(string, searchList=[utils.parent_vars(1)]).respond()
def render(template, extra_level=0): return Template(file=PREFIX + template + ".tmpl", searchList=[utils.parent_vars(1 + extra_level)]).respond()
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()