# CSC120 Lab 9
from lab9_functions import *

FLIGHT_DB = 'flight_data.db'

def print_records(data: List[tuple]) -> None:
    """Print the records (rows) in data, one record per line."""
    for record in data:
        print(record)
        

if __name__ == '__main__':
    print('Lab 9 Output starts here\n-----------------------')
    
    #####  SECTION 2 #####
    
    ## Query 1 - Get all flights: Print the result from query 1
    print('Query 1 result:')
    #print_records(get_all_flights(FLIGHT_DB))
    
    ## Query 2 - Get airline code and airline number
    print('Query 2 result:')
    #print_records(get_airline_info(FLIGHT_DB))
    
    ## Query 3 - Get airline code and airline number
    print('Query 3 result:')
    #print_records(get_origin_destination(FLIGHT_DB))
    
    ## Query 4 - Get airline code and airline number
    print('Query 4 result:')
    #print_records(get_destination_origin(FLIGHT_DB))
    
    ## Query 5 - Get airline code and airline number
    print('Query 5 result:')
    #print_records(get_minutes(FLIGHT_DB))    
    
    
    ## Query 6 - Get airline code and airline number
    print('Query 6 result:')
    #print_records(get_min_less_230(FLIGHT_DB))   
    
    ## Query 7 - Get airline code and airline number
    print('Query 7 result:')
    #print_records(get_min_greater_185(FLIGHT_DB))   
    
    ## Query 8 - Get airline code and airline number
    print('Query 8 result:')
    #print_records(get_airline_dl(FLIGHT_DB))   
    
    ## Query 9 - Get airline code and airline number
    print('Query 9 result:')
    #print_records(get_number_greater_210(FLIGHT_DB))   
    
    ## Query 10 - Get airline code and airline number
    print('Query 10 result:')
    #print_records(get_origin_minutes_range(FLIGHT_DB))       
    
    #####  SECTION 3  #####
    
    ## Create airlines table
    make_airlines_table = True
    if make_airlines_table:
        #create_airlines_table(FLIGHT_DB, open('airlines.csv'))
        pass
    
    
    #####  SECTION 4  #####
    
    ## Query 11- Get airline code and airline number
    print('Query 11 result:')
    #print_records(airline_names(FLIGHT_DB))   
    
    ## Query 12 - Get airline code and airline number
    print('Query 12 result:')
    #print_records(airline_names_origin_dest(FLIGHT_DB))   
    
    ## Query 13 - Get airline code and airline number
    print('Query 13 result:')
    #print_records(airline_names_minutes(FLIGHT_DB))