def newItem(): if 'username' not in login_session: return redirect('/login') if request.method == 'POST': name = request.form['name'] description = request.form['description'] catagory_name = request.form['catagory'].replace('\n', '') if not session.query(Catagory).filter_by(name=catagory_name).all(): catagory = Catagory(name=catagory_name) session.add(catagory) newItem = Item(name=name, description=description, catagory_name=catagory_name, user_id=session.query(User).filter_by( email=login_session['email']).first().id) session.add(newItem) session.commit() flash('New Item %s Successfully Created' % (newItem.name)) return redirect(url_for('frontPage')) else: return render_template('newItem.html')
def catalog(catalog_id=None, catagory_id=None): ''' This route shows the main app page. ''' if not catalog_id: ## Default to catalog 1, since interface does not yet support switching. catalog_id = 1 if session.query(Catalog).count() == 0: ## Create the default catalog, since interface does not yet support ## Catalog creation. ## Also, create a few default catagories, since interface does not support ## creating these. ## Create a test item to drive the demo ## Create Anonymous user catagoryA = Catagory(description="clothes") catagoryB = Catagory(description="sports") catagoryC = Catagory(description="electronics") new_catalog = Catalog(name="catalogosphere") new_user = User(name="Anonymous") new_item = Item(title="Shirt", content="its awesome, its made out of synthetics.", user=new_user, catalog=new_catalog, catagory=catagoryA) session.add(new_item) session.add(catagoryB) session.add(catagoryC) session.commit() print "test catalog content created..." catagoriesForId = session.query(Catagory).filter_by(id=catagory_id) catagory = None if catagoriesForId.count() < 1 else catagoriesForId.one() if catagory: searchCriteria = catagory.description items = session.query(Item).filter_by(catalog_id=catalog_id, catagory_id=catagory_id).all() else: searchCriteria = "Recently added items" items = session.query(Item).filter_by( catalog_id=catalog_id).order_by("id desc").all()[:5] catalog = session.query(Catalog).filter_by(id=catalog_id).one() return render_template('catalog.html', catalog_id=catalog_id, catalog=catalog, catagory_id=catagory_id, items=items, searchCriteria=searchCriteria, catagories=allCatagories(catalog), currentUser=currentUser())
def newCatagory(): if request.method == 'POST': newCatagory = Catagory(name=request.form['name'], user_id=login_session['user_id']) flash('New Catagory %s Successfully Created' % newCatagory.name) session.add(newCatagory) session.commit() return redirect(url_for('showCatagories')) else: return render_template('newCatagory.html')
def newCategory(): if 'username' not in login_session: return redirect('/login') if request.method == 'POST': newCatagory = Catagory(name=request.form['name'], user_id=login_session['user_id']) session.add(newCatagory) session.commit() flash("new catagory has been created") return redirect(url_for('catalog')) else: return render_template('new_catagory.html')
def newShop(): if not checkLogin(login_session): flash('You must login to create a Catagory shop') return redirect(url_for('showShops')) if request.method == 'POST': newShop = Catagory(name=request.form['name'],description = request.form['description'], user_id = login_session.get('user_id') ) session.add(newShop) flash('New Catagory shop %s Successfully Created' % newShop.name) session.commit() return redirect(url_for('showShops')) else: return render_template('newshop.html',login_session = login_session)
def createNewCatagory(): if 'username' not in login_session: return redirect('/login') user_id = login_session['user_id'] if 'username' not in login_session: return redirect('/login') if request.method == 'POST': newcatagory = Catagory(name=request.form['catagory_name'], user_id=user_id) session.add(newcatagory) flash('Successfully created', "success") session.commit() return redirect(url_for('showCatagory')) else: return render_template('new_catagory.html')
def dec_newC(user_id, catalog_id, item_id): if request.method == 'GET': remove_session() return render_template('new_catalog.html') else: if request.form['name']: newCatagory = Catagory(name=request.form['name'], user_id=user_id) session.add(newCatagory) flash("New catagory created!") session.commit() remove_session() return redirect(url_for('All_catalog')) else: flash("Please give a name for catagory") remove_session() return render_template('new_catalog.html')
def newCatagory(): if 'username' not in login_session: return redirect('/login') if request.method == 'POST': name = request.form['name'] if not session.query(Catagory).filter_by(name=name).all(): newCatagory = Catagory(name=name) session.add(newCatagory) flash('New Catagory %s Successfully Created' % newCatagory.name) session.commit() print name return redirect(url_for('frontPage')) else: error = "A catagory with that name already exists." render_template('newCatagory.html', name=name, error=error) else: return render_template('newCatagory.html')
def newCatagory(): # If the method is POST, do the following if request.method == "POST": newCataName = request.form["catagory"] try: # Prevent catagory from repeating item = database_session.query( Catagory).filter_by(name=newCataName).one() flash("Catagory \"%s\" has already existed!" % (newCataName,)) return redirect("/newCatagory") except NoResultFound: # Try to add the new catagory newCata = Catagory(name=newCataName) try: database_session.add(newCata) database_session.commit() return redirect("/") except SQLAlchemyError: flash("Cannot commit the new item! Please contact developer!") return redirect("/newCatagory") else: return render_template("newCatagory.html")
# 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() # Menu for romance catagory1 = Catagory(user_id=1, name="romance") session.add(catagory1) session.commit() catagoryItem2 = CatagoryItem( user_id=1, name="i can hear your voice", description="hero can see what you think throgth your eyes", catagory=catagory1) session.add(catagoryItem2) session.commit() catagoryItem1 = CatagoryItem(user_id=1, name="her private life",
from sqlalchemy import create_engine from sqlalchemy.orm import sessionmaker from database_setup import Catagory, Base, Item engine = create_engine('sqlite:///catalog.db') Base.metadata.bind = engine DBSession = sessionmaker(bind=engine) session = DBSession() #add dummy data catagory1 = Catagory(name="Skiing") session.add(catagory1) session.commit() item1 = Item(description="Nice skis", title="Skis", catagory=catagory1) session.add(item1) session.commit() item2 = Item(description="Nice gloves", title="Gloves", catagory=catagory1) session.add(item2) session.commit() catagory2 = Catagory(name="Football") session.add(catagory2) session.commit() item3 = Item(description="Nice balls", title="Balls", catagory=catagory2) session.add(item3) session.commit()
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() #Create the Admin user user1 = User(name="Super Admin", email="*****@*****.**", picture="http://www.practical-programming.org/articles/love_null/images/null-pointer-exception.png") session.add(user1) session.commit() catagory1 = Catagory(name = "Soccer") add_and_commit(session, catagory1) item1 = Item(user_id=1, title = "Soccer Cleats", description = "You wear them on your feet", catagory=catagory1, date_added = datetime.datetime.now()) add_and_commit(session, item1) item2 = Item(user_id=1, title = "Jersey", description = "You wear it on your body", catagory=catagory1, date_added = datetime.datetime.now()) add_and_commit(session, item2) catagory2 = Catagory(name = "Basketball") add_and_commit(session, catagory2) item1 = Item(user_id=1, title = "Basketball", description = "The Ball you play with", catagory=catagory2, date_added = datetime.datetime.now()) add_and_commit(session, item1)
engine = create_engine('postgresql://*****:*****@localhost/catalog') # 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() user1 = User(email="*****@*****.**", name="Jonathan") sport1 = Catagory(name="Swimming", user=user1) session.add(sport1) session.commit() sportEquipment1 = Item(name="Goggles", description=("Protect eyes from having" "contact with water"), catagory=sport1, user=user1) session.add(sportEquipment1) session.commit()
def NewCatagory(c_name,c_desc,c_user_id): item = Catagory(name = c_name,description=c_desc,user_id=c_user_id) session.add(item) session.commit()
Base.metadata.bind = engine DBSession = sessionmaker(bind=engine) session = DBSession() User1 = User( name="Robo Barista", email="*****@*****.**", picture= 'https://pbs.twimg.com/profile_images/2671170543/18debd694829ed78203a5a36dd364160_400x400.png' ) session.add(User1) session.commit() cat1 = Catagory(user_id=1, name="Soccer") session.add(cat1) session.commit() catItem1 = CatagoryItem(user_id=1, name="Two shinguard", description="any thing =D", catagory=cat1) session.add(catItem1) session.commit() catItem2 = CatagoryItem(user_id=1, name="Shinguard", description="any thing =D",
from database_setup import Base, Catagory, Item from sqlalchemy.orm import sessionmaker from sqlalchemy import create_engine # database im using engine = create_engine('sqlite:///catalogproject.db') Base.metadata.bind = engine DBSession = sessionmaker(bind=engine) session = DBSession() firstCatagory = Catagory(name="Video Game System") session.add(firstCatagory) session.commit() secondCatagory = Catagory(name="Video Game") session.add(secondCatagory) session.commit() thirdCatagory = Catagory(name="Disneyworld Parks") session.add(thirdCatagory) session.commit() fourthCatagory = Catagory(name="Disney Movies") session.add(fourthCatagory) session.commit() fifthCatagory = Catagory(name="Sci-Fi Movies") session.add(fifthCatagory) session.commit()
Base.metadata.bind = engine DBSession = sessionmaker(bind=engine) session = DBSession() picture = "https://lh3.googleusercontent.com/-XdUIqdMkCWA/AAAAAAAAAAI/AAAAAAAAAAA/4252rscbv5M/photo.jpg" user1 = User(name="Wei", email="*****@*****.**", picture=picture) session.add(user1) session.commit() user2 = User(name="Jun", email="*****@*****.**", picture=picture) session.add(user2) session.commit() shop1 = Catagory(name="Lego Shop", description="First shop", user_id=user1.id) session.add(shop1) session.commit() shop2 = Catagory(name="SuperHero Shop", description="Second shop", user_id=user2.id) session.add(shop2) session.commit() Catagory1 = CatagoryItem(name="Lego 1 ", description="plastic Catagorys.", user_id=user1.id, price="11", shop_id=shop1.id) session.add(Catagory1)
def addCatagory(catagoryName): cat = Catagory(name=func.upper(catagoryName)) session.add(cat) session.commit()
import datetime from sqlalchemy import create_engine from sqlalchemy.orm import sessionmaker from database_setup import Base, Catagory, CatagoryItem engine = create_engine('sqlite:///catalog.db') Base.metadata.bind = engine DBSession = sessionmaker(bind=engine) session = DBSession() action = Catagory(name="Action") session.add(action) session.commit() shooter = Catagory(name="Shooter") session.add(shooter) session.commit() action_adventure = Catagory(name="Action-adventure") session.add(action_adventure) session.commit() adventure = Catagory(name="Adventure") session.add(adventure) session.commit() role_playing = Catagory(name="Role-playing")