from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from database_setup import Base, Restaurant, MenuItem #importing from our database_setup.py file
engine = create_engine(
'sqlite:///restaurantmenu.db'
) #lets program know which database engine we want to communicate with
Base.metadata.bind = engine #creates the connection between the db tables and our classes
DBSession = sessionmaker(
bind=engine
) #establishes a link of communcation between our code executions and the engine we created
#sessions allow us to write the commands we want to execute but not send them to the database until we call a commit
session = DBSession()
myFirstRestaurant = Restaurant(
name="Pizza Palace") #create a new restaurant object
session.add(myFirstRestaurant
) #adds this new restaurant to the staging zone to be added to db
session.commit() #adds this restaurant to db
session.query(Restaurant).all() #get all the restaurants in the db
cheesepizza = MenuItem(
name="Cheese Pizza",
description="Made with all natural ingredients and fresh mozzarella",
course="Entree",
price="$8.99",
restaurant=myFirstRestaurant)
session.add(cheesepizza)
session.commit()
session.query(MenuItem.all()) #get all the menuitems in the db
