import csv
import os

from sqlalchemy import create_engine
from sqlalchemy.orm import scoped_session, sessionmaker

# Set up database
engine = create_engine(os.getenv("DATABASEURL"))
db = scoped_session(sessionmaker(bind=engine))

def main():

  file = open("books.csv")
  reader = csv.reader(file)
  for isbn,title, author, year in reader:
    db.execute("INSERT INTO books (isbn, title,author, year) VALUES (:isbn, :title, :author, :year)",
              {"isbn": isbn, "title": title, "author": author, "year": year})
  db.commit()
