email="*****@*****.**",
picture="http://www.sfstation.com/wp-content/uploads/ \
2013/11/roy-choi-riding-shotgun-la-son.jpg")
session.add(user3)
session.commit()
# El Jefe
food_truck1 = FoodTruck(name="El Jefe", user_id=3)
session.add(food_truck1)
session.commit()
menuItem1 = MenuItem(
name="Mojo Pork Cubanos",
description="delectable Cuban-inspired variation on the/ \
classic ham and cheese sandwich",
price="$10", course="Entree",
food_truck=food_truck1, user_id=3)
session.add(menuItem1)
session.commit()
menuItem2 = MenuItem(
name="Mojo Marinated Pork Shoulder",
description="immersed in a marinade of garlic, \
citrus and herbs", price="$10",
course="Entree", food_truck=food_truck1, user_id=3)
session.add(menuItem2)
session.commit()
menuItem3 = MenuItem(
name="Tostones with Chile Vinegar",
from sqlalchemy.orm import sessionmaker
from database_setup import Base, Restaurant, MenuItem
engine = create_engine('sqlite:///restaurantmenu.db')
Base.metadata.bind = engine
DBSession = sessionmaker(bind = engine)
session = DBSession()
#CRUD Create, creates a database entry restaurant with the given name. add/commit commits it to the database,
# query returns all entries in the Restaurant table
myFirstRestaurant = Restaurant(name = "Pizza Palace")
session.add(myFirstRestaurant)
session.commit()
session.query(Restaurant).all()
#create a menu item like so below
cheesepizza = MenuItem(name = "Cheese Pizza", description = "Made with fresh mozzarella", course = "Entree", price = "$8.99", restaurant = myFirstRestaurant)
#CRUD read, reads all menu items, creates a variable first result that's only the first result of the query, then prints the name of it
session.query(MenuItem).all()
firstResult = session.query(Restaurant).first()
firstResult.name
#CRUD Update, uses the id of 8 to assign variable to current entry, updates the price of it, commits,
#the price of it in the table is updated to $2.99
#first for loop updates all veggie burger prices to $2.99 if they aren't already.
#Second for loop prints out results from table
UrbanVeggieBurger = session.query(MenuItem).filter_by(id = 8).one()
print(UrbanVeggieBurger.price)
UrbanVeggieBurger.price = '$2.99'
session.add(UrbanVeggieBurger)
# and represents a "staging zone" for all the 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()
# Menu for UrbanBurger
restaurant1 = Restaurant(name="Urban Burger")
session.add(restaurant1)
session.commit()
menuItem2 = MenuItem(name="Veggie Burger", description="Juicy grilled veggie patty with tomato mayo and lettuce",
price="$7.50", course="Entree", restaurant=restaurant1)
session.add(menuItem2)
session.commit()
menuItem1 = MenuItem(name="French Fries", description="with garlic and parmesan",
price="$2.99", course="Appetizer", restaurant=restaurant1)
session.add(menuItem1)
session.commit()
menuItem2 = MenuItem(name="Chicken Burger", description="Juicy grilled chicken patty with tomato mayo and lettuce",
price="$5.50", course="Entree", restaurant=restaurant1)
session.add(menuItem2)
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from database_setup import Base, Restaurant, MenuItem
# Connect to SQLite database
engine = create_engine('sqlite:///restaurantmenu.db')
# Connect the inherited Base class to your engine
Base.metadata.bind = engine
# DB Session class which is used to create sessions
DBSession = sessionmaker(bind=engine)
# Example session
session = DBSession()
# Now let's add items to our tables (which were already created)
# Tables = Restaurant & MenuItem
newEntry = Restaurant(name="Alec's first Restaurant")
session.add(newEntry)
session.commit()
menuEntry = MenuItem(name="Cheeseburger",
course="main",
description="The most amazing meal on the planet",
price="$8.99",
restaurant=newEntry)
session.add(menuItem)
session.commit()
import sys
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from database_setup import Base, Restaurant, MenuItem
engine = create_engine('sqlite:///restaurantmenu.db')
# Bind sqlalchemy classes to database
Base.metadata.bind = engine
DBSession = sessionmaker(bind=engine)
session = DBSession()
# Create first restaurant
myFirstRestaurant = Restaurant(name="Pizza Palace")
session.add(myFirstRestaurant)
session.commit()
firstRestaurant = session.query(Restaurant).first()
print('First Restaurant: {}'.format(firstRestaurant.name))
# Create first menu item
soycheesepizza = MenuItem(
name="Soy Cheese Pie",
description="Made with all vegan ingredients and Daiya mozzarella",
course="Entree",
price="$8.99",
restaurant=myFirstRestaurant)
session.add(soycheesepizza)
session.commit()
# session.rollback()
session = DBSession()
# Create a dummy user
User1 = User(name="Sai Rapz", email="*****@*****.**",
picture='https://o.aolcdn.com/images/dims3/GLOB/legacy_thumbnail/1200x630/format/jpg/quality/85/http%3A%2F%2Fi.huffpost.com%2Fgen%2F5334782%2Fimages%2Fn-TWIN-BABY-628x314.jpg')
session.add(User1)
session.commit()
# Menu for UrbanBurger
restaurant1 = Restaurant(user_id=1, name="Urban Burger")
session.add(restaurant1)
session.commit()
menuItem1 = MenuItem(user_id=1,name="Veggie Burger", item_type="Veg",
price="$7.50", restaurant_id=1, restaurant=restaurant1)
session.add(menuItem1)
session.commit()
menuItem2 = MenuItem(user_id=1,name="French Fries", item_type="Veg",
price="$2.99", restaurant_id=1, restaurant=restaurant1)
session.add(menuItem2)
session.commit()
menuItem3 = MenuItem(user_id=1,name="Chicken Burger", item_type="Non-Veg",
price="$5.50", restaurant_id=1, restaurant=restaurant1)
session.add(menuItem3)
# beerstodelete = session.query(Beer);
# for beer in beerstodelete:
# session.delete(beer);
# menuitemstotodelete = session.query(MenuItem);
# for menuitem in menuitemstotodelete:
# session.delete(menuitem);
# Menu for Pale Ales
beer1 = Beer(name="Pale Ales")
session.add(beer1)
session.commit()
menuItem1 = MenuItem(
name="American Pale Ale",
description=
"An American interpretation of a classic English style. The American pale ale is characterized by floral, fruity, citrus-like, piney, resinous, or sulfur-like American-variety hop character, producing medium to medium-high hop bitterness, flavor and aroma. American-style pale ales have medium body and low to medium maltiness that may include low caramel malt character.",
beer=beer1)
session.add(menuItem1)
session.commit()
menuItem2 = MenuItem(
name="Blonde Ale",
description=
"One of the most approachable styles, a golden or blonde ale is an easy-drinking beer that is visually appealing and has no particularly dominating malt or hop characteristics. Rounded and smooth, it is an American classic known for its simplicity. Sometimes referred to as 'golden ale.' These beers can have honey, spices and fruit added, and may be fermented with lager or ale yeast.",
beer=beer1)
session.add(menuItem2)
session.commit()
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from database_setup import Base,Restaurant,MenuItem
engine=create_engine('sqlite:///restaurantmenu.db')
Base.metadata.bind=engine
DBsession=sessionmaker(bind=engine)
session=DBsession()
myFirstRestaurant=Restaurant(name='PizzaPalace')
session.add(myFirstRestaurant)
session.commit()
session.query(Restaurant).all()
cheesepizza=MenuItem(name='cheesepizza',description='made with all natural ingredients',course='Entree',price='$8.99',
restaurant=myFirstRestaurant)
session.add(cheesepizza)
session.commit()
session.query(MenuItem).all()
veggieBurgers=session.query(MenuItem).filter_by(name='Veggie Burger')
for veggieBurger in veggieBurgers:
print (veggieBurger.id)
print (veggieBurger.price)
print (veggieBurger.restaurant.name)
print ("\:n")
UrbanveggieBurger=session.query(MenuItem).filter_by(id=10).one()
print (UrbanveggieBurger.price)
UrbanveggieBurger.price='$2.99'
session.add(UrbanveggieBurger)
session.commit
veggieBurgers=session.query(MenuItem).filter_by(name='Veggie Burger')
for veggieBurger in veggieBurgers:
print(veggieBurger.id)
print(veggieBurger.price)
session = DBSession()
# Create dummy user
User1 = User(name="admin", email="*****@*****.**")
session.add(User1)
session.commit()
# Menu for Raju Ka Kitchen
restaurant1 = Restaurant(name="Raju Ka Kitchen", user_id="1")
session.add(restaurant1)
session.commit()
menuItem1 = MenuItem(name="Masala Dosa",
description="Crepe made from rice"
"batter and black lentils.",
price="$2.99",
restaurant=restaurant1,
user_id=1)
session.add(menuItem1)
session.commit()
menuItem2 = MenuItem(name="Sambar Idly",
description=" Rice cake with"
"lentil-based vegetable stew.",
price="$7.50",
restaurant=restaurant1,
user_id=1)
session.add(menuItem2)
session.commit()
dict(name="Iced Tea",
description="with Lemon",
price="$.99",
course="Beverage"),
dict(name="Grilled Cheese Sandwich",
description="On texas toast with American Cheese",
price="$3.49",
course="Entree"),
dict(name="Veggie Burger",
description="Made with freshest of ingredients and home grown spices",
price="$5.99",
course="Entree")
]
for item in restaurant1_menu:
session.add(MenuItem(**item, restaurant=restaurant1))
session.commit()
# Menu for Super Stir Fry ===========================================================
restaurant2 = Restaurant(name="Super Stir Fry")
session.add(restaurant2)
session.commit()
restaurant2_menu = [
dict(name="Chicken Stir Fry",
description="With your choice of noodles vegetables and sauces",
price="$7.99",
course="Entree"),
dict(
name="Peking Duck",
description=
picture=
'https://pbs.twimg.com/profile_images/2671170543/18debd694829ed78203a5a36dd364160_400x400.png'
)
session.add(User1)
session.commit()
# Menu for UrbanBurger
category1 = Categories(user_id=1, name='Snowboarding')
session.add(category1)
session.commit()
menuItem2 = MenuItem(
user_id=1,
name='Goggles',
description='Juicy grilled veggie patty with tomato mayo and lettuce',
categories=category1)
session.add(menuItem2)
session.commit()
menuItem1 = MenuItem(user_id=1,
name='Snowboard',
description='with garlic and parmesan',
categories=category1)
session.add(menuItem1)
session.commit()
# Menu for UrbanBurger
from database_setup import Restaurant, Base, MenuItem
engine = create_engine('sqlite:///restaurantmenu.db')
Base.metadata.bind = engine
DBSession = sessionmaker(bind=engine)
session = DBSession()
restaurant1 = Restaurant(name="Sharma's Restaurant")
session.add(restaurant1)
session.commit()
menuItem2 = MenuItem(name="Veg Burger",
description="Juicy grilled veggie patty with tomato mayo",
price="$1.00",
course="Entree",
restaurant=restaurant1)
session.add(menuItem2)
session.commit()
menuItem1 = MenuItem(name="French Fries",
description="with garlic and parmesan",
price="$2.00",
course="Appetizer",
restaurant=restaurant1)
session.add(menuItem1)
session.commit()
# 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()
#Menu for Pepperwood
restaurant1 = Restaurant(name="Pepperwood")
session.add(restaurant1)
session.commit()
menuItem2 = MenuItem(name="Iced Tea",
description="Cool n Refreshing",
price="$3.50",
course="Beverage",
restaurant=restaurant1)
session.add(menuItem2)
session.commit()
menuItem1 = MenuItem(name="French Fries",
description="Simple, salt n desi spice",
price="$5.99",
course="Appetizer",
restaurant=restaurant1)
session.add(menuItem1)
session.commit()
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from database_setup import Base, Restaurant, MenuItem
engine = create_engine('sqlite:///restaurantmenu.db')
Base.metadata.bind = engine # connection between classes and tables
Session = sessionmaker(bind=engine)
session = Session()
myFirstRestaurant = Restaurant(name='Pizza Palace')
session.add(myFirstRestaurant)
session.commit()
print(session.query(Restaurant).all())
cheezepizza = MenuItem(name='Cheeze Pizza')
session.add(cheezepizza)
session.commit()
print(session.query(MenuItem).all())
18debd694829ed78203a5a36dd364160_400x400.png'''
)
session.add(User1)
session.commit()
# Menu for UrbanBurger
restaurant1 = Restaurant(user_id=1, name='Urban Burger')
session.add(restaurant1)
session.commit()
menuItem2 = MenuItem(
user_id=1,
name='Veggie Burger',
description='Juicy grilled veggie patty with tomato mayo and lettuce',
price='$7.50',
course='Entree',
restaurant=restaurant1,
)
session.add(menuItem2)
session.commit()
menuItem1 = MenuItem(
user_id=1,
name='French Fries',
description='with garlic and parmesan',
price='$2.99',
course='Appetizer',
restaurant=restaurant1,
)
name="Karim Magdy",
email="*****@*****.**",
picture=
'https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcQ_zcvnKkf1GZB_Wz31-uAVhvucZL4M0uKxLTHlrbFpNPFgsgJ1eBIzVA'
)
session.add(User1)
session.commit()
#########################################################################################################################
# Menu for Soccer
Category1 = Category(user_id=1, name="Soccer")
session.add(Category1)
session.commit()
menuItem2 = MenuItem(user_id=1,
name="Two shinguards",
description="Two shinguards Description.",
category=Category1)
session.add(menuItem2)
session.commit()
menuItem1 = MenuItem(user_id=1,
name="Shingguards",
description="Shingguards Description.",
category=Category1)
session.add(menuItem1)
session.commit()
menuItem2 = MenuItem(user_id=1,
name="Jesey",
Base.metadata.bind = engine
# Create session to connect to the database.
# Interface sessin
DBSession = sessionmaker(bind=engine)
session = DBSession()
# example code for creating new dataset in the DB table
# newEntry = ClassName(property='value',... )
# session.add(newEntry)
# session.commit()
# now create a new database entry for the Restaurant
newRestaurant = Restaurant(name='Tabea Pizza Place')
session.add(newRestaurant)
# same entry created for the menuitem
newMenuItem = MenuItem(name='Chicken',
course='Entree',
description='400 g sirloinnsteak',
price='$ 8.99',
restaurant=newRestaurant)
session.add(newMenuItem)
session.commit()
# now read the information from the database
items = session.query(MenuItem).all()
print(items)
for item in items:
print(item.name)
def configure_menu_item(form, restaurant_id):
return MenuItem(name=form['name'],
description=form['description'],
price=form['price'],
course=form['course'],
restaurant_id=restaurant_id)
session.add(restaurant)
session.commit()
# Read and Print Restaurants
restaurants = session.query(Restaurant)
for restaurant in restaurants:
print(restaurant.name)
# Create MenuItems
for restaurant in restaurants:
for i in range(0, 15):
item = MenuItem(name=g.food.dish(),
description=g.text.text(5)[:250],
price=g.business.price(minimum=1.99, maximum=50.0),
course=courses[random.randint(0,
len(courses) - 1)],
restaurant_id=restaurant.id)
session.add(item)
session.commit()
# Read and Print MenuItems
items = session.query(MenuItem)
for item in items:
print(item.name, item.restaurant.id)
# close session and close connection
session.close()
engine.dispose()
session.add(User1)
session.commit()
# Menu for Andala's
restaurant1 = Restaurant(user_id=1,
name="Burger King",
picture="/static/burgerKing.jpg")
session.add(restaurant1)
session.commit()
menuItem1 = MenuItem(
user_id=1,
name="Lamb Curry",
description=
"Slow cook that thang in a pool of tomatoes, onions and alllll those tasty Indian spices. Mmmm.",
price="$9.95",
course="Entree",
picture="/static/lamb_curry.jpg",
restaurant=restaurant1)
session.add(menuItem1)
session.commit()
menuItem2 = MenuItem(
user_id=1,
name="Chicken Marsala",
description="Chicken cooked in Marsala wine sauce with mushrooms",
price="$7.95",
course="Entree",
picture="/static/chicken_marsala.jpg",
#!/usr/bin/env python
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from database_setup import Base, Restaurant, MenuItem
engine = create_engine('sqlite:///restaurantmenu.db')
Base.metadata.bind = engine
DBSession = sessionmaker(bind=engine)
session = DBSession()
myFristRestaurant = Restaurant(name="Pizza Palace")
cheesepizza = MenuItem(name="Chees Pizza",
description='''Made with all natural
ingredien ts and fresh mozzarella''',
course="Entree",
price="$8.99",
restaurant=myFristRestaurant)
session.add(myFristRestaurant)
session.add(cheesepizza)
session.commit()
session.query(Restaurant).all()
session.query(MenuItem).all()
engine = create_engine('sqlite:///restaurantmenu.db')
Base.metadata.bind = engine
DBSession = sessionmaker(bind=engine)
session = DBSession()
myFirstRestaurant = Restaurant(name="Pizza Palace")
session.add(myFirstRestaurant)
session.commit()
session.query(Restaurant).all()
cheesepizza = MenuItem(
name="Cheese Pizza",
description="Made will natural ingredients and fresh mozza",
course="Entree",
price="$8.99",
restaurant=myFirstRestaurant)
session.add(cheesepizza)
session.commit()
items = session.query(Restaurant).all()
for item in items:
print item.name
veggieBurgers = session.query(MenuItem).filter_by(name='Veggie Burger')
for veggieBurger in veggieBurgers:
print veggieBurger.id
print veggieBurger.price
print veggieBurger.restaurant.name
email="*****@*****.**",
picture=
'https://pbs.twimg.com/profile_images/2671170543/18debd694829ed78203a5a36dd364160_400x400.png'
)
session.add(User1)
session.commit()
# Menu for first year
category1 = Category(user_id=1, name="first year")
session.add(category1)
session.commit()
menuItem1 = MenuItem(user_id=1,
name="c++",
description="Beginner",
course="Programming",
category=category1)
session.add(menuItem1)
session.commit()
menuItem2 = MenuItem(user_id=1,
name="Photoshop",
description="Beginner",
course="Design",
category=category1)
session.add(menuItem2)
session.commit()
'https://pbs.twimg.com/profile_images/2671170543/18debd694829ed78203a5a36dd364160_400x400.png'
)
session.add(User1)
session.commit()
# Menu for white wine
wine1 = Wine(name="White Wine")
session.add(wine1)
session.commit()
menuItem2 = MenuItem(
user_id=1,
name="Sauvignon blanc",
description=
"sauvignon blanc normally shows a herbal character suggesting bell pepper or freshly mown "
"grass. The dominating flavors range from sour green fruits of apples, pears and gooseberries "
"through to tropical fruits of melon, mango and blackcurrant. ",
location="France",
taste="Sweet",
wine=wine1)
session.add(menuItem2)
session.commit()
menuItem1 = MenuItem(
user_id=1,
name="Moscato",
description="The moscato variety belongs to the muscat family of grapes - "
"and so do moscatel and muscat ottonel",
location="France",
taste="Sweet",
from database_setup import Restaurant, Base, MenuItem
engine = create_engine('sqlite:///restaurants.db')
Base.metadata.bind = engine
DBSession = sessionmaker(bind=engine)
session = DBSession()
# Menu for The Forest Hound
restaurant1 = Restaurant(name="The Forest Hound")
session.add(restaurant1)
session.commit()
menuItem1 = MenuItem(name="Beef Meat", description="Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua",
price="$5.25", categorie="Burgers", restaurant=restaurant1)
session.add(menuItem1)
session.commit()
menuItem2 = MenuItem(name="Grilled Sausage", description="Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua",
price="$6.99", categorie="Hot Dogs", restaurant=restaurant1)
session.add(menuItem2)
session.commit()
menuItem3 = MenuItem(name="Black Tea", description="Lorem ipsum dolor sit amet",
price="$12.25", categorie="Drinks", restaurant=restaurant1)
session.add(menuItem3)
DBSession = sessionmaker(bind = engine)
session = DBSession()
myFirstRestaurant = Restaurant(name = "Pizza Palace")
session.add(myFirstRestaurant)
myFirstRestaurant = Restaurant(name = "2nd")
session.add(myFirstRestaurant)
myFirstRestaurant = Restaurant(name = "3rd")
session.add(myFirstRestaurant)
myFirstRestaurant = Restaurant(name = "4th")
session.add(myFirstRestaurant)
myFirstRestaurant = Restaurant(name = "5th")
session.add(myFirstRestaurant)
myFirstRestaurant = Restaurant(name = "6th")
session.add(myFirstRestaurant)
session.commit()
cheesepizza = MenuItem(name="Veggie Burger", description = "Made with all natural ingredients and fresh mozzarella", course="Entree", price="$8.99", restaurant=myFirstRestaurant)
session.add(cheesepizza)
session.commit()
firstResult = session.query(Restaurant).first()
items = session.query(MenuItem).all()
for item in items:
print item.name
restaurants = session.query(Restaurant).all()
for restaurant in restaurants:
print restaurant.name
veggieBurgers = session.query(MenuItem).filter_by(name= 'Veggie Burger')
for veggieBurger in veggieBurgers:
print veggieBurger.id
print veggieBurger.price
print veggieBurger.restaurant.name
print "\n"
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from database_setup import Base, Restaurant, MenuItem
engine = create_engine('sqlite:///restaurantmenu.db')
Base.metadata.bind = engine
DBSession = sessionmaker(bind=engine)
session = DBSession()
elemental_pizza = Restaurant(name="ElementalPizza")
session.add(elemental_pizza)
session.commit()
margherita_pizza = MenuItem(name="Margherita Pizza"
, description="Basic and Delicious!"
, course="Entree"
, price="$15.00"
, restaurant=elemental_pizza
, restaurant_id=1)
session.add(margherita_pizza)
session.commit()
session.add(category1)
session.commit()
category2 = Category(user_id=1, name="Action")
session.add(category2)
session.commit()
category3 = Category(user_id=1, name="Romance")
session.add(category3)
session.commit()
menuItem2 = MenuItem(
user_id=1,
name="Avengers",
description=
"Earth's mightiest heroes must come together and learn to fight as a team if they are going to stop the mischievous Loki and his alien army from enslaving humanity.",
category=category1)
session.add(menuItem2)
session.commit()
menuItem3 = MenuItem(
user_id=1,
name="Die Hard",
description=
"An NYPD officer tries to save his wife and several others taken hostage by German terrorists during a Christmas party at the Nakatomi Plaza in Los Angeles.",
category=category2)
session.add(menuItem3)
session.commit()
def do_POST(self):
try:
# CREATE - COMPLETE
if self.path.endswith("/restaurants/new"):
ctype, pdict = cgi.parse_header(
self.headers.getheader('content-type'))
if ctype == 'multipart/form-data':
fields = cgi.parse_multipart(self.rfile, pdict)
newRestoName = fields.get('message')
newResto = Restaurant(name = newRestoName[0])
session.add(newResto)
session.commit()
self.send_response(301)
self.send_header('Content-type', 'text/html')
self.send_header('Location', '/restaurants')
self.end_headers()
if self.path.endswith("/add"):
ctype, pdict = cgi.parse_header(
self.headers.getheader('content-type'))
if ctype == 'multipart/form-data':
fields = cgi.parse_multipart(self.rfile, pdict)
resto_id = self.path.split('/')[1]
newMenuItemName = fields.get('message')
newMenuItem = MenuItem(name = newMenuItemName[0])
newMenuItem.restaurant_id = resto_id
newMenuItem.price = '$4.99'
session.add(newMenuItem)
session.commit()
self.send_response(301)
self.send_header('Content-type', 'text/html')
self.send_header('Location', '/restaurants')
self.end_headers()
# UPDATE - COMPLETE
if self.path.endswith("/edit"):
ctype, pdict = cgi.parse_header(
self.headers.getheader('content-type'))
if ctype == 'multipart/form-data':
fields = cgi.parse_multipart(self.rfile, pdict)
newRestoName = fields.get('message')
resto_id = self.path.split('/')[1]
print resto_id
restaurant = session.query(Restaurant).filter_by(id = resto_id).one()
restaurant.name = newRestoName[0]
session.add(restaurant)
session.commit()
self.send_response(301)
self.send_header('Content-type', 'text/html')
self.send_header('Location', '/restaurants')
self.end_headers()
# DELETE - COMPLETE
if self.path.endswith("/delete"):
ctype, pdict = cgi.parse_header(
self.headers.getheader('content-type'))
if ctype == 'multipart/form-data':
resto_id = self.path.split('/')[1]
print resto_id
restaurant = session.query(Restaurant).filter_by(id = resto_id).one()
session.delete(restaurant)
session.commit()
self.send_response(301)
self.send_header('Content-type', 'text/html')
self.send_header('Location', '/restaurants')
self.end_headers()
except:
pass
name="Sunny",
email="*****@*****.**",
picture=
'http://www.youthconnect.in/wp-content/uploads/2013/11/Sachin-Tendulkar.jpg'
)
session.add(U1)
session.commit()
# Menu for Food Point
restaurant1 = Restaurant(user_id=1, name="Food Point")
session.add(restaurant1)
session.commit()
menuItem1 = MenuItem(user_id=1,
name="Amritsari Kulcha",
price="Rs 60",
course="Starters",
restaurant=restaurant1)
session.add(menuItem1)
session.commit()
menuItem2 = MenuItem(user_id=1,
name="Paneer Tikka",
price="Rs 120",
course="Starters",
restaurant=restaurant1)
session.add(menuItem2)
session.commit()
menuItem3 = MenuItem(user_id=1,
name="Chicken Biryani",
