def home(cid = None, item_id = None): #Check input: Category ID if cid == None: category_id = Category.get_root().id else: category_id = cid #Get one that is specified categories = [] + [Category.get_by_id(category_id)] #Get children if len(categories) == 1: children = Category.get_children(category_id, count_items = True) if len(children) == 0: #If no children, then get parent of it parent_id = categories[0].parent categories = [] + [Category.get_by_id(parent_id)] #get children of the parent children = Category.get_children(parent_id, count_items = True) if len(children) > 0: categories += children categories[0].parent_flag = True #Assign selected_flag for c in categories: if c.id == int(category_id): c.selected_flag = True else: c.selected_flag = False #Get item or items item = None items = [] if item_id == None: items = Item.get_by_category(category_id) else: item = Item.get_by_id(item_id) if isinstance(item, Item) and item.category_id != category_id: item = None return render_template('home.html', title = 'Catalog Excercise',\ categories = categories,\ items = items,\ item = item )
def catalogXML(): """ ####Returns#### + genres: XML object of all genres and books """ root = ET.Element('genres') return app.response_class( ET.tostring( Category.getCatalogXML(session, root), encoding='us-ascii', method='xml'), mimetype='application/xml')
def categoryXML(category_id): """ ####Args#### + category_id: the id of the category of the book ####Returns#### + genre: XML object of the genre """ category = session.query(Category).filter_by(id=category_id).one() root = ET.Element('genre') return app.response_class( ET.tostring( Category.getCategoryXML(session, category.id, root), encoding='us-ascii', method='xml'), mimetype='application/xml')
from sqlalchemy import create_engine from sqlalchemy.orm import sessionmaker from database_setup import Base, Category, Item, User engine = create_engine('sqlite:///itemcatalogwithusers.db') Base.metadata.bind = engine DBSession = sessionmaker(bind=engine) session = DBSession() User1 = User(name='Default', email='Default') session.add(User1) session.commit() category1 = Category(name='Soccer') session.add(category1) session.commit() item1 = Item(name='Soccer Cleats', category=category1, user_id=1) session.add(item1) session.commit() item2 = Item(name='Jersey', category=category1, user_id=1) session.add(item2) session.commit() item3 = Item(name='Shin Guards', category=category1, user_id=1) session.add(item3) session.commit() category2 = Category(name='Baseball')
'Snowboard':'Boards where both feet are secured to the same board and are wider than skis,', 'Boots':'Snowboard boots are mostly considered soft boots, though alpine snowboarding uses a harder boot similar to a ski boot.', 'Bindings':'Bindings are separate components from the snowboard deck and are very important parts of the total snowboard interface.' } #Hockey Items # Retreived from: https://en.wikipedia.org/wiki/Ice_hockey_equipment hockey_items = { 'Helmet':'A helmet with strap, and optionally a face cage or visor, is required of all ice hockey players.', 'Neck guard':'For "skaters", a neck guard typically consists of a series of nylon or ABS plates for puncture resistance.', 'Shoulder pads':'Hockey shoulder pads are typically composed of a passed vest with front and back panels.' } #Adding Categories and items to DB for cat in categories: category_name = Category(name=cat) session.add(category_name) session.commit() if cat == "Soccer": for soccerItem in soccer_items: item = Items(name=soccerItem, description=soccer_items[soccerItem], category = category_name) session.add(item) session.commit() elif cat == "Basketball": for basketballItem in basketball_items: item = Items(name=basketballItem, description=basketball_items[basketballItem], category = category_name) session.add(item) session.commit() elif cat == "Baseball": for baseballItem in baseball_items: item = Items(name=baseballItem, description=baseball_items[baseballItem], category = category_name)
import csv from sqlalchemy import create_engine from sqlalchemy.orm import sessionmaker from database_setup import Base, Class, Category # Connect to Database and create database session engine = create_engine('sqlite:///catalog.db') Base.metadata.bind = engine DBSession = sessionmaker(bind=engine) session = DBSession() # Add sample data to database with open('sample_data.csv', 'rb') as csvfile: csv_reader = csv.reader(csvfile, delimiter=',', quotechar='"', skipinitialspace=True) for row in csv_reader: category = session.query(Category).filter_by(title=row[0]).first() if not category: category = Category(title=row[0]) session.add(category) session.flush() # so that category.id returns value before commit session.add( Class(category_id=category.id, title=row[1], description=row[2])) session.commit()
# 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() # Create dummy user User1 = User(name="Robo Barista", email="*****@*****.**", picture=('https://pbs.twimg.com/profile_images/2671170543/' '18debd694829ed78203a5a36dd364160_400x400.png')) session.add(User1) session.commit() # Questions in the category of History category1 = Category(name="History") session.add(category1) session.commit() item1 = Item(user_id=1, air_date="2004-12-31", question=("For the last 8 years of his life, Galileo was under" " house arrest for espousing this man\'s theory"), value="$200", answer="Copernicus", game_round="Jeopardy!", show_number="4680", category=category1) session.add(item1) session.commit() item2 = Item(user_id=1, air_date="1996-12-06", question=("Historians refer to the Golden Age as the time during"
# revert all of them back to the last commit by calling # session.rollback() session = DBSession() # Create dummy user User1 = User(name="omrkhoder", email="*****@*****.**", picture='https://upload.wikimedia.org/wikipedia/ \ commons/thumb/1/12/User_icon_2.svg/220px-User_icon_2.svg.png') session.add(User1) session.commit() ''' #### SANDWICHES #### ''' category1 = Category(user_id=1, name="SANDWICHES") session.add(category1) session.commit() Item1 = Item(user_id=1, name="Smoked Turkey", description="Smoked turkey,lettuce,mayonnise,mustard " "and cheddar cheese", price="$20", category=category1) session.add(Item1) session.commit() Item2 = Item(user_id=1,
# Bind the engine to the metadata of the Base class so that the # declaratives can be accessed through a DBSession instance Base.metadata.bind = engine DBSession = sessionmaker(bind=engine) # A DBSession() instance establishes all conversations with the database # 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() # Category Soccer and Items catSoccer = Category(name="Soccer") session.add(catSoccer) session.commit() catSoccerItem1 = Item(name="Socks", description=""" The main job of socks is to support the shin guards. Staying in place is the most important element of any good-fitting sock. They should neither slip down, nor impede circulation. You generally get what you pair for, so buy the best pair your budget can afford. """, category=catSoccer) session.add(catSoccerItem1) session.commit()
from sqlalchemy import create_engine from sqlalchemy.orm import sessionmaker from database_setup import Base, Category, Item, User engine = create_engine('sqlite:///categoryitemwithusers.db') Base.metadata.bind = engine DBSession = sessionmaker(bind=engine) session = DBSession() User1 = User(name="Priyanka Nalawade", email="*****@*****.**") session.add(User1) session.commit session.query(User).all() myfirstcategory = Category(user_id=1, name="Cat1") session.add(myfirstcategory) session.commit() session.query(Category).all() mysecondcategory = Category(user_id=1, name="Cat2") session.add(mysecondcategory) session.commit() session.query(Category).all() mythirdcategory = Category(user_id=1, name="Cat3") session.add(mythirdcategory) session.commit() session.query(Category).all() myfourthcategory = Category(user_id=1, name="Cat4") session.add(myfourthcategory) session.commit() session.query(Category).all() firstcatfirstitem = Item(user_id=1, title="firstcatfirstitem", description="this is firstcatfirstitem ", category=myfirstcategory)
from database_setup import Base, Item, Category from sqlalchemy.orm import sessionmaker from sqlalchemy import create_engine engine=create_engine('sqlite:///mathru.db', connect_args={'check_same_thread':False}) #Bind the above engine to the session Session=sessionmaker(bind=engine) #Create a session object session=Session() #Items for videos category1=Category(name="Programs") session.add(category1) session.commit() item1=Item(name="Journey", description="", category=category1) session.add(item1) session.commit() item2=Item(name="Ad-Campaign", description="", category=category1) session.add(item2) session.commit() #Items for Print Media category2=Category(name="Print Media") session.add(category2) session.commit() item1=Item(name="Magzine", description="", category=category2)
engine = create_engine("sqlite:///tolearn.db") Base.metadata.bind = engine DBSession = sessionmaker(bind=engine) session = DBSession() # CREATE data # user #email = "YOUR GOOGLEMAIL ADDRESS HERE" #name = "YOUR GOOGLE NAME HERE" me = User(name=name, email=email) session.add(me) session.flush() # category for user me = session.query(User).filter_by(name=name).one() js = Category(user_id=me.id, name="JavaScript") kotlin = Category(user_id=me.id, name="Kotlin") session.add(kotlin) session.add(js) session.flush() # item for category nodejs = LearningItem( category_id=js.id, name="Introduction to Node.js", description="Learn the basics of node by completing the blog series") angularjs = LearningItem(category_id=js.id, name="Introduction to AngularJS", description="Get started with AngularJS") kotlinbasics = LearningItem(category_id=kotlin.id, name="Kotlin Basics", description="Learn the basics of Kotlin")
user1 = User(id="none-1", name="Matt Mohan", email="*****@*****.**", profile_pic="") session.add(user1) session.commit() user2 = User(id="none-2", name="Stella Sparks", email="*****@*****.**", profile_pic="") session.add(user2) session.commit() # Create Categories category1 = Category(name="Baby Clothing", user_id=user1.id) session.add(category1) session.commit() category2 = Category(name="Diapers", user_id=user1.id) session.add(category2) session.commit() category3 = Category(name="Toys", user_id=user2.id) session.add(category3) session.commit() category4 = Category(name="Feeding", user_id=user2.id) session.add(category4) session.commit()
# 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() User1 = User( name="Robo Barista", email="*****@*****.**", picture= 'https://pbs.twimg.com/profile_images/2671170543/18debd694829ed78203a5a36dd364160_400x400.png', auto_signin=False) session.add(User1) session.commit() category1 = Category(name="Hockey", user=User1, user_id=User1.id) session.add(category1) session.commit() item1 = Item(name="Stick", description=lorem_ipsum, category=category1, category_id=category1.id, user=User1, user_id=User1.id) session.add(item1) session.commit() item2 = Item(name="Skates",
# A DBSession() instance establishes all conversations with the database # 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() # Create dummy user User1 = User(name="Shiva", email="*****@*****.**", picture='./shiva.jpg') session.add(User1) session.commit() # Items for Bikes Category1 = Category(user_id=1, name="Bikes") session.add(Category1) session.commit() item1 = Item(user_id=1, name="Apache RTR", description="One of the best two wheelers in its class!", capacity="2", fuelType="Petrol", mileage="45 kmpl", maxSpeed="148", price="1240$", category=Category1) session.add(item1)
from sqlalchemy import create_engine from sqlalchemy.orm import sessionmaker from database_setup import Category, Base, Item engine = create_engine('sqlite:///categoryitems.db') Base.metadata.bind = engine DBSession = sessionmaker(bind=engine) session = DBSession() soccer = Category(name='Soccer') session.add(soccer) session.commit() baseball = Category(name='Baseball') session.add(baseball) session.commit() hockey = Category(name='Hockey') session.add(hockey) session.commit() snowboarding = Category(name='Snowboarding') session.add(snowboarding) session.commit() frisbee = Category(name='Frisbee') session.add(frisbee) session.commit()
# session.rollback() session = DBSession() # Create dummy user user1 = User(name="User1", email="*****@*****.**") session.add(user1) session.commit() user2 = User(name="User2", email="*****@*****.**") session.add(user2) session.commit() # Create Categories category1 = Category(name="Drama", user_id=1) session.add(category1) session.commit() category2 = Category(name="Comedy", user_id=1) session.add(category2) session.commit() category3 = Category(name="Horror", user_id=1) session.add(category3) session.commit() category4 = Category(name="Action", user_id=1) session.add(category4) session.commit()
from sqlalchemy import create_engine from sqlalchemy.orm import sessionmaker from database_setup import User, Category, Item, Base # connect to the database engine = create_engine('sqlite:///catagories.db') Base.metadata.bind = engine DBSession = sessionmaker(bind=engine) session = DBSession() catagories = ("Soccer", "Basketball", "Baseball", "Frisbee", "Snowboarding", "Rock Climbing", "Foosball", "Skating", "Hockey") # add catagories to the database for category in catagories: c = Category(name=category) session.add(c) session.commit() print "added catagories"
from sqlalchemy import create_engine, asc from sqlalchemy.orm import sessionmaker import random import string db_engine = create_engine('sqlite:///ItemCatalog.db') db_session_binding = sessionmaker(bind=db_engine) db_session = db_session_binding() admin = User(name='Admin', email='*****@*****.**') tester = User(name='Tester', email='*****@*****.**') db_session.add(admin) db_session.add(tester) db_session.commit() db_session.add(Category(name='Soccer', user=admin)) db_session.add(Category(name='Basketball', user=tester)) db_session.add(Category(name='Baseball', user=admin)) db_session.add(Category(name='Frisbee', user=tester)) db_session.add(Category(name='Snowboarding', user=admin)) db_session.add(Category(name='Rock Climbing', user=tester)) db_session.add(Category(name='Foosball', user=admin)) db_session.add(Category(name='Skating', user=tester)) db_session.add(Category(name='Hockey', user=admin)) db_session.commit() db_session.add(Item(user=admin, description='-', name='Stick', category=db_session.query(Category). filter_by(name='Hockey').first())) db_session.add(Item(user=tester, description='-', name='Goggles', category=db_session.query(Category).
'https://pbs.twimg.com/profile_images/2671170543/18debd694829ed78203a5a36dd364160_400x400.png' ) session.add(User1) User2 = User( name="John Smith", email="*****@*****.**", picture= 'https://pbs.twimg.com/profile_images/2671170543/18debd694829ed78203a5a36dd364160_400x400.png' ) session.add(User2) session.commit() # Menu for UrbanBurger category1 = Category(user_id=1, name="Inkjet Printers") session.add(category1) session.commit() CatItem2 = CatItem( user_id=1, name="HP Deskjet 3788", description="All in one A4 4800 dpi usb wi-fi color inkjet", price="$67.50", #course="Entree", category=category1) session.add(CatItem2) session.commit()
from sqlalchemy.orm import sessionmaker from database_setup import Base, Category, User from database_setup import engine Base.metadata.bind = engine DBSession = sessionmaker(bind=engine) session = DBSession() # Seed database with categories action = Category(name="Action") session.add(action) session.commit() comedy = Category(name="Comedy") session.add(comedy) session.commit() horror = Category(name="Horror") session.add(horror) session.commit() sci_fi = Category(name="Science Fiction") session.add(sci_fi) session.commit() adventure = Category(name="Adventure") session.add(adventure) session.commit() drama = Category(name="Drama") session.add(drama)
# Connect the engine to a session Session = sessionmaker(bind=engine) # Setting up a Session object session = Session() user1 = User( name='Abdulrahman', email='*****@*****.**', ) session.add(user1) session.commit() category3 = Category(name='test category3', user=user1) session.add(category3) session.commit() item3 = Item(name='Item 3 test', description='It is an test item. to test the app', category=category3, user=user1) session.add(item3) session.commit() category4 = Category(name='test category4', user=user1) session.add(category4)
# Bind the engine to the metadata of the Base class so that the # declaratives can be accessed through a DBSession instance Base.metadata.bind = engine DBSession = sessionmaker(bind=engine) # A DBSession() instance establishes all conversations with the database # 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() # add categories in database category1 = Category(name="Football") session.add(category1) session.commit() category2 = Category(name="Basketball") session.add(category2) session.commit() category3 = Category(name="Tennis") session.add(category3) session.commit() category4 = Category(name="Swimming") session.add(category4) session.commit()
user1 = User(first_name="Deep", last_name="Agar", username="******", hash_password=hashedPass1) session.add(user1) session.commit() user2 = User(first_name="Priya", last_name="Agar", username="******", hash_password=hashedPass1) session.add(user2) session.commit() category1 = Category(title="Soccer") session.add(category1) session.commit() item1 = Item(title="Stick", description="New Description", categoryId=category1.id, userId=user1.id) session.add(item1) session.commit() item2 = Item(title="Goggles", description="New Description", categoryId=category1.id, userId=user1.id) session.add(item2)
from sqlalchemy import create_engine from sqlalchemy.orm import sessionmaker from database_setup import Category, Base, Item import datetime engine = create_engine('sqlite:///catalog.db') Base.metadata.bind = engine DBSession = sessionmaker(bind=engine) session = DBSession() # insert category and items for Soccer var_category = Category(category_name="Soccer") session.add(var_category) session.commit() var_item = Item( item_name="Shin guards", description= "A shin guard is a piece of equipment worn on the front of a player's shin to protect them from injury.", create_ts=datetime.datetime.now(), category=var_category) session.add(var_item) session.commit() var_item = Item( item_name="Jersey", description="A loose shirt worn by a member of team as part of a uniform", create_ts=datetime.datetime.now(), category=var_category) session.add(var_item) session.commit()
Base.metadata.bind = engine DBSession = sessionmaker(bind=engine) """ A DBSession() instance establishes all conversations with the database 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() # ---------------- Creating dummy Categories print('Created dummy Categories') Category1 = Category(name='Cat1', description='Cat1 description') Category2 = Category(name='Cat2', description='Cat2 description') Category3 = Category(name='Cat3', description='Cat3 description') print('Adding dummy categories...') session.add(Category1) session.add(Category2) session.add(Category3) # session.commit() print('Categories stored in DB') # ---------------- Creating dummy Items print('Creating dummy items...') Item1 = Item(name='Item1', description='Item1 description', price='111') Item2 = Item(name='Item2', description='Item2 description', price='222')
session.execute('''DELETE FROM user''') session.commit() session.close() # Create dummy user User1 = User(name="Mohammed Devops", email="*****@*****.**", picture='300x300.png') session.add(User1) session.commit() # Read JSON File of Data, to edit raw_data, edit them in raw_data folder with open('categories.json') as f: category_data = json.load(f) for category in category_data: session.add(Category(name=category['name'])) session.commit() print("Loaded Item Catalog Data into DB") print("Categories Added: %s" % session.query(Category).count()) with open('items.json') as f1: item_data = json.load(f1) for item in item_data: # Grab the category record that the item is attached to each item category = session.query(Category) \ .filter_by(name=item['category']).one() session.add(Item(name=item['name'], description=item['description'], category=category, user=User1)) session.commit()
# revert all of them back to the last commit by calling # session.rollback() session = DBSession() # Create dummy user User1 = User( name="Robo Barista", email="*****@*****.**", picture= 'https://pbs.twimg.com/profile_images/2671170543/18debd694829ed78203a5a36dd364160_400x400.png' ) session.add(User1) session.commit() # Ski category1 = Category(user_id=1, name="Ski") session.add(category1) session.commit() item2 = Item(user_id=1, name="Helmet", description="Head protection for skiers", category=category1) session.add(item2) session.commit() item1 = Item(user_id=1, name="Skis", description="Very good skis to ski",
# 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() #User user1 = User(name="Olivia Gmail",email="*****@*****.**") session.add(user1) session.commit() user2 = User(name="Olivia Facebook",email="*****@*****.**") session.add(user2) session.commit() #Category category1 = Category(name="Soccer") session.add(category1) session.commit() category2 = Category(name="Basketball") session.add(category1) session.commit() category3 = Category(name="Snowboarding") session.add(category1) session.commit() dateTimeNow = datetime.datetime.now() #Menu for UrbanBurger item1 = Item(name = "Soccer Ball", description="an inflated ball used in playing soccer",
engine = create_engine('sqlite:///itemcatalog.db') Base.metadata.bind = engine DBSession = sessionmaker(bind=engine) session = DBSession() # Create dummy user User1 = User(name="Arch user", email="*****@*****.**", picture='') session.add(User1) session.commit() print "added one user!" # Menu for UrbanBurger category1 = Category(user_id=1, name="Soccer") session.add(category1) category2 = Category(user_id=1, name="Basketball") session.add(category2) category3 = Category(user_id=1, name="Baseball") session.add(category3) category4 = Category(user_id=1, name="Frisbee") session.add(category4) category5 = Category(user_id=1, name="Snowboarding") session.add(category5) category6 = Category(user_id=1, name="Rock Climbing") session.add(category6) category7 = Category(user_id=1, name="Skating") session.add(category7) category8 = Category(user_id=1, name="Hockey") session.add(category8)
from sqlalchemy import create_engine from sqlalchemy.orm import sessionmaker from database_setup import User, Base, Item, Category engine = create_engine('sqlite:///itemcatalog.db') # Bind the engine to the metadata of the Base class so that the # declaratives can be accessed through a DBSession instance Base.metadata.bind = engine DBSession = sessionmaker(bind=engine) session = DBSession() category1 = Category(category_name="Art") session.add(category1) session.commit() category2 = Category(category_name="Electronics") session.add(category2) session.commit() category3 = Category(category_name="Fashion") session.add(category3) session.commit() category4 = Category(category_name="Music") session.add(category4) session.commit() category5 = Category(category_name="Home")
# A DBSession() instance establishes all conversations with the database # 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() # Create user User1 = User(name="latifa", email="*****@*****.**") session.add(User1) session.commit() # Item for Action movies category1 = Category(user_id=1, name="Action") session.add(category1) session.commit() Item1 = Item( user_id=1, title="Mission Impossible Fallout", description= "Ethan Hunt and his IMF team along with some familiar allies race against time after a mission gone wrong", # noqa category=category1) session.add(Item1) session.commit() Item2 = Item(
from sqlalchemy import create_engine from sqlalchemy.orm import sessionmaker from database_setup import Base, Category engine = create_engine('sqlite:///catalog.db') Base.metadata.bind = engine DBSession = sessionmaker(bind=engine) session = DBSession() categories = [ 'Hand Tools', 'Power Tools', 'Electrical', 'Plumbing', 'Lumber', 'Safety' ] for c in categories: new_category = Category(name=c) session.add(new_category) session.commit() print "Categories added"