def reserve_room(db, room_id, date): count = db.query(Booking).filter_by(room_id=room_id, date=date).count() if count == 0: db.add(Booking(room_id=room_id, date=date)) db.commit() return True return False