#! /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)
 

IyEgL3Vzci9iaW4vZW52IHB5dGhvbjMuNgppbXBvcnQgY3N2LCBvcwpmcm9tIHNxbGFsY2hlbXkgaW1wb3J0IGNyZWF0ZV9lbmdpbmUKZnJvbSBzcWxhbGNoZW15Lm9ybSBpbXBvcnQgc2NvcGVkX3Nlc3Npb24sIHNlc3Npb25tYWtlcgoKZmlsZW5hbWUgPSAnYm9va3MuY3N2JwoKaWYgbm90IG9zLmdldGVudigiREFUQUJBU0VfVVJMIik6CiAgICByYWlzZSBSdW50aW1lRXJyb3IoIkRBVEFCQVNFX1VSTCBpcyBub3Qgc2V0IikKZWxzZToKICAgIHByaW50KCJta2F5IikKZW5naW5lID0gY3JlYXRlX2VuZ2luZShvcy5nZXRlbnYoIkRBVEFCQVNFX1VSTCIpKQpkYiA9IHNjb3BlZF9zZXNzaW9uKHNlc3Npb25tYWtlcihiaW5kPWVuZ2luZSkpCgp3aXRoIG9wZW4oZmlsZW5hbWUsIG5ld2xpbmU9JycpIGFzIGNzdmZpbGU6CiAgICBsaW5lcyA9IGNzdi5EaWN0UmVhZGVyKGNzdmZpbGUpCiAgICBmb3IgbGluZSBpbiBsaW5lczoKICAgICAgICBsaW5lWyd5ZWFyJ10gPSBpbnQobGluZVsneWVhciddKQogICAgICAgIGRiLmV4ZWN1dGUoIklOU0VSVCBJTlRPIGJvb2tzIChpc2JuLCB0aXRsZSwgYXV0aG9yLCB5ZWFyKSBWQUxVRVMgKDppc2JuLCA6dGl0bGUsIDphdXRob3IsIDp5ZWFyKSIsCiAgICAgICAgICAgIGxpbmUpCg==