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