import csv
import db
from postgis import Point

connection, cursor = db.open_connections()

with open('convertcsv.csv') as csv_file:
    # db.delete_all_records_from_stop_lookup(cursor)
    csv_reader = csv.reader(csv_file, delimiter=',')
    for row in csv_reader:
        db.insert_stop_to_lookup_tables(cursor, row[2], row[5], "bike", Point(row[3], row[4]))
    db.commit_changes(connection)

print(db.fetch_stop_lookup_records(cursor))
print(db.fetch_stop_lookup_records(cursor)[0][3][1])
db.end_connection(connection, cursor)