def list_due_items():
qry = Session.query(Item).join(Item.queue)\
.filter(Item.claimed != None).order_by(Item.claimed.asc()) # noqa
for item in qry:
exp = datetime.datetime.now() - \
datetime.timedelta(seconds=item.queue.release_time)
if item.claimed <= exp:
yield item
def init_model(engine):
Session.configure(bind=engine)
def list_items_in_queue(queue_id):
return Session.query(Item).filter(Item.queue_id==queue_id)\
.filter(Item.claimed==None)\
.order_by(Item.priority.desc(),
Item.created.asc()) # noqa
def get_queue(id):
return Session.query(Queue).get(id)
def save(obj):
Session.save(obj)
def commit():
Session.commit()
