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