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")