def get_last_unlarmed_faileds(cls):
unlarmeds = {}
for ura in Ura.get_uras_numbers():
results_obj = (session.query(cls).filter_by(
to_number=ura, success=False,
alarmed_at=None).order_by(ResultTest.start_at.desc()).all())
unlarmeds.update({ura: results_obj})
return unlarmeds
def find_by_id(cls, _id):
user = session.query(cls).filter_by(id=_id).first()
return user
def find_by_username(cls, username):
return session.query(cls).filter_by(username=username).first()
def get_is_active(cls):
return session.query(cls).first().is_active
def find_by_label(cls, label):
return session.query(cls).filter_by(label=label).first()
def find_by_number(cls, number):
return session.query(cls).filter_by(number=number).first()
def find_all(cls, actives=True):
if not actives:
return session.query(cls).all()
return session.query(cls).filter_by(active=True).all()
def find_all(cls):
return session.query(cls).all()
def find_by_to_number(cls, number, limit=3):
return (session.query(cls).filter_by(to_number=number).order_by(
ResultTest.start_at.desc()).limit(limit).all())
def find_by_id(cls, id):
return session.query(cls).filter_by(id=id).one_or_none()
