def rollback_session_changes():
Session = sessionmaker(bind=engine)
session = Session()
west_dakota = State(name="West Dakota", capital_city="Fake City", population=123456, landlocked=True)
session.add(west_dakota)
session.rollback()
session.commit()
def create_new_york():
Session = sessionmaker(bind=engine)
session = Session()
ny = State(name='New York',
capital_city='Albany',
population=20000000,
landlocked=False)
session.add(ny)
session.commit()
def create_connecticut():
Session = sessionmaker(bind=engine)
session = Session()
ct = State(name="Connecticut",
capital_city="Hartford",
population=3600000,
landlocked=False)
session.add(ct)
session.commit()
def create_cali():
Session = sessionmaker(bind=engine)
session = Session()
cali = State(name="California",
capital_city="Sacramento",
population=40000000,
landlocked=False)
session.add(cali)
session.commit()
def create_wyoming():
Session = sessionmaker(bind=engine)
session = Session()
wy = State(name='Wyoming',
capital_city='Cheyenne',
population=579315,
landlocked=True)
session.add(wy)
session.commit()
def create_new_york():
Session = sessionmaker(bind=engine)
session = Session()
NY = State(name="New York", capital_city="Albany", population=20000000, landlocked=False)
session.add(NY)
session.commit()
def create_wyoming():
Session = sessionmaker(bind=engine)
session = Session()
WY = State(name="Wyoming", capital_city="Cheyenne", population=579315, landlocked=True)
session.add(WY)
session.commit()