def query_resident_by_room(room_number, resident_name):
room = query_room_by_room_number(room_number)
resident = query_resident_by_name(resident_name)
user = session.query(ResidentAccount).filter_by(
id_resident=resident.id_resident, id_room=room.id_room).first()
return user
def query_resident(*, username: str, pwd: str):
result = ''
try:
result = session.query(Resident.id_resident,Resident.name,Resident.username,Resident.pwd,Room.description,
Room.number,Room.id_room,Room.floor,Room.daily_value).join(ResidentAccount,
Resident.id_resident==ResidentAccount.id_resident).\
join(Room,Room.id_room==ResidentAccount.id_room).filter(Resident.username==username,Resident.pwd==pwd).first()
except Exception as e:
print(e)
return result
def query_room_by_room_number(room_number):
return session.query(Room).filter_by(number=room_number).first()
def query_resident_by_name(name):
return session.query(Resident).filter_by(name=name).first()
def query_all_rooms():
return session.query(Room).all()
def query_services_names():
"""Retorna dados dos serviços cadastradps"""
return session.query(Service).all()
def query_room_by_id(room_id):
return session.query(Room).filter_by(id_room=room_id).first()
def query_resident_by_id(id):
return session.query(Resident).filter_by(id_resident=id).first()
def query_room_by_id(room_id):
return session.query(Room).first()
def query_employee(*, name: str, pwd: str):
"""Busca usuarios no banco de dados através do nome e senha"""
return session.query(Employee)\
.filter_by(name=name, pwd=pwd).first()
def query_specific_status_orders(status, amount):
return session.query(Order).filter_by(status=status).limit(
int(amount)) # NOQA
def query_order_by_id(id):
return session.query(Order).filter_by(id_order=id).first()
def query_all_orders(amount):
return session.query(Order).limit(int(amount)).all()
def service_status_2(id_user, id_order):
value = session.query(Order.id_order,Order.total_value,Order.date,Order.status,ItemOrder.amount,ItemOrder.value,
Service.name,Service.id_service,Service.description).join(ItemOrder,
Order.id_order==ItemOrder.id_order)\
.join(Service,Service.id_service==ItemOrder.id_service).filter(Order.id_resident==id_user).filter(Order.id_order == id_order)
return set([(item[1], item[6], item[3], item[4]) for item in value])
def service_status(id_user, id_room):
value = session.query(Order.id_order,Order.total_value,Order.date,Order.status,ItemOrder.amount,ItemOrder.value,
Service.name,Service.id_service,Service.description).join(ItemOrder,
Order.id_order==ItemOrder.id_order)\
.join(Service,Service.id_service==ItemOrder.id_service).filter(Order.id_resident==id_user).filter(Order.id_room==id_room).all()
return value
def query_user(*, username: str, pwd: str):
"""Busca usuarios no banco de dados através do nome e senha"""
return session.query(User)\
.filter_by(username=username, pwd=pwd).first()
def query_all_resident_accounts():
return session.query(ResidentAccount).all()
def query_all_employees():
return session.query(Employee).all()
def query_all_free_rooms():
return session.query(Room).filter_by(status='Livre').all()
def query_all_busy_rooms():
return session.query(Room).filter_by(status='Ocupado').all()
def load_user(id):
return db_session.query(Employee).filter_by(id=ord(id)).first()
def query_resident_account_by_room_id(id):
return session.query(ResidentAccount).filter(
ResidentAccount.id_room == id,
ResidentAccount.status == "Aberto").first()
