import json, logging

# using SQLAlchmey, creating a new DB is as easy

# as creating a new object in Python.

# import the following dependencies from SQLAlchmey

# and the empty database we created into our environment

from sqlalchemy.orm import sessionmaker

from models import Base, Book, Author, Publisher, engine

# bind the engine to the base class. This makes the connection

# between our class definitions and the corresponding tables

# within our database

Base.metadata.bind = engine

# create session maker object to establish a link

# of communication between our code execution and

# the engine we just created

DBSession = sessionmaker(bind=engine)

# in order to create, read, update or delete information

# on our database, SQLAlchmey executes database operations

# via an interface called a session.

# A session allows us to write down all the commands

# we want to execute but not send them to the DB

# until we call "commit"

# create an instance of DBSession

session = DBSession()

def addBook(newBook):

return True

def addAuthor(authorName, authorBirthDate, authorEducation, authorNationality, authorAlmaMater, authorWiki, authorImage, authorDesc, newBook ):

return auth

def addPublisher(publisherName, publisherParCom, publisherOwner, publisherLoc, publisherYear, publisherImage, publisherWebpage, publisherWiki, publisherDesc,newBook):

return pub

def load_json(filename):

return jsn

def create_books():

session.commit()

create_books()