Added files via upload

studyonlyonline · studyonlyonline · commit d4bd88f29e42 · 2016-03-27T16:52:10.000+05:30
diff --git a/python_database_sqlalchemy/database_curd.py b/python_database_sqlalchemy/database_curd.py
@@ -0,0 +1,11 @@
+from sqlalchemy import create_engine
+from sqlalchemy.orm import sessionmaker
+from database_setup import Base,Restaurant ,MenuItem
+
+def start_lines():
+	global session
+	engine=create_engine("mysql+mysqlconnector://root:@localhost/python_mysql")
+	Base.metadata.create_all(engine)
+
+	DBSession=sessionmaker(bind=engine)
+	session=DBSession()
diff --git a/python_database_sqlalchemy/insert_data.py b/python_database_sqlalchemy/insert_data.py
@@ -0,0 +1,21 @@
+from sqlalchemy import create_engine
+from sqlalchemy.orm import sessionmaker
+from database_setup import Base,Restaurant ,MenuItem
+
+engine=create_engine("mysql+mysqlconnector://root:@localhost/python_mysql")
+Base.metadata.create_all(engine)
+
+DBSession=sessionmaker(bind=engine)
+session=DBSession()
+
+myFirstRestaurant=Restaurant(name="Pizza palace")
+session.add(myFirstRestaurant)
+session.commit()
+
+cheesepizza=MenuItem(name="cheesepizza",description="this is cheese pizza",
+					price="8.99",course="meal",restaurant=myFirstRestaurant)
+session.add(cheesepizza)
+session.commit()
+
+session.query(Restaurant).all()
+session.query(MenuItem).all()
diff --git a/python_database_sqlalchemy/read_data.py b/python_database_sqlalchemy/read_data.py
@@ -0,0 +1,32 @@
+from sqlalchemy import create_engine
+from sqlalchemy.orm import sessionmaker
+from database_setup import Base,Restaurant ,MenuItem
+import database_curd
+
+database_curd.start_lines()
+
+session=database_curd.session
+restaurant=session.query(Restaurant).all()
+for i in restaurant:
+	print i.name
+# items=session.query(MenuItem).all()
+
+# veggie=session.query(MenuItem).filter_by(name='Veggie Burger')
+# for veg in veggie:
+# 	print veg.id
+# 	print veg.price
+# 	print veg.restaurant.name
+# 	print "\n"
+
+#updating
+# urban_veggie=session.query(MenuItem).filter_by(id=11).one()
+# print urban_veggie.price
+# urban_veggie.price="25"
+# session.add(urban_veggie)
+# session.commit()
+# for veg in veggie:
+# 	print veg.id
+# 	print veg.price
+# 	print veg.restaurant.name
+# 	print "\n"
+	
