def createBoard():
menu.clearScreen()
print("Choose game board size:")
print("(1) Beginner - 9 x 9, 10 mines")
print("(2) Intermediate - 16 x 16, 40 mines")
print("(3) Expert - 16 x 30, 99 mines")
print("(C) Custom size...")
choice = menu.getChoice(['1', '2', '3', 'C'], 1)
if choice == '1':
board = Board(9, 9, 10)
elif choice == '2':
board = Board(16, 16, 40)
elif choice == '3':
board = Board(16, 30, 99)
else:
# Custom dimensions
rows = menu.getNumInRange(1, MAX_SIZE, "Enter number of rows")
columns = menu.getNumInRange(1, MAX_SIZE, "Enter number of columns")
mines = menu.getNumInRange(1, rows * columns, "Enter number of mines")
board = Board(rows, columns, mines)
# Now to randomize mines and find values
board.randomizeMines()
board.findValues()
print("Loaded.")
return board
def connect(connection_url):
menu.clearScreen()
print("Connect to Airline Booking Database\n")
# get username
user = input("Oracle Username: "******"\nConnecting...\n")
try:
# Establish a connection in Python
connection = cx_Oracle.connect(conString)
print("Connected!")
return connection
except cx_Oracle.DatabaseError as exc:
error, = exc.args
print(sys.stderr, "Oracle code:", error.code)
print(sys.stderr, "Oracle message:", error.message)
def createTable(mode = 0, connection = None, database_spec = None, drop_tables = None):
if mode == 1:
menu.clearScreen()
print("\nAirline Booking Setup")
# connect to database
curs = database.cursor(connection)
try:
# drop pre-existing tables
checkTable(drop_tables, curs)
# create tables
execSQL(database_spec, curs)
connection.commit()
database.close(None,curs)
print("Setup Complete\n")
except cx_Oracle.DatabaseError as exc:
error, = exc.args
print(sys.stderr, "Oracle code:", error.code)
print(sys.stderr, "Oracle message:", error.message)
def printBoard(theBoard):
menu.clearScreen()
# First, print column headers
print(" ", end="") # Offset
for col in range(theBoard.numColumns):
print(chr(col + 65), end=" ")
# Now print the rest of the board with row headers
print(end='\n')
for row in theBoard.box:
printString = chr(theBoard.box.index(row) + 65) + " |"
for square in row:
printString += "{}|".format(square.char)
print(printString)
# Mine count
print("\n" + "Mines: " + str(theBoard.numMines - theBoard.numFlags) + "\n")
def main():
responce = input(
'Enter 1: Create new password\nEnter 2: Search for username & password\nEnter any other to quit\n\n-> '
)
if responce == '1':
try:
passwordLength = int(
input('Enter password length (recommended: 12-16): '))
except ValueError:
print('\n\nError: Must be an Integer Value\n\n')
passwordLength = int(
input('Enter password length (recommended: 12-16): '))
menu.clearScreen()
siteName = str(input('Enter Site Name: '))
username = input('Enter Username or E-mail: ')
password = menu.encryptPassword(passwordLength)
with open('passwords.json') as json_file:
data = json.loads(json_file.read())
temp = data['passwords']
y = {
"site": str(siteName.lower()),
"username": str(username.lower()),
"password": password.decode('utf-8')
}
temp.append(y)
menu.writeJSON(data)
menu.clearScreen()
print('\n\n------------------------------------')
print('Password has been copid to clipboard')
print('------------------------------------\n\n')
main()
if responce == '2':
menu.clearScreen()
site_name = str(input('Enter Site Name: '))
menu.decryptPassword(site_name)
main()
else:
menu.clearScreen()
print('Bye Bye!')
exit()
def createTable(mode = 0, connection = None, database_spec = None, drop_tables = None):
if mode == 1:
menu.clearScreen()
print("\nAirline Booking Setup")
# connect to database
curs = database.cursor(connection)
try:
# drop pre-existing tables
checkTable(drop_tables, curs)
# create tables
execSQL(database_spec, curs)
connection.commit()
# insert single queries
# data = [('Quadbury', 101, 7.99, 0, 0)]
# cursInsert = connection.cursor()
# cursInsert.bindarraysize = 1
# cursInsert.setinputsizes(32, int, float, int, int)
# cursInsert.executemany("INSERT INTO TOFFEES(T_NAME, SUP_ID, PRICE, SALES, TOTAL) "
# "VALUES (:1, :2, :3, :4, :5)", data);
# cursInsert.close()
# read from a table
# # executing a query
# curs.execute("SELECT * from TOFFEES")
# # get all data and print it
# rows = curs.fetchall()
# for row in rows:
# print(row)
database.close(None,curs)
print("Setup Complete\n")
except cx_Oracle.DatabaseError as exc:
error, = exc.args
print(sys.stderr, "Oracle code:", error.code)
print(sys.stderr, "Oracle message:", error.message)
# CONST.DEBUG = True
if CONST.DEBUG:
stock = '^GSPC'
dateRange = ['2010/01/05', '2015/01/05']
percent = 80
else:
res = menu.menuLoop()
# print(res)
# Parse stock, dateRange and percentage of train data
stock = res[CONST.IDX_STOCK]
dateRange = res[CONST.IDX_DATE_RANGE]
percent = res[CONST.IDX_PERCENT_TRAINED]
# Clear screen
menu.clearScreen()
menu.welcomeMessage()
if stock == '' or len(dateRange) == 0 or percent == 0:
print('')
print('Exiting...')
print('')
exit()
# Begin Process message
print('')
print('Processing stock: {}'.format(stock))
print('Start-date: {}, end-date: {}'.format(dateRange[0], dateRange[1]))
print('Percentage trained-data(%): {}'.format(percent))
# Format date
def login(connection):
cursor = database.cursor(connection)
menu.clearScreen()
print(
"Login to Airline Booking System\n" +
"-------------------------\n" +
"Select an option:\n\n" +
"0 - Login\n" +
"1 - Create Account\n" +
"2 - Exit\n" +
"-------------------------"
)
entries = [x for x in range(3)]
while True:
option = input("\nOption: ")
if option == "0":
email = ""
password = ""
while len(email) > 20 or len(email) == 0:
email = input("\nEmail: ").strip().lower()
if len(email) > 20 or len(email) == 0:
print("Invalid Email Length, Try Again")
users = database.read("SELECT email FROM USERS", cursor)
if email not in users:
print("User does not exist!")
else:
while len(password) > 4 or len(password) == 0:
password = getpass.getpass("Password: "******"Invalid Password length, Try Again")
users_pass = database.read("SELECT pass FROM USERS", cursor)
if password != users_pass[users.index(email)]:
print("Incorrect password!")
elif password == users_pass[users.index(email)]:
break
elif option == "1":
email = ""
password = ""
while len(email) > 20 or len(email) == 0:
email = input("\nNew Email: ").strip().lower()
if len(email) > 20 or len(email) == 0:
print("Invalid Email Length, Try Again")
while len(password) > 4 or len(password) == 0:
password = getpass.getpass("New Password: "******"Invalid Password length, Try Again")
createUser(email, password, cursor)
connection.commit()
break
elif option == "2":
menu.clearScreen()
sys.exit()
elif option not in entries:
print("Invalid input, try again")
database.close(cursor)
return email
def list(connection, user):
while True:
cursor = database.cursor(connection)
search.create_views(cursor)
menu.clearScreen()
print("Existing Bookings\n\n" + \
"Select Row Number for more details or press enter to go back\n\n")
query = "select t.tno, t.name, to_char(b.dep_date, 'dd-mon-yy') as dep_date, t.paid_price, b.flightno \
from bookings b, tickets t where b.tno = t.tno and t.email = '{}'".format(user)
cursor.execute(query)
rows = cursor.fetchall()
count_view = 1
print(str("Row").ljust(6) + str("Tno").ljust(6) + str("Passenger Name").ljust(21) + str("Dep Date").ljust(12)\
+str("Price").ljust(8))
x = "-" * 61
print(x)
already_seen = []
if len(rows)!= 0:
for row in rows:
entry_string = [row[0],row[1], row[2],row[3]]
if entry_string not in already_seen:
print(str(count_view).ljust(6) + str(entry_string[0]).ljust(6) + str(entry_string[1]).strip().ljust(21) + str(entry_string[2]).ljust(12) + str(entry_string[3]).ljust(8))
already_seen.append(entry_string)
count_view+=1
else:
print("User has no flights")
entry = input("\n")
if entry == "":
break
elif not(verify.rowSelection(entry, count_view)):
print("Invalid entry, Try Again")
elif verify.rowSelection(entry, len(rows)):
entry = int(count_view)-2 # actual position in list of rows
menu.clearScreen()
print("Detailed Booking\n\n" + \
"Press enter to go back or enter 'cancel' to cancel flight\n")
query = "select count(tno) from bookings where tno = '{}'".format(str(already_seen[entry][0]))
cursor.execute(query)
ticket_count = database.read(query, cursor)
if int(ticket_count[0])>1: # non-direct flight choose from good_connections
query = "select t.tno, to_char(b.dep_date, 'dd-mon-yy') as dep_date, t.paid_price, b.flightno, t.name \
from bookings b, tickets t where b.tno = t.tno and t.tno='{}' and t.email = '{}'".format(str(already_seen[entry][0]),user)
cursor.execute(query)
rows = cursor.fetchall()
query = "select * from good_connections where flightno1 = '{}' or flightno1 = '{}' or flightno2 = '{}'\
or flightno2 = '{}' and price = '{}' \
and dep_date = to_date('{}', 'dd-mon-yy')".format(str(rows[0][3]),str(rows[1][3]),str(rows[1][3]),\
str(rows[0][3]), str(rows[0][2]),str(rows[0][1]))
cursor.execute(query)
result = cursor.fetchall()
#tno is str(already_seen[entry][0])
for x in result:
if x[6] == str(rows[0][1]):
break
print("Tno: " + str(already_seen[entry][0]))
print("Passenger Name: " + str(rows[0][4]))
print("Departure Date: " + str(rows[0][1]))
print("Price: " + str(result[0][6]))
print("Flight No1: " + str(x[3]))
print("Flight No2: " + str(x[4]))
print("Flight Source: " +str(x[0]))
print("Flight Destination: " + str(x[1]))
print("Fare Type1: " + str(x[8]))
print("Fare Type2: " + str(x[9]))
query = "select f.descr, ff.bag_allow from flight_fares ff, fares f where ff.flightno = '{}'\
and ff.fare = '{}' and ff.fare = f.fare".format(str(x[3]), str(x[8]))
cursor.execute(query)
additional_rows = cursor.fetchall()
for add_row in additional_rows:
print("Fare Type1 Description: " + str(add_row[0]))
print("Bags Type1 Allowed: " + str(add_row[1]))
query = "select f.descr, ff.bag_allow from flight_fares ff, fares f where ff.flightno = '{}'\
and ff.fare = '{}' and ff.fare = f.fare".format(str(x[4]), str(x[9]))
cursor.execute(query)
additional_rows = cursor.fetchall()
for add_row in additional_rows:
print("Fare Type2 Description: " + str(add_row[0]))
print("Bags Type2 Allowed: " + str(add_row[1]))
while True:
nope = input("\n")
if nope == "" :
break
elif nope == "cancel":
menu.clearScreen()
print("Canceling booking...")
query = "DELETE FROM bookings WHERE tno = '{}' and \
dep_date = to_date('{}', 'dd-mon-yy')".format(str(already_seen[entry][0]), str(rows[0][1]))
cursor.execute(query)
query = "SELECT email FROM tickets"
users = database.read(query, cursor)
if user.ljust(20) not in users:
query = "DELETE FROM passengers WHERE email = '{}' and name = '{}'".format(user,
str(rows[0][4]))
cursor.execute(query)
connection.commit()
break
else: # direct flight
query = "select f.src, f.dst, b.seat, b.fare from bookings b, flights f, tickets t where b.tno = t.tno\
and b.flightno = f.flightno and b.tno = '{}' and b.flightno = '{}'\
and b.dep_date = to_date('{}', 'dd-mon-yy')".format(str(rows[entry][0]), str(rows[entry][4]),
str(rows[entry][2]))
cursor.execute(query)
detailed_rows = cursor.fetchall()
for row in detailed_rows:
print("Tno: " + str(rows[entry][0]))
print("Passenger Name: " + str(rows[entry][1]))
print("Departure Date: " + str(rows[entry][2]))
print("Price: " + str(rows[entry][3]))
print("Flight No: " + str(rows[entry][4]))
print("Flight Source: " + str(row[0]))
print("Flight Destination: " + str(row[1]))
print("Seat No: " + str(row[2]))
print("Fare Type: " + str(row[3]))
query = "select f.descr, ff.bag_allow from flight_fares ff, fares f where ff.flightno = '{}'\
and ff.fare = '{}' and ff.fare = f.fare".format(str(rows[entry][4]), str(row[3]))
cursor.execute(query)
additional_rows = cursor.fetchall()
for add_row in additional_rows:
print("Fare Description: " + str(add_row[0]))
print("Bags Allowed: " + str(add_row[1]))
while True:
nope = input("\n")
if nope == "" :
break
elif nope == "cancel":
menu.clearScreen()
print("Canceling booking...")
query = "DELETE FROM bookings WHERE tno = '{}' and \
dep_date = to_date('{}', 'dd-mon-yy')".format(str(rows[entry][0]), str(rows[entry][2]))
cursor.execute(query)
query = "SELECT email FROM tickets"
users = database.read(query, cursor)
if user.ljust(20) not in users:
query = "DELETE FROM passengers WHERE email = '{}' and name = '{}'".format(user,
str(rows[entry][1]))
cursor.execute(query)
connection.commit()
break
else:
print("Invalid entry, Try Again")
def round_trip(user, row, return_date, connection):
cursor = database.cursor(connection)
search.create_views(cursor)
connection.commit()
try:
query = "SELECT name FROM passengers where email='{}'".format(user)
names = database.read(query, cursor)
name=""
while not(verify.char20(name)):
name = input("Please enter a name: ").strip()
if not(verify.char20(name)):
print("Invalid Name Length, Try Again")
if name.strip().ljust(20) not in names:
print("Creating passenger...\n")
country=""
while not(verify.char10(country)):
country = input("Please enter a country: ").strip()
if not(verify.char10(country)):
print("Invalid Country Name Length, Try Again")
query = "INSERT INTO passengers (email, name, country) VALUES ('{}','{}','{}')".format(user, str(name), str(country))
cursor.execute(query)
connection.commit()
tno = genTicket(cursor)
if row[7] != "Direct": # not a direct booking multiple tickets needed
# flight no 1 row[0], fare type f1 row[10]
# flight no 2 row[1], fare type f2 row[11]
# dep_date row[12]
#UPDATE THE VIEWS
search.create_views(cursor)
query = "select seats from good_connections WHERE flightno1 = '{}' AND flightno2 = '{}' and a1_fare = '{}'\
and a2_fare = '{}' ".format(str(row[0]),str(row[1]),str(row[10]),str(row[11]))
seat = database.read(query, cursor)
if int(seat[0])>0:
print("Creating booking...\n")
#generate our ticket
#price row[8]
query = "insert into tickets (tno, name, email, paid_price)\
VALUES ('{}','{}','{}','{}')".format(tno, name, user, str(row[8]))
cursor.execute(query)
# now we can make our bookings
query = "insert into bookings (tno, flightno, fare, dep_date, seat)\
VALUES ('{}','{}','{}','{}','{}')".format(tno, str(row[0]), str(row[10]), str(row[12]), "TBD1")
cursor.execute(query) #first part of flight
query = "insert into bookings (tno, flightno, fare, dep_date, seat)\
VALUES ('{}','{}','{}','{}','{}')".format(tno, str(row[1]), str(row[11]), str(row[12]), "TBD2")
cursor.execute(query) #second part of flight
connection.commit()
print("Booking created successfully")
print("Tno:{} under {}".format(tno,name))
return True
else:
print("Booking failed, try again")
return False
else: # direct booking, same procedure one less time
search.create_views(cursor)
query = "select seats from available_flights WHERE flightno = '{}' AND fare = '{}'".format(str(row[0]),str(row[10]))
seat = database.read(query, cursor)
if int(seat[0])>0:
print("Creating booking...\n")
#generate our ticket
#price row[8]
query = "insert into tickets (tno, name, email, paid_price)\
VALUES ('{}','{}','{}','{}')".format(tno, name, user, str(row[8]))
cursor.execute(query)
query = "insert into bookings (tno, flightno, fare, dep_date, seat)\
VALUES ('{}','{}','{}','{}','{}')".format(tno, str(row[0]), str(row[10]), str(row[12]), "TBD")
cursor.execute(query)
connection.commit()
print("Booking created successfully")
print("Tno:{} under {}".format(tno,name))
print("\nGoing to select your return trip...")
sort = ""
while sort!="0" and sort!="1":
sort = input("Enter 0 to sort by price or 1 to sort by number of connections for return trip: ")
source = row[3]
destination = row[2]
departure_date = return_date
search_query_gc = "select * from good_connections gc where gc.src='{}' and gc.dst='{}' and \
gc.dep_date = to_date('{}', 'dd-mm-yy')\
order by price asc, layover asc".format(source, destination, departure_date)
search_query_af = "select * from available_flights af where af.src='{}' and af.dst='{}' and \
af.dep_date = to_date('{}', 'dd-mm-yy') order by price asc".format(source, destination,
departure_date)
cursor.execute(search_query_gc)
search_query_gc_rows = cursor.fetchall()
cursor.execute(search_query_af)
search_query_af_rows = cursor.fetchall()
count = 1
menu.clearScreen()
print("Return Trips Found\n\n" + \
"Select Row Number to book or press enter to cancel\n\n")
print(str("Row").ljust(6) + str("Fl no1").ljust(9) + str("Fl no2").ljust(9) + str("Src").ljust(5) + str("Dst").ljust(5) + str("Dep Time").ljust(10)\
+ str("Arr Time").ljust(10) + str("Stops").ljust(7) + str("Layover(hrs)").ljust(14) + str("Total Price").ljust(14)\
+ str("Seats").ljust(7))
x = "-" * 98
print(x)
all_roxs = []
for rox in search_query_af_rows:
all_roxs.append([rox[0],"N/A",rox[2],rox[3],rox[4].strftime('%H:%M'),rox[5].strftime('%H:%M'),"0","Direct",int(rox[8])+row[8],rox[7],rox[6],"N/A", departure_date])
for rox in search_query_gc_rows:
all_roxs.append([rox[3],rox[4],rox[0],rox[1],rox[10].strftime('%H:%M'),rox[11].strftime('%H:%M'),"1","{0:.2f}".format(rox[5]),rox[6]+row[8],rox[7],rox[8], rox[9], departure_date])
if len(search_query_af_rows) == 0 and len(search_query_gc_rows) == 0:
print("No flights found")
elif sort == "0":
all_roxs.sort(key=lambda x:x[8])
for rox in all_roxs:
print(str(count).ljust(6) + str(rox[0]).ljust(9) + str(rox[1]).ljust(9) + str(rox[2]).ljust(5) + str(rox[3]).ljust(5) + str(rox[4]).ljust(10)\
+ str(rox[5]).ljust(10) + str(rox[6]).ljust(7) + str(rox[7]).ljust(14) + str(rox[8]).ljust(14)\
+ str(rox[9]).ljust(7))
count += 1
elif sort == "1":
all_roxs.sort(key=lambda x:x[6])
for rox in all_roxs:
print(str(count).ljust(6) + str(rox[0]).ljust(9) + str(rox[1]).ljust(9) + str(rox[2]).ljust(5) + str(rox[3]).ljust(5) + str(rox[4]).ljust(10)\
+ str(rox[5]).ljust(10) + str(rox[6]).ljust(7) + str(rox[7]).ljust(14) + str(rox[8]).ljust(14)\
+ str(rox[9]).ljust(7))
count += 1
while True:
entry = input("\n")
if entry == "":
break
elif verify.rowSelection(entry, len(all_roxs)):
entry = int(entry)-1 # actual position in list of roxs
make(user,all_roxs[entry], connection)
else:
print("Booking failed, try again")
return False
except:
error, = cx_Oracle.DatabaseError.args
print(sys.stderr, "Oracle code:", error.code)
print(sys.stderr, "Oracle message:", error.message)
print("Booking failed, try again")
return False
def record_arr(connection):
while True:
cursor = database.cursor(connection)
menu.clearScreen()
print("Record Arrival Time\n\n" + \
"Select Row Number to Change Arrival Time For Scheduled flight or press enter to go back\n\n")
query = "select s.flightno, to_char(s.dep_date, 'dd-mon-yy') as dep_date \
from sch_flights s"
cursor.execute(query)
rows = cursor.fetchall()
count = 1
print(str("Row").ljust(6)+str("Fl No").ljust(8)+str("Dep Date").ljust(12))
x = "-" * 26
print(x)
if len(rows)!= 0:
for row in rows:
print(str(count).ljust(6) + str(row[0]).ljust(8) + str(row[1]).ljust(12))
count += 1
else:
print("No Scheduled Flights Currently Exist")
entry = input("\n")
if entry == "":
break
elif not(verify.rowSelection(entry, len(rows))):
print("Invalid entry, Try Again")
elif verify.rowSelection(entry, len(rows)):
entry = int(entry)-1
menu.clearScreen()
print("Change Arrival Time\n\n" + \
"Press enter to go back or enter 'hh24:mi' to change arrival time\n")
print("Flight No: " + str(rows[entry][0]))
print("Dep Date: " + str(rows[entry][1]))
while True:
nope = input("\nNew arrival time (hh24:mi): ")
if nope == "":
break
elif not(isTimeFormat(nope)):
print("Invalid time format, Try Again")
elif isTimeFormat(nope):
menu.clearScreen()
print("Changing Arrival Time...")
query = "UPDATE sch_flights SET act_arr_time = to_date('{}', 'hh24:mi')\
WHERE flightno = '{}' AND dep_date = '{}'".format(str(nope), str(rows[entry][0]),
str(rows[entry][1]))
cursor.execute(query)
connection.commit()
break
