def getAircraftCodeDict():
"""
A function to read in a database and create a dictionary with the
key coming from the first column. The dictionary value an Aircraft() object.
The dictionary is returned.
Each row of the database table contains 1 integer and 1 string in double quotes.
"""
table = 'aircraft'
connection = openConnection()
curs = connection.cursor()
sqlcmd = "SELECT * FROM " + table
d = {}
curs.execute(sqlcmd)
for row in curs.fetchall():
aircraft = airlineClasses.Aircraft()
aircraft.aircraftCode = row[0]
aircraft.name = row[1]
d[aircraft.aircraftCode] = aircraft
curs.close()
connection.close()
return d
def getAircraftCodeDict():
filename = 'C:/Course/1905/Data/aircraft.csv'
dictionary = {}
for input in open(filename,'r'):
if input:
input = input.rstrip() # remove the newline
input = input.replace('"','') # replace double quotes with null
input = input.split(',') # split at the comma
aircraft = airlineClasses.Aircraft(aircraftCode = int(input[0]), name= input[1]) # create new object
dictionary[aircraft.aircraftCode] = aircraft # store in dictionary
return dictionary
def getAircraftCodeDict():
dictionary = {}
for input in open(filename2, 'r'):
if input:
input = input.rstrip() # remove the newline
input = input.replace('"', '') # replace double quotes with null
input = input.split(',') # split at the comma
aircraft = airlineClasses.Aircraft() # create new object
aircraft.aircraftCode = int(input[0]) # assign into new object
aircraft.name = input[1]
dictionary[aircraft.aircraftCode] = aircraft # store in dictionary
return dictionary