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