# 6. Creates global class names based on their respective counterparts which have been autoreflected and turned into models taht live in **Base.classes**
# 7. Sets the database to autocommit, and autoflush.Since we are using the <code>"sesion.merge"</code> method, this is a convenience for now. Eventually we'll make it a bit more secure.
# <codecell>
engine = create_engine('postgresql+pg8000://vassr:bluedog@localhost:5432/vassr')
meta = MetaData(schema="public")
session = Session(engine)
working_tables = ['person', 'location', 'condition_occurrence', 'care_site', 'observation', 'drug_exposure']
meta.reflect(engine, only=None)
Base = automap_base(metadata=meta)
Base.prepare()
Person, Condition, CareSite, Observation, DrugExposure, Location = Base.classes.person, Base.classes.condition_occurrence, Base.classes.care_site, Base.classes.observation, Base.classes.drug_exposure, Base.classes.location
session.autocommit = True
session.autoflush = True
ins = sa.inspect(engine)
person = Person()
condition = Condition()
caresite = CareSite()
obs = Observation()
drugexp = DrugExposure()
location = Location()
'''
# Old Code:
