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

engine = create_engine(os.getenv("DATABASE_URL"))
db = scoped_session(sessionmaker(bind=engine))

file = open("books.csv")
reader = csv.reader(file)

for isbn, title, author, year in reader:
  print(isbn, title, author, year)
  db.execute('INSERT INTO books ("isbn", "title", "author", "year") VALUES (:isbn, :title, :author, :year)', {"isbn": isbn, "title": title, "author": author, "year": year})
  db.commit()
  