def queuelog_exists_record(log):
if isinstance(log, list): # improveme later...sure
log = parse_list_record(log)
return session_db.query(exists().where(QueueLog.time == log['time']).where(
QueueLog.event == log['event']).where(
QueueLog.queuename == log['queuename']).where(
QueueLog.callid == log['callid'])).scalar()
def queuelog_exists_record(log):
if isinstance(log, list): # improveme later...sure
log = parse_list_record(log)
return session_db.query(
exists().where(QueueLog.time == log['time']).
where(QueueLog.event == log['event']).
where(QueueLog.queuename == log['queuename']).
where(QueueLog.callid == log['callid'])
).scalar()
def queuelog_event_by_range_and_types(start_date, end_date, events=None,
agent=None, queue=None):
try:
q = session_db.query(QueueLog)
if start_date:
q = q.filter(QueueLog.time >= start_date)
if end_date:
q = q.filter(QueueLog.time <= end_date)
if events:
q = q.filter(QueueLog.event.in_(events))
if agent:
q = q.filter(QueueLog.agent.in_(agent))
if queue:
q = q.filter(QueueLog.queuename == queue)
return q.order_by(QueueLog.id.asc()).all()
except NoResultFound, e:
print(e)
return None
def queuelog_event_by_range_and_types(start_date,
end_date,
events=None,
agent=None,
queue=None):
try:
q = session_db.query(QueueLog)
if start_date:
q = q.filter(QueueLog.time >= start_date)
if end_date:
q = q.filter(QueueLog.time <= end_date)
if events:
q = q.filter(QueueLog.event.in_(events))
if agent:
q = q.filter(QueueLog.agent.in_(agent))
if queue:
q = q.filter(QueueLog.queuename == queue)
return q.order_by(QueueLog.id.asc()).all()
except NoResultFound, e:
print(e)
return None
