import csv
import sys
import os
from sqlalchemy import Column, ForeignKey, Integer, String
from sqlalchemy import create_engine
from flask import Flask, render_template, request, session
from flask_sqlalchemy import SQLAlchemy
from flask_session import Session

engine = create_engine(os.getenv("DATABASE_URL")) # database engine object from SQLAlchemy that manages connections to the database,# DATABASE_URL is an environment variable that indicates where the database lives

def main():
    f = open("movies.csv","r")
    reader = csv.reader(f)
    for row in f: # loop gives each column a name
        title,year,runtime,imdbID,imdbRating = row.split(';')
        engine.execute('INSERT INTO movies(title, year, runtime, imdbID, imdbRating) VALUES ((title), (year), (runtime), (imdbID), (imdbRating))',
                      {'title': title, 'year': year, 'runtime': runtime, 'imdbID': imdbID, 'imdbRating': imdbRating}) # substitute values from CSV line into SQL command, as per this dict

    engine.commit() # transactions are assumed, so close the transaction finished
if __name__ == "__main__":
    main()