def where(cls, params):
"""
Query for particular users
:param params: dictionary of column: value parameters
:return: list of matching User objects
"""
if not isinstance(params, dict):
raise UserException(
'Where arguments must be passed as a dictionary')
sql, values = format_sql_params(cls.base_sql, params)
ret = []
log_sql = ''
try:
with db_instance() as db:
log_sql = db.cursor.mogrify(sql, values)
logger.info('user.py where sql: {}'.format(log_sql))
db.select(sql, values)
for i in db:
obj = User(i["username"], i["email"], i["first_name"],
i["last_name"], i["contactid"])
ret.append(obj)
except DBConnectException as e:
logger.debug('Error querying for users: {}\n'
'sql: {}'.format(e.message, log_sql))
raise UserException(e)
return ret
def where(cls, params):
"""
Query for a particular row in the ordering_scene table
:param params: dictionary of column: value parameter to select on
:return: list of matching Scene objects
"""
if not isinstance(params, dict):
raise SceneException('Where arguments must be '
'passed as a dictionary')
sql, values = format_sql_params(cls.base_sql, params)
ret = []
log_sql = ''
try:
with db_instance() as db:
log_sql = db.cursor.mogrify(sql, values)
logger.info('scene.py where sql: {}'.format(log_sql))
db.select(sql, values)
for i in db:
sd = dict(i)
obj = Scene(**sd)
ret.append(obj)
except DBConnectException as e:
logger.critical('Error retrieving scenes: {}\n'
'sql: {}'.format(e.message, log_sql))
raise SceneException(e)
return ret
def where(cls, params):
"""
Query for a particular row in the ordering_oder table
:param params: dictionary of column: value parameter to select on
:return: list of matching Order objects
"""
if not isinstance(params, dict):
raise OrderException('Where arguments must be '
'passed as a dictionary')
sql, values = format_sql_params(cls.base_sql, params)
ret = []
log_sql = ''
try:
with db_instance() as db:
log_sql = db.cursor.mogrify(sql, values)
logger.info('order.py where sql: {}'.format(log_sql))
db.select(sql, values)
for i in db:
od = dict(i)
obj = Order(**od)
ret.append(obj)
except DBConnectException as e:
logger.debug('Error order where: {}\n'
'sql: {}'.format(e.message, log_sql))
raise OrderException(e)
return ret
