def execute(self, sql, par=None): """Execute an sql statement""" cur = self.__conn.cursor(cursor_factory=psycopg2.extras.DictCursor) try: cur.execute(sql, par) except psycopg2.ProgrammingError as e: raise e try: rows = cur.fetchall() except: rows = None self.__conn.commit() #return rows return wut.encodeobject(rows)
def __init__(self, waEnviron, loadjson=True): """ Initialize resource object @param waEnviron: waEnviron variable see L(wa) @type waEnviron: C{dictionary} """ self.response = {"success": True, "message": ""} self.waEnviron = waEnviron self.method = waEnviron["method"] self.pathinfo = waEnviron["pathinfo"] self.json = None self.postRequest = None if self.method in ["POST", "PUT"] and loadjson == True: import json self.json = ut.encodeobject(json.loads(waEnviron["wsgi_input"]))
def executeInTransaction(self, sql, par=None): """Execute an sql statement in an open session""" cur = self.__conn.cursor(cursor_factory=psycopg2.extras.DictCursor) try: cur.execute(sql, par) except psycopg2.ProgrammingError as e: print(e.message, file=sys.stderr) self.__conn.rollback() raise e except Exception as e: raise e try: rows = cur.fetchall() except: rows = None cur.close() #return rows return wut.encodeobject(rows)
def select(self, sql, par=None): """ Execute a select statement""" if sql.lstrip()[0:6].lower() == "select": cur = self.__conn.cursor(cursor_factory=psycopg2.extras.DictCursor) try: cur.execute(sql, par) except psycopg2.ProgrammingError as e: raise e try: rows = cur.fetchall() except: rows = None #self.__conn.commit() cur.close() #return rows return wut.encodeobject(rows) else: raise Exception("sql must be a SELECT statement")
def select(self,sql,par=None): """ Execute a select statement""" if sql.lstrip()[0:6].lower() == "select": cur = self.__conn.cursor(cursor_factory=psycopg2.extras.DictCursor) try: cur.execute(sql,par) except psycopg2.ProgrammingError as e: raise e try: rows = cur.fetchall() except: rows = None #self.__conn.commit() cur.close() #return rows return wut.encodeobject(rows) else: raise Exception("sql must be a SELECT statement")
def executeInTransaction(self,sql,par=None): """Execute an sql statement in an open session""" cur = self.__conn.cursor(cursor_factory=psycopg2.extras.DictCursor) try: cur.execute(sql,par) except psycopg2.ProgrammingError as e: print >> sys.stderr, e.message self.__conn.rollback() raise e except Exception as e: raise e try: rows = cur.fetchall() except: rows = None cur.close() #return rows return wut.encodeobject(rows)
def __init__(self, waEnviron, loadjson=True): """ Initialize resource object @param waEnviron: waEnviron variable see L(wa) @type waEnviron: C{dictionary} """ self.user = False if 'user' in waEnviron: self.user = waEnviron['user'] self.response = {"success": True, "message": ""} self.waEnviron = waEnviron self.method = waEnviron['method'] self.pathinfo = waEnviron['pathinfo'] self.json = None self.postRequest = None if self.method in ["POST", "PUT"] and loadjson == True: import json self.json = ut.encodeobject(json.loads(waEnviron['wsgi_input']))
def __init__(self, wnsEnviron, loadjson=True): """ Initialize resource object @param wnsEnviron: wnsEnviron variable see L(wa) @type wnsEnviron: C{dictionary} """ self.response = { "success": True, "message": "" } self.wnsEnviron = wnsEnviron self.method = wnsEnviron['method'] self.pathinfo = wnsEnviron['pathinfo'] self.json = None self.postRequest = None if self.method in ["POST", "PUT"] and loadjson: import json self.json = ut.encodeobject(json.loads(wnsEnviron['wsgi_input'])) defaultCFGpath = os.path.join(wnsEnviron["services_path"], "default.cfg") self.serviceconf = configManager.waServiceConfig(defaultCFGpath)
def __init__(self, wnsEnviron, loadjson=True): """ Initialize resource object parameters: wnsEnviron (dict): wnsEnviron variable see L(wa) """ self.response = { "success": True, "message": "" } self.wnsEnviron = wnsEnviron self.method = wnsEnviron['method'] self.pathinfo = wnsEnviron['pathinfo'] self.json = None self.postRequest = None if self.method in ["POST", "PUT"] and loadjson: import json self.json = ut.encodeobject(json.loads(wnsEnviron['wsgi_input'])) defaultCFGpath = os.path.join(wnsEnviron["services_path"], "default.cfg") self.serviceconf = configManager.waServiceConfig(defaultCFGpath)