def getMenuList(typeId, input):
menuLists = DataModels.List_Menu_Details()
try:
menu_json = {
"name": [],
}
session = sessionRepo()
db_result_cities = session.query(DbClasses.menus_Repository).with_entities(DbClasses.menus_Repository.city).distinct(DbClasses.menus_Repository.city)\
.filter(DbClasses.menus_Repository.city.ilike("%" + input + "%")).all()
for value in db_result_cities:
menuLists.menuList.append(value.city)
session = sessionRepo()
db_result_menus = session.query(
DbClasses.menus_Repository).with_entities(
DbClasses.menus_Repository.menu_name).filter(
DbClasses.menus_Repository.type_id == typeId).filter(
DbClasses.menus_Repository.menu_name.ilike("%" +
input +
"%")).all()
for value in db_result_menus:
menuLists.menuList.append(value.menu_name)
#menuLists.menuList = menu_json
menuLists.isFailure = False
menuLists.message = "Menu list fetched from MenuRepository"
except Exception as error:
store_error_log(error)
menuLists.isFailure = True
menuLists.message = "Menu list not fetched from MenuRepository"
return menuLists
def get_single_menu_details(menuId):
Menus = DataModels.List_Menu_Details()
try:
session = sessionRepo()
db_result = session.query(
DbClasses.menus_Repository, DbClasses.menuRoom_Repository,
DbClasses.room_Repository).from_statement(
text('''select room.id,app_room.room_id,menu.menu_id,
menu.menu_name,menu.place_address,menu.city,menu.state,menu.country,menu.map,
app_room.room_name,room.cost,room.amenities,room.room_info
from tbl_app_menu_m as menu INNER JOIN tbl_menu_room_t as room
ON menu.menu_id = room.menu_id
INNER JOIN tbl_app_room_m as app_room
ON app_room.room_id = room.room_id
where menu.menu_id = :id '''
)).params(id=menuId).all()
if db_result is None:
response = BaseEntitySet(
True, "Selected Menu list is not fetched from MenuRepository")
return response
for value in db_result:
menu_json = {
"id": value.menus_Repository.menu_id,
"name": value.menus_Repository.menu_name,
"address": value.menus_Repository.place_address,
"city": value.menus_Repository.city,
"state": value.menus_Repository.state,
"country": value.menus_Repository.country,
"type": value.room_Repository.room_name,
"cost": value.menuRoom_Repository.cost,
"amenities": value.menuRoom_Repository.amenities,
"info": value.menuRoom_Repository.room_info,
"map": value.menus_Repository.map,
"galId": "gal-" + str(value.menus_Repository.menu_id)
}
Menus.menuList.append(menu_json)
Menus.isFailure = False
Menus.message = "Menu list fetched from MenuRepository"
except SQLAlchemyError as error:
store_error_log(error)
Menus.isFailure = True
Menus.message = "Menu list fetched from MenuRepository"
return Menus.menuList
def insert_traveller_details(json_data):
try:
session=sessionRepo()
user= DbClasses.user_Repository()
user.first_name=json_data["first_name"]
user.last_name = json_data["last_name "]
user.mobile_number=json_data["mobile_number"]
user.initial=json_data["initial"]
user.is_guest=json_data["is_guest"]
user.password=json_data["password"]
session.add(user)
session.commit()
return True
except SQLAlchemyError as error:
print(error)
return True
def get_menus(typeId):
menuList = DataModels.List_Menu_Details()
try:
session = sessionRepo()
db_result = session.query(
DbClasses.menus_Repository, DbClasses.menuRoom_Repository,
DbClasses.room_Repository).from_statement(
text('''select room.id,app_room.room_id,menu.menu_id,
menu.menu_name,menu.place_address,menu.city,menu.state,menu.country,
app_room.room_name,room.cost,room.amenities,room.room_info
from tbl_app_menu_m as menu INNER JOIN tbl_menu_room_t as room
ON menu.menu_id = room.menu_id
INNER JOIN tbl_app_room_m as app_room
ON app_room.room_id = room.room_id
where menu.type_id = :id'''
)).params(id=typeId).all()
if db_result is None:
menuList.isFailure = True
menuList.message = "Menu list not fetched from MenuRepository"
return menuList
for value in db_result:
menu_json = {
"id": value.menus_Repository.menu_id,
"name": value.menus_Repository.menu_name,
"address": value.menus_Repository.place_address,
"city": value.menus_Repository.city,
"state": value.menus_Repository.state,
"country": value.menus_Repository.country,
"type": value.room_Repository.room_name,
"cost": value.menuRoom_Repository.cost,
"amenities": value.menuRoom_Repository.amenities,
"info": value.menuRoom_Repository.room_info
}
menuList.menuList.append(menu_json)
menuList.isFailure = False
except SQLAlchemyError as error:
store_error_log(error)
menuList.isFailure = True
menuList.message = "Menu list not fetched from MenuRepository"
return menuList
def filter_menu_list(typeId, city, fromValue, toValue):
Menus = DataModels.List_Menu_Details()
menuIdList = list()
menu_json = dict()
try:
session = sessionRepo()
db_result = session.query(DbClasses.menus_Repository)\
.filter(DbClasses.menus_Repository.type_id == typeId).filter(DbClasses.menus_Repository.city.ilike("%" + city + "%")).all()
if db_result is None or db_result == '':
Menus.isFailure = False
Menus.message = "Selected Menu ID not fetched from MenuRepository"
return Menus
for data in db_result:
menuIdList.append(data.menu_id)
db_info_result = session.query(DbClasses.menuRoom_Repository)\
.filter(DbClasses.menuRoom_Repository.menu_id.in_(menuIdList)).filter(DbClasses.menuRoom_Repository.cost <=toValue).filter(DbClasses.menuRoom_Repository.cost >= fromValue).all()
if db_info_result is None or db_result == '':
Menus.isFailure = False
Menus.message = "Selected Menu info not fetched from MenuRoomRepository"
return Menus
for value, item in zip(db_result, db_info_result):
menu_json = {
"id": value.menu_id,
"name": value.menu_name,
"address": value.place_address,
"city": value.city,
"state": value.state,
"country": value.country,
"cost": item.cost,
"amenities": item.amenities,
"info": item.room_info,
"galId": "gal-" + str(value.menu_id)
}
Menus.menuList.append(menu_json)
return Menus
except SQLAlchemyError as error:
store_error_log(error)
Menus.isFailure = True
Menus.message = "Selected Menu list is not fetched from MenuRepository"
return Menus
def get_searched_menu(input, typeId):
search_result = DataModels.List_Menu_Details()
#search_result = []
if input == '':
search_result.isFailure = False
search_result.message = "Search Input Field is blank"
return search_result
try:
session = sessionRepo()
db_result = session.query(DbClasses.menus_Repository).with_entities(
DbClasses.menus_Repository.menu_id).filter(
or_(
DbClasses.menus_Repository.city.ilike("%" + input + "%"),
DbClasses.menus_Repository.menu_name.
ilike("%" + input + "%"))).filter(
DbClasses.menus_Repository.type_id.ilike("%" + typeId +
"%")).all()
if db_result is None or db_result == '':
search_result.isFailure = False
search_result.message = "Selected Menu ID not fetched from MenuRepository"
return search_result
for id in range(len(db_result)):
val = db_result[id]
result = get_single_menu_details(val[0])
search_result.menuList.append(result)
if len(search_result.menuList) == 0:
search_result.isFailure = False
search_result.message = "Selected Menu ID not fetched from MenuRepository"
return search_result
#for data in search_result.menuList:
#print(search_result.menuList[0][0]['city'])
except SQLAlchemyError as error:
store_error_log(error)
search_result.isFailure = True
search_result.message = "Selected Menu ID not fetched from MenuRepository"
return search_result
def booking_Repository_details(json_data):
try:
session = sessionRepo()
booking = DbClasses.booking_Repository()
booking.check_in_date = json_data["check_in_date"]
booking.check_out_date = json_data["check_out_date"]
booking.no_of_persons = json_data["no_of_persons"]
booking.no_of_childs = json_data["no_of_childs"]
booking.no_of_rooms = json_data["no_of_rooms"]
booking.total_price = json_data["total_price"]
session.add(booking)
session.commit()
response = BaseEntitySet(False,
"Data inserted to the booking repository")
return response
except SQLAlchemyError as error:
store_error_log(error)
response = BaseEntitySet(
True, "Data not inserted to the booking repository")
return response