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