from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker

from database_setup import User, Item, Base

engine = create_engine('sqlite:///databasename.db')
# Bind the engine to the metadata of the Base class so that the declaratives
#   can be accessed through a DBSession instance
Base.metadata.bind = engine

DBSession = sessionmaker(bind=engine)
# A DBSession() instance establishes all the conversations with the database
#   and represents a "staging zone" for allthe objects loaded into the database
#   session object/ Any change made against the objects in the session won't
#   be persisted into the database until you call session.commit(). If you're
#   not happy about the changes, you can revert all of them back to the last
#   commit by calling session.rollback()
session = DBSession()

# name = table-item-name(column = data,...)
# session.add(name)
# session.commit()
