def get_expiry_dates(expiry_date, card_number):
try:
con = DBConnectivity.create_connection()
cur = DBConnectivity.create_cursor(con)
cur.execute(
"SELECT EXPIRY_DATE FROM CARD_DETAILS WHERE CARD_NUMBER=:card_no AND EXPIRY_DATE=:exp_date",
{
"card_no": card_number,
"exp_date": expiry_date
})
list_of_expiry_dates = []
for x in cur:
c_obj = Card_Details()
c_obj.set_expiry_date(x[0])
list_of_expiry_dates.append(c_obj)
return list_of_expiry_dates
finally:
cur.close()
con.commit()
con.close()
def perform_transfer(debit_account,credit_account,transfer_amount):
try:
con=DBConnectivity.create_connection()
cur1=DBConnectivity.create_cursor(con)
cur1.execute("update account set amount=amount-(:transfer_amount) where account_number=:debit_account",
{"debit_account":debit_account,"transfer_amount":transfer_amount})
cur1.execute("update account set amount=amount+(:transfer_amount) where account_number=:credit_account",
{"credit_account":credit_account,"transfer_amount":transfer_amount})
cur1.execute("select count(Transaction_id) from transactions ")
a=cur1.fetchall()
print(a)
f=0
if ( a[0][0] )!=0:
cur1.execute("select max(transaction_id) from transactions")
b=cur1.fetchall()
c=(int(b[0][0])+int(1) )
cur1.execute("insert into transactions values("+str(c)+","+debit_account+","+credit_account+",to_date('"+DateUtility.get_todays_date()+"','DD-mm-yyyy') ,"+transfer_amount+")")
f=c
else:
print(DateUtility.get_todays_date())
cur1.execute("insert into transactions values(1,"+debit_account+","+credit_account+",to_date('"+DateUtility.get_todays_date()+"','DD-mm-yyyy'),"+transfer_amount+")")
f=1
except Exception as e:
print(e)
finally:
cur1.close()
con.commit()
con.close()
return f
def transaction(list_of_details, amount):
try:
con = DBConnectivity.create_connection()
cur = DBConnectivity.create_cursor(con)
card_number = list_of_details[0].get_card_number()
balance = list_of_details[0].get_balance()
amount = float(amount)
if balance < amount:
return False
balance -= amount
cur.execute(
"UPDATE CARD_DETAILS SET BALANCE=:bal WHERE CARD_NUMBER=:card_no",
{
"bal": balance,
"card_no": card_number
})
return True
finally:
cur.close()
con.commit()
con.close()
def get_customer_name(customer_name, card_number):
try:
con = DBConnectivity.create_connection()
cur = DBConnectivity.create_cursor(con)
cur.execute(
"SELECT CUST_NAME FROM CARD_DETAILS WHERE CARD_NUMBER=:card_no AND UPPER(CUST_NAME)=:cust_name",
{
"card_no": card_number,
"cust_name": customer_name.upper()
})
list_of_customer_names = []
for x in cur:
c_obj = Card_Details()
c_obj.set_cust_name(x[0])
list_of_customer_names.append(c_obj)
return list_of_customer_names
finally:
cur.close()
con.commit()
con.close()
def get_details(phone_no, acct_no):
try:
con = DBConnectivity.create_connection()
cur = DBConnectivity.create_cursor(con)
cur.execute(
"SELECT * FROM CUSTOMER_DTH WHERE PHONE_NO=:ph_no OR ACCOUNT_ID=:acc_no",
{
"ph_no": phone_no,
"acc_no": acct_no.upper()
})
list_of_details = []
for account_id, dth_balance, due_date, phone_no, op_id in cur:
customer_obj = Customer_DTH()
customer_obj.set_account_id(account_id)
customer_obj.set_dth_balance(dth_balance)
dd = str(due_date)
customer_obj.set_due_date(dd[:10])
customer_obj.set_phone_no(phone_no)
customer_obj.set_op_id(op_id)
list_of_details.append(customer_obj)
return list_of_details
finally:
cur.close()
con.commit()
con.close()
def get_RMN(phone_no, operator_id):
try:
con = DBConnectivity.create_connection()
cur = DBConnectivity.create_cursor(con)
cur.execute(
"SELECT PHONE_NO FROM CUSTOMER_DTH WHERE PHONE_NO=:ph_no AND OP_ID=:op_id",
{
"ph_no": phone_no,
"op_id": operator_id.upper()
})
list_of_phone_numbers = []
for rmn in cur:
rmn_obj = Customer_DTH()
rmn_obj.set_phone_no(rmn[0])
list_of_phone_numbers.append(rmn_obj)
return list_of_phone_numbers
finally:
cur.close()
con.commit()
con.close()
def search_as_all(city, area, rating_lower, rating_upper, var1):
try:
con = DBConnectivity.create_connection()
cur = DBConnectivity.create_cursor(con)
list_of_restaurants = []
cur.execute(
"select restaurantname,type_of_food,likes,dislikes,rating from restaurants where city=:category4 and area=:category5 and type_of_food like :category and rating between :category2 and :category3 order by likes desc,dislikes asc",
{
"category": '%' + var1 + '%',
"category2": rating_lower,
"category3": rating_upper,
"category4": city,
"category5": area
})
for restaurantname, type_of_food, likes, dislikes, rating in cur:
select = Select()
select.set_restaurantname(restaurantname)
select.set_type_of_food(type_of_food)
select.set_likes(likes)
select.set_dislikes(dislikes)
select.set_rating(rating)
list_of_restaurants.append(select)
return list_of_restaurants
finally:
cur.close()
con.close()
def get_selected_food_items_present(selected_food_items,restaurant_name) :
try:
# print("//////////////////def get_selected_food_items_present/////////////////////")
# print()
con=DBConnectivity.create_connection()
cur=DBConnectivity.create_cursor(con)
list_of_selected_food_items_present=[]
#restaurant_name = FoodModule.Food.restaurant_name
# print("restaurant_name")
# print(restaurant_name)
for food_items in selected_food_items :
cur2=DBConnectivity.create_cursor(con)
cur2.execute("select foodname from fooditem where foodname =:food_n and restaurant_name =:restaurant_n" , {"food_n" :food_items, "restaurant_n" : restaurant_name})
for val in cur2 :
print(val)
list_of_selected_food_items_present.append(val[0])
# print("After execute")
# print("list_of_selected_food_items_present")
# print(list_of_selected_food_items_present)
return list_of_selected_food_items_present
finally :
cur.close()
con.close()
def search_highest_rated():
try:
con = DBConnectivity.create_connection()
cur = DBConnectivity.create_cursor(con)
list_of_restaurants = []
cur.execute(
"select restaurantname,type_of_food,likes,dislikes,rating from (select restaurantname,type_of_food,likes,dislikes,rating from restaurants order by rating desc) where rownum < 6"
)
for restaurantname, type_of_food, likes, dislikes, rating in cur:
select = Select()
select.set_restaurantname(restaurantname)
select.set_type_of_food(type_of_food)
select.set_likes(likes)
select.set_dislikes(dislikes)
select.set_rating(rating)
list_of_restaurants.append(select)
return list_of_restaurants
finally:
cur.close()
con.close()
def get_package_detail(cust_id, current_operator):
if (cust_id.isalpha()):
raise InvalidDTHOperatorException()
try:
con = DBConnectivity.create_connection()
cur = DBConnectivity.create_cursor(con)
cur.execute(
"select * from DTHUser where CustId=:CustId and Operator=:Operator",
{
"CustId": cust_id,
"Operator": current_operator
})
data = cur.fetchall()
if (len(data) == 0):
raise InvalidDTHOperatorException()
else:
return data
finally:
cur.close()
con.close()
#except InvalidMobileNumberException as e:
#print(e)
#check_mobile_operator(9040)
#validate_dth_operator('SMP')
#get_package_detail(1)
def new_pwd(user, mob_no):
try:
con = DBConnectivity.create_connection()
cur3 = DBConnectivity.create_cursor(con)
list_of_passwords = []
cur3.execute("select * from pwd_check where mob_no=" + str(mob_no))
for row in cur3:
pwd1 = row[1]
pwd2 = row[2]
pwd3 = row[3]
list_of_passwords.append(pwd1)
list_of_passwords.append(pwd2)
list_of_passwords.append(pwd3)
#print(list_of_passwords)
if (user.get_pwd() in list_of_passwords):
print("your password can not be previous 3 passwords")
else:
update_pwd_check = viewDB.update_password_check(
user, list_of_passwords, mob_no)
update_pwd = viewDB.update_password(user, mob_no)
if (update_pwd == True):
return True
else:
return False
finally:
cur3.close()
con.close()
def city_wise_highest_booked(city):
try:
con=DBConnectivity.create_connection()
cur=DBConnectivity.create_cursor(con)
list_of_restaurants=[]
cur.execute("select t.restaurantname, t.city, t.area, t.rating from restaurants t WHERE T.CITY =:category AND t.rating in(select max(u.rating) from restaurants u where u.city =:category group by u.city)",{"category":city})
for restaurantname,city,area,rating in cur:
select=Select()
select.set_restaurantname(restaurantname)
select.set_city(city)
select.set_area(area)
select.set_rating(rating)
list_of_restaurants.append(select)
return list_of_restaurants
finally:
cur.close()
con.close()
def db_updating_transection_table():
try:
con = DBConnectivity.create_connection()
cur = DBConnectivity.create_cursor(con)
cur.execute(
"select order_count from User_Transactions where username = :username",
{"username": this_username})
for i in cur:
user_count = i[0]
user_count += 1
cur.execute(
"update User_Transactions set order_count = :user_count where username = :username",
{
"username": this_username,
"user_count": user_count
})
cur.execute(
"select overall_total_price from User_Transactions where username = :username",
{"username": this_username})
for j in cur:
overall_total_price = j[0]
overall_total_price += Billing.total_charge
cur.execute(
"update User_Transactions set overall_total_price = :overall_total_price where username = :username",
{
"username": this_username,
"overall_total_price": overall_total_price
})
finally:
con.commit()
cur.close()
con.close()
def get_categories_fooditems(restaurant_name , category_name) :
try:
# print("////////////////def get_categories_fooditems///////////////////////")
# print()
con=DBConnectivity.create_connection()
cur=DBConnectivity.create_cursor(con)
list_of_restaurants_fooditems=[]
#print(restaurant_name)
cur.execute("select foodname , price , availability from fooditem where restaurant_name =:restaurant_n and category_name =:category_n",{"restaurant_n":restaurant_name, "category_n":category_name})
#print("After execute")
for foodName, price, availability in cur:
'''
In this loop, we are creating a ItemModule3 object for every row
and setting the values from the row into the CategoryItems object
'''
ItemModule3=CategoryItems()
ItemModule3.set_food_name(foodName)
ItemModule3.set_price(price)
ItemModule3.set_availability(availability)
'''
Here were are adding the FoodItems to a list
'''
list_of_restaurants_fooditems.append(ItemModule3)
return list_of_restaurants_fooditems
finally :
cur.close()
con.close()
def hotel_name(city, area, restaurant_name):
try:
con = DBConnectivity.create_connection()
cur = DBConnectivity.create_cursor(con)
list_of_restaurants = []
cur.execute(
"select restaurantname from restaurants where city=:category4 and area=:category5 and restaurantname=:category",
{
"category": restaurant_name,
"category4": city,
"category5": area
})
for restaurantname in cur:
select = Select()
select.set_restaurantname(restaurantname)
list_of_restaurants.append(select)
return list_of_restaurants
finally:
cur.close()
con.close()
def get_food_items_availability(selected_food_items,restaurant_name) :
try:
# print("//////////////////def get_food_items_availability/////////////////////")
# print()
con=DBConnectivity.create_connection()
cur=DBConnectivity.create_cursor(con)
list_of_food_items_availability=[]
#restaurant_name = FoodModule.Food.restaurant_name
for food_items in selected_food_items :
#print(food_items)
cur2=DBConnectivity.create_cursor(con)
cur2.execute("select availability from fooditem where foodname =:food_n and restaurant_name =:restaurant_n" , {"food_n" :food_items, "restaurant_n" : restaurant_name})
for val in cur2 :
list_of_food_items_availability.append(val[0])
# print("After execute")
# print("list_of_food_items_availability")
# print(list_of_food_items_availability)
return list_of_food_items_availability
finally :
cur.close()
con.close()
def search_as_likes(city, area):
try:
con = DBConnectivity.create_connection()
cur = DBConnectivity.create_cursor(con)
list_of_restaurants = []
cur.execute(
"select restaurantname,type_of_food,likes,dislikes,rating from restaurants where city=:category4 and area=:category5 order by likes desc",
{
"category4": city,
"category5": area
})
for restaurantname, type_of_food, likes, dislikes, rating in cur:
select = Select()
select.set_restaurantname(restaurantname)
select.set_type_of_food(type_of_food)
select.set_likes(likes)
select.set_dislikes(dislikes)
select.set_rating(rating)
list_of_restaurants.append(select)
return list_of_restaurants
finally:
cur.close()
con.close()
def checkchat_DB(obj):
try:
con = DBConnectivity.create_connection()
cur = DBConnectivity.create_cursor(con)
cur.execute(
"select count(*) from chatlog where sender=:mob_sender or receiver=:mob_receiver",
{
"mob_sender": obj.get_mobile_number(),
"mob_receiver": obj.get_mobile_number()
})
for row in cur:
count = row[0]
contactlist = []
if (count != 0):
cur.execute(
"select sender from chatlog where receiver=:mob_receiver union select receiver from chatlog where sender=:mob_sender",
{
"mob_sender": obj.get_mobile_number(),
"mob_receiver": obj.get_mobile_number()
})
for row in cur:
contactlist.append(row[0])
finally:
cur.close()
con.close()
return contactlist
def get_details(card_number):
try:
con = DBConnectivity.create_connection()
cur = DBConnectivity.create_cursor(con)
cur.execute("SELECT * FROM CARD_DETAILS WHERE CARD_NUMBER=:card_no",
{"card_no": card_number})
list_of_details = []
for a, b, c, d, e, f, g, h in cur:
c_obj = Card_Details()
c_obj.set_card_number(a)
c_obj.set_cust_name(b)
c_obj.set_expiry_date(c)
c_obj.set_cvv(d)
c_obj.set_card_type(e)
c_obj.set_status(f)
c_obj.set_balance(g)
c_obj.set_grid_code(h)
list_of_details.append(c_obj)
return list_of_details
finally:
cur.close()
con.commit()
con.close()
def get_values(sources, destinations, depttimes):
'''Returns list containing flights detail having matched conditions'''
try:
con = DBConnectivity.create_connection()
cur = DBConnectivity.create_cursor(con)
list_of_flights = []
cur.execute(
"select * from flight where Lower(destination) =: destinations and Lower(source) =: sources and Lower(depttime) >: depttimes",
{
"destinations": destinations,
"sources": sources,
"depttimes": depttimes
})
for row in cur:
flight = Flight(row[0], row[1], row[5], row[6], row[7])
list_of_flights.append(flight)
return list_of_flights
except Exception as e:
print("Sorry some system error occurred")
print(e)
finally:
cur.close()
con.close()
def get_Account_ID(acct_id, operator_id):
try:
con = DBConnectivity.create_connection()
cur = DBConnectivity.create_cursor(con)
cur.execute(
"SELECT ACCOUNT_ID FROM CUSTOMER_DTH WHERE ACCOUNT_ID=:acc_id AND OP_ID=:op_id",
{
"acc_id": acct_id.upper(),
"op_id": operator_id.upper()
})
list_of_account_ids = []
for a_id in cur:
customer_obj = Customer_DTH()
customer_obj.set_account_id(a_id[0])
list_of_account_ids.append(customer_obj)
return list_of_account_ids
finally:
cur.close()
con.commit()
con.close()
def check_flight(p_flightid,date_of_travel,p_no_of_children,p_no_of_adults,primary_passenger):
try:
con=DBConnectivity.create_connection()
cur=DBConnectivity.create_cursor(con)
flag=0
cur.execute("select adultfare,childfare from flight_details where flightid=:flight_id",{"flight_id":p_flightid})
for row in cur:
flag=1;
if row[0]==None:
raise InvalidFlightIdException()
else:
if(validate_date(date_of_travel)):
if(int(p_no_of_children)>=0 and int(p_no_of_children)<=4):
if(int(p_no_of_adults)>=1 and int(p_no_of_adults)<=4):
if(primary_passenger!=""):
fare=row[0]*int(p_no_of_adults)
fare+=row[1]*int(p_no_of_children)
return fare
else:
raise InvalidPrimaryPassenger()
else:
raise InvalidAdultsException()
else:
raise InvalidChildrenException()
else:
raise InvalidDateException()
if(flag==0):
raise InvalidFlightIdException()
finally:
cur.close()
con.close()
def get_phonenoinoperator(phone_no, operator):
try:
op = operator.upper()
opid = ""
count = []
con = DBConnectivity.create_connection()
cur = DBConnectivity.create_cursor(con)
cur2 = DBConnectivity.create_cursor(con)
cur.execute(
"select op_id from operator where upper(op_name)=:op_name and upper(op_id) like 'M%'",
{"op_name": op.upper()})
for cid in cur:
opid = cid[0]
cur2.execute(
"select phone_no from customer_mobile where op_id=:op_id and phone_no=:pho",
{
"op_id": opid.upper(),
"pho": phone_no
})
for ph in cur2:
phone = customer_mobile()
phone.set_phone_no(ph)
count.append(phone)
if (len(count) != 0):
return count
return False
finally:
cur.close()
cur2.close()
con.commit()
con.close()
def checkout_Yes(username):
#Dictionary
print("FoodName \t Quantity")
for index, value in FoodModule.Food.cart_dict.items():
print(index, " \t \t ", value)
is_registered_user_flag = FoodModule.Food.is_registered_user
if is_registered_user_flag == False:
print("Guest User Logging in")
FoodModule.Food.registered_user = '******'
try:
con = DBConnectivity.create_connection()
cur = DBConnectivity.create_cursor(con)
username = FoodModule.Food.registered_user
'''
SQL statement which is to be executed using bind variables
#insert into checkoutcart(username ,foodname , quantity) values ('Kautilya','Masala', 200);
'''
is_cart_saved = FoodModule.Food.is_cart_saved
# print(username)
# print("is_cart_saved")
# print(is_cart_saved)
if is_cart_saved:
#print("In if is_cart_saved ")
cur.execute("delete from checkoutcart where username =:user_n",
{"user_n": username})
FoodModule.Food.is_cart_saved = False
if FoodModule.Food.is_cart_saved == False:
#print("In if is_cart_saved == False ")
for index, value in FoodModule.Food.cart_dict.items():
cur.execute(
"insert into checkoutcart(username ,foodname , quantity) values (:user_n, :food_n , :qty_ord)",
{
"user_n": username,
"food_n": index,
"qty_ord": value
})
#Saving the flag for Direct Module 4 execution that The cart is been saved once for this registered user
FoodModule.Food.is_cart_saved = True
finally:
'''
Remove the print statement
'''
#print("Closing the cursor & connections in def checkout_Yes(username):")
FoodModule.Food.cart_dict.clear()
cur.close()
con.commit()
con.close()
'''
#Call Module 4 Billing
'''
ViewFunctionsBilling.start_billing()
def set_restaurant_attributes(temp_rest, id):
try:
con = DBConnectivity.create_connection()
cur = DBConnectivity.create_cursor(con)
cur.execute(
"select id, name, area, pincode, contactno from restaurant where id=:id",
{"id": id})
for id, name, area, pincode, contactno in cur:
temp_rest.set_contact_no(contactno)
temp_rest.set_restaurant_id(id)
temp_rest.set_pincode(pincode)
temp_rest.set_r_name(name)
temp_rest.set_area(area)
return 1
except:
return -1
finally:
cur.close()
con.close()
def get_products(category):
try:
con=DBConnectivity.create_connection()
cur=DBConnectivity.create_cursor(con)
list_of_products=[]
cur.execute("select productid, productname, price from sample_product where category=:category",{"category":category})
for product_id,name,price in cur:
'''
In this loop, we are creating a product object for every row
and setting the values from the row into the product object
'''
product=Product()
product.set_price(price)
product.get_price
product.set_product_id(product_id)
product.set_product_name(name)
'''
Here were are adding the product to a list
'''
list_of_products.append(product)
return list_of_products
finally:
cur.close()
con.close()
def insert_booking(flightid, dateoftravel, passengername, noofchild,
noofadults, totalfare):
'''calculates booking id and insert values in bookedflight table'''
try:
count = 1
con = DBConnectivity.create_connection()
cur = DBConnectivity.create_cursor(con)
cur2 = DBConnectivity.create_cursor(con)
cur2.execute("select * from bookedflight")
for row in cur2:
count += 1
bookingid = count
cur.execute(
"insert into bookedflight values(:bookingid,:flightid,to_date(:dateoftravel,'dd-mm-yy'),:passengername,:noofchild,:noofadults,:totalfare)",
{
"bookingid": bookingid,
"flightid": flightid,
"dateoftravel": dateoftravel,
"passengername": passengername,
"noofchild": noofchild,
"noofadults": noofadults,
"totalfare": totalfare
})
con.commit()
return bookingid
except Exception as e:
print("Sorry some system error occurred")
print(e)
finally:
cur.close()
con.close()
def validate_pincode(pincode):
try:
con = DBConnectivity.create_connection()
cur = DBConnectivity.create_cursor(con)
cur.execute("select id from restaurant where pincode like (" +
pincode[:4] + "%)")
count = 0
for row in cur:
count += 1
if count >= 1:
return 1
return 0
except:
return -1
finally:
cur.close()
con.close()
def login(username, password):
try:
con = DBConnectivity.create_connection()
cur = DBConnectivity.create_cursor(con)
cur.execute(
"select username,password,cityname,area from registration where username=:category1 and password=:category2",
{
"category1": username,
"category2": password
})
for username, password, cityname, area in cur:
'''
In this loop, we are creating a registration object for every row
and setting the values from the row into the registration object
'''
customer = Customer()
customer.set_username(username)
customer.set_password(password)
customer.set_city(cityname)
customer.set_area(area)
'''
Here were are adding the new registration to a list
'''
return customer
finally:
cur.close()
con.close()
def display_most_ordered_transactions_user():
print("In Function display_most_ordered_transactions_user")
try:
con = DBConnectivity.create_connection()
cur = DBConnectivity.create_cursor(con)
max_transact_user = ""
'''User Query
#select username from User_Transactions where order_count = ( select max(order_count) from User_Transactions);
'''
cur.execute(
"select username from User_Transactions where order_count = ( select max(order_count) from User_Transactions)"
)
for username in cur:
#print(username)
max_transact_user = username[0]
return max_transact_user
finally:
print(
"Closing the cursor & connections in (def display_most_ordered_transactions_user)"
)
cur.close()
con.close()
def language(mdate,language):
con=DBConnectivity.create_connection()
cur=DBConnectivity.create_cursor(con)
cur.execute("select language from BookMovie where dateofmovie=:date1",{"date1":mdate})
l=[]
for row in cur:
l.append(row[0].lower())
return l
def bookHotel(booking):
try:
con=DBConnectivity.create_connection()
cur=DBConnectivity.create_cursor(con)
cur.execute("insert into hotel_booking values(:bookingid,:hotelid,:flightid,:stayduration,:totalfare,:noofchildren,:noofadults,:eroom,:droom,:primarypassenger)",{"bookingid":booking.get_bookingid(),"hotelid":booking.get_hotel_id(),"flightid":booking.get_flight_id(),"stayduration":booking.get_days_of_stay(),"totalfare":booking.get_fare(),"noofchildren":booking.get_no_of_children(),"noofadults":booking.get_no_of_adults(),"eroom":booking.get_eroom(),"droom":booking.get_droom(),"primarypassenger":booking.get_primary_passenger()})
con.commit()
finally:
cur.close()
con.close()
def bookFlight(booking):
try:
con=DBConnectivity.create_connection()
cur=DBConnectivity.create_cursor(con)
cur.execute("insert into flight_booking values(:bookingid,:flightid,:totalfare,:primarypassenger,:noofchildren,:noofadults,:dateoftravel)",{"bookingid":booking.get_bookingid(),"flightid":booking.get_flight_id(),"totalfare":booking.get_fare(),"primarypassenger":booking.get_primary_passenger(),"noofchildren":booking.get_no_of_children(),"noofadults": booking.get_no_of_adults(),"dateoftravel":booking.get_date_of_travel()})
con.commit()
finally:
cur.close()
con.close()
def retrieve_count():
try:
con=DBConnectivity.create_connection()
cur=DBConnectivity.create_cursor(con)
cur.execute("select count(*) from flight_booking")
for row in cur:
return row[0];
finally:
cur.close()
con.close()
def get_booked_flight(fbookid):
try:
con=DBConnectivity.create_connection()
cur=DBConnectivity.create_cursor(con)
list_of_members=[]
cur.execute("select no_of_children,no_of_adults from flight_booking where bookingid=:fbookid",{"fbookid":fbookid})
for booking in cur:
list_of_members.append(booking[0])
list_of_members.append(booking[1])
return list_of_members
finally:
cur.close()
con.close()
def cancelHBooking(hbookingid):
try:
con=DBConnectivity.create_connection()
cur=DBConnectivity.create_cursor(con)
cur.execute("delete from hotel_booking where hotel_bookingid=:h_bookingid",{"h_bookingid":hbookingid})
if(cur.rowcount==0):
raise InvalidHotelBookingIdException()
else:
return True
except InvalidFlightBookingIdException as e:
print(e)
except DatabaseError as e:
print("Can not cancel the hotel booking")
except Exception as e:
print("Can not cancel hotel booking")
finally:
con.close()
cur.close()
def get_flight_with1Hop(p_source,p_destination):
try:
flag=0
con=DBConnectivity.create_connection()
cur=DBConnectivity.create_cursor(con)
cur.execute("select t1.flightid,t1.flightname,t1.source,t1.destination,t1.departuretime,t1.arrivaltime,t2.flightid,t2.flightname,t2.source,t2.destination,t2.departuretime,t2.arrivaltime from flight_details t1,flight_details t2 where t1.destination=t2.source and t1.source=:source and t2.destination=:destination",{"source":p_source,"destination":p_destination})
for row in cur:
flag=1
arr1=row[5]
dep2=row[10]
if(validate_timing(arr1,dep2)):
print_flight(row,1)
if(flag==1):
return True
else:
return False
finally:
cur.close()
con.close()
def cancelFBooking(fbookingid):
try:
con=DBConnectivity.create_connection()
cur=DBConnectivity.create_cursor(con)
cur.execute("delete from flight_booking where bookingid=:f_bookingid",{"f_bookingid":fbookingid})
if(cur.rowcount==0):
raise InvalidFlightBookingIdException()
else:
return True
except InvalidFlightBookingIdException as e:
print(e)
except DatabaseError as e:
print("Cancel you Hotel Booking first")
except InterfaceError as e:
print("Cancel you Hotel Booking first")
except Exception as e:
print("Cancel you Hotel Booking first")
finally:
con.close()
cur.close()
def check_hotel(p_hotelid,eroom,droom,days_of_stay,booking_name,children,adult):
try:
totalfare=0
con=DBConnectivity.create_connection()
cur=DBConnectivity.create_cursor(con)
cur.execute("select efare,dfare from hotel where hotelid=:hotel_id",{"hotel_id":p_hotelid})
flag=0
check =False
for row in cur:
flag=1
if(row[0]==None):
raise InvalidHotelIdException();
else:
check=hotel_validation.validate_member(eroom,adult)
if(check):
raise InvalidAdultExecutiveRoomsException()
check=hotel_validation.validate_room_members(eroom,droom,children,adult);
if(check):
raise InvalidNoOfRoomsException()
check=hotel_validation.validate_days_of_stay(days_of_stay)
if(check):
raise InvalidDaysOfStayException()
check=hotel_validation.validate_booking_name(booking_name)
if(check):
raise InvalidBookingNameException()
hotel_validation.validate_no_of_children(children)
hotel_validation.validate_no_of_adult(adult)
if(booking_name==""):
raise InvalidBookingNameException()
totalfare=(row[0]*eroom+row[1]*droom)*days_of_stay
return totalfare
if(flag==0):
raise InvalidHotelIdException()
for row in cur:
totalfare=(row[0]*eroom+row[1]*droom)*days_of_stay
return totalfare
finally:
cur.close()
con.close()
def get_hotels(location):
try:
con=DBConnectivity.create_connection()
cur=DBConnectivity.create_cursor(con)
list_of_hotels=[]
cur.execute("select hotelid, hotelname, location, efare, dfare from hotel where location=:location",{"location":location})
for hotelid,hotelname,location,efare,dfare in cur:
'''
In this loop, we are creating a product object for every row
and setting the values from the row into the product object
'''
hotel=Hotel()
hotel.set_hotelid(hotelid)
hotel.set_hotelname(hotelname)
hotel.set_location(location)
hotel.set_efare(efare)
hotel.set_dfare(dfare)
list_of_hotels.append(hotel)
return list_of_hotels
finally:
cur.close()
con.close()
