Example #1
0
parse = Parse()
parse1 = Parse()

while (1):
    print(
        '\n1. Create table\n2. Insert data\n3. Display\n4. Drop Table\n5. Parse\n6. Store the data\n7. Plot Graph\n8. Exit\n'
    )
    ch = int(input("Enter ur choice: "))
    if (ch == 1):
        database.create_table(conn)
    elif (ch == 2):
        database.insert_into_table(conn)
    elif (ch == 3):
        database.display_data(conn)
    elif (ch == 4):
        database.drop_table(conn)
    elif (ch == 5):
        count = 0
        flag = False
        cursor = database.pointer_to_rows(conn)
        for rows in cursor:
            count += 1
            print('\nData ', count)
            print('\nAltitude: ', parse.get_altitude(rows[1]))
            print('\nGPS_Latitude: ', parse.get_gps_latitude(rows[1]))
            print('\nGPS_Longitude: ', parse.get_gps_longitude(rows[1]))
            print('\nGPS_Altitude: ', parse.get_gps_altitude(rows[1]))
    elif (ch == 6):
        print(
            "\n1. Store the altitude plots\n2. Store the GPS Latitude plots\n3. Store the GPS Longitude plots\n4. Store the GPS Altitude plots\n"
        )