#! /usr/bin/env python3.6
import csv, os
from sqlalchemy import create_engine
from sqlalchemy.orm import scoped_session, sessionmaker

filename = 'books.csv'

if not os.getenv("DATABASE_URL"):
    raise RuntimeError("DATABASE_URL is not set")
else:
    print("mkay")
engine = create_engine(os.getenv("DATABASE_URL"))
db = scoped_session(sessionmaker(bind=engine))

with open(filename, newline='') as csvfile:
    lines = csv.DictReader(csvfile)
    for line in lines:
        line['year'] = int(line['year'])
        db.execute("INSERT INTO books (isbn, title, author, year) VALUES (:isbn, :title, :author, :year)",
            line)