def bodySectionJson(section_id):
try:
section = session.query(BodySection).filter_by(id=section_id).one()
products = session.query(Product).filter_by(bodysection_id=section.id)
return jsonify(specific_products=[p.serialize for p in products])
except:
return (json.dumps(''))
def editProduct(product_id):
try:
form = NewProductForm(request.form)
product = (session.query(Product).
filter(Product.id==product_id).one())
sections = session.query(BodySection).all()
except:
flash("That particular product is not registered ")
return redirect(url_for('newProduct'))
if product.user_id == login_session['user_id']:
if request.method == 'GET':
return render_template('editProduct.html',
product=product, sections= sections,
image=login_session['picture'])
if request.method == 'POST' and form.validate():
print '/n/n/n/ post/n/n'
if request.form['btn'] == 'Save':
form.populate_obj(product)
if request.files['picture']:
file = request.files['picture']
filename = secure_filename(file.filename)
product.picture_name = IMAGES_FOLDER + filename
file.save(app.config['UPLOAD_FOLDER'] + filename)
session.add(product)
session.commit()
return redirect(url_for('product', product_id=product_id))
elif request.form['btn'] == 'Cancel':
return redirect(url_for('product', product_id=product_id))
else:
flash("Only the creator of every product can edit it")
return redirect(url_for('product', product_id=product_id ))
def user_loader(user_email):
try:
return session.query(User).filter(User.email==user_email).one()
except:
return None
def editBodySection(body_section_id):
try:
form = NewBodySectionForm(request.form)
body_section = (session.query(BodySection).filter(
BodySection.id == body_section_id).one())
except:
flash("That section is not defined, please define it to continue ")
return redirect(url_for('newBodySection'))
if body_section.user_id == login_session['user_id']:
if request.method == 'GET':
return render_template('editBodySection.html',
bodysection=body_section,
image=login_session['picture'])
if request.method == 'POST' and form.validate():
if request.form['btn'] == 'Update':
form.populate_obj(body_section)
session.commit()
return redirect(url_for('index'))
elif request.form['btn'] == 'Cancel':
return redirect(url_for('section', section_id=body_section_id))
else:
flash("Only the creator of every section can edit it")
return redirect(url_for('index'))
def deleteBodySection(body_section_id):
try:
body_section = (session.query(BodySection).
filter(BodySection.id==body_section_id).one())
except:
flash("That particular section is not defined ")
return redirect(url_for('newBodySection'))
form = NewBodySectionForm(request.form)
if body_section.user_id == login_session['user_id']:
if request.method == 'GET':
return render_template('deleteBodySection.html',
bodysection=body_section,
image=login_session['picture'])
if request.method == 'POST':
if request.form['btn'] == 'Delete':
session.delete(body_section)
session.commit()
return redirect(url_for('index'))
elif request.form['btn'] == 'Cancel':
return redirect(url_for('section', section_id=body_section_id))
else:
flash("Only the creator of every section can edit it")
return redirect(url_for('index'))
def editBodySection(body_section_id):
try:
form = NewBodySectionForm(request.form)
body_section = (session.query(BodySection).
filter(BodySection.id==body_section_id).one())
except:
flash("That section is not defined, please define it to continue ")
return redirect(url_for('newBodySection'))
if body_section.user_id == login_session['user_id']:
if request.method == 'GET':
return render_template('editBodySection.html',
bodysection=body_section,
image=login_session['picture'])
if request.method == 'POST' and form.validate():
if request.form['btn'] == 'Update':
form.populate_obj(body_section)
session.commit()
return redirect(url_for('index'))
elif request.form['btn'] == 'Cancel':
return redirect(url_for('section', section_id=body_section_id))
else:
flash("Only the creator of every section can edit it")
return redirect(url_for('index'))
def viewProducts():
if 'username' in login_session:
picture = login_session['picture']
else:
picture = None
products = session.query(Product).order_by(Product.bodysection_id).all()
return render_template('products.html', products=products, image=picture)
def viewProducts():
if 'username' in login_session:
picture = login_session['picture']
else:
picture = None
products = session.query(Product).order_by(Product.bodysection_id).all()
return render_template('products.html', products=products,
image=picture)
def index():
if 'username' in login_session:
picture = login_session['picture']
else:
picture = None
body_sections = session.query(BodySection).order_by(BodySection.name).all()
return render_template('index.html', bodysections=body_sections,
image=picture)
def sitemap():
#Dictionary to store the pages information
pages = []
#Static pages
priority = 1
for rule in app.url_map.iter_rules():
if "GET" in rule.methods and len(rule.arguments) == 0:
pages.append([rule.rule, priority])
#Body section generated pages
priority = 0
for section in session.query(BodySection).all():
url = url_for('editBodySection', body_section_id=section.id)
pages.append([url, priority])
url = url_for('deleteBodySection', body_section_id=section.id)
created_time = section.created_time
pages.append([url, priority])
#Product generated pages
for product in session.query(Product).all():
url = url_for('editProduct', product_id=product.id)
created_time = product.created_time
pages.append([url, priority])
url = url_for('deleteProduct', product_id=product.id)
created_time = product.created_time
pages.append([url, priority])
url = url_for('newProduct', product_id=product.id)
created_time = product.created_time
pages.append([url, priority])
sitemap_xml = render_template('sitemap.xml', pages=pages)
response = make_response(sitemap_xml)
response.headers["Content-Type"] = "application/xml"
return response
def sitemap():
#Dictionary to store the pages information
pages=[]
#Static pages
priority = 1
for rule in app.url_map.iter_rules():
if "GET" in rule.methods and len(rule.arguments)==0:
pages.append([rule.rule, priority])
#Body section generated pages
priority = 0
for section in session.query(BodySection).all():
url=url_for('editBodySection',body_section_id=section.id)
pages.append([url, priority])
url=url_for('deleteBodySection',body_section_id=section.id)
created_time=section.created_time
pages.append([url, priority])
#Product generated pages
for product in session.query(Product).all():
url=url_for('editProduct',product_id=product.id)
created_time=product.created_time
pages.append([url, priority])
url=url_for('deleteProduct',product_id=product.id)
created_time=product.created_time
pages.append([url, priority])
url=url_for('newProduct', product_id=product.id)
created_time=product.created_time
pages.append([url, priority])
sitemap_xml = render_template('sitemap.xml', pages=pages)
response= make_response(sitemap_xml)
response.headers["Content-Type"] = "application/xml"
return response
def index():
if 'username' in login_session:
picture = login_session['picture']
else:
picture = None
body_sections = session.query(BodySection).order_by(BodySection.name).all()
return render_template('index.html',
bodysections=body_sections,
image=picture)
def section(section_id):
try:
if 'username' in login_session:
picture = login_session['picture']
else:
picture = None
body_section = (session.query(BodySection).
filter(BodySection.id==section_id).one())
products = (session.query(Product).filter(Product.bodysection_id==section_id)
.all())
if request.method == 'GET':
return render_template('section.html', bodysection=body_section,
products=products,
image=login_session['picture'])
except:
flash("That particular section is not defined ")
return redirect(url_for('newBodySection'))
def section(section_id):
try:
if 'username' in login_session:
picture = login_session['picture']
else:
picture = None
body_section = (session.query(BodySection).filter(
BodySection.id == section_id).one())
products = (session.query(Product).filter(
Product.bodysection_id == section_id).all())
if request.method == 'GET':
return render_template('section.html',
bodysection=body_section,
products=products,
image=login_session['picture'])
except:
flash("That particular section is not defined ")
return redirect(url_for('newBodySection'))
def createUser(login_session):
try:
user = User(login_session['username'], login_session['email'],
login_session['picture'], True)
session.add(user)
session.commit()
user = session.query(User).filter_by(
email=login_session['email']).one()
return user.id
except:
return None
def editProduct(product_id):
try:
form = NewProductForm(request.form)
product = (session.query(Product).filter(
Product.id == product_id).one())
sections = session.query(BodySection).all()
except:
flash("That particular product is not registered ")
return redirect(url_for('newProduct'))
if product.user_id == login_session['user_id']:
if request.method == 'GET':
return render_template('editProduct.html',
product=product,
sections=sections,
image=login_session['picture'])
if request.method == 'POST' and form.validate():
print '/n/n/n/ post/n/n'
if request.form['btn'] == 'Save':
form.populate_obj(product)
if request.files['picture']:
file = request.files['picture']
filename = secure_filename(file.filename)
product.picture_name = IMAGES_FOLDER + filename
file.save(app.config['UPLOAD_FOLDER'] + filename)
session.add(product)
session.commit()
return redirect(url_for('product', product_id=product_id))
elif request.form['btn'] == 'Cancel':
return redirect(url_for('product', product_id=product_id))
else:
flash("Only the creator of every product can edit it")
return redirect(url_for('product', product_id=product_id))
def newProduct(section_id):
sections = session.query(BodySection).all()
# Check if the request comes from a particular section
if section_id:
preselected_section = (session.query(BodySection).filter(
BodySection.id == section_id).one())
else:
preselected_section = section_id
form = NewProductForm(request.form)
product = Product()
if request.method == 'GET':
return render_template('newProduct.html',
sections=sections,
ps_section=preselected_section,
image=login_session['picture'])
if request.method == 'POST' and form.validate():
form.populate_obj(product)
file = request.files['picture']
filename = secure_filename(file.filename)
product.user_id = login_session['user_id']
product.picture_name = app.config['IMAGES_FOLDER'] + filename
if allowed_file(filename):
file.save(app.config['UPLOAD_FOLDER'] + filename)
session.add(product)
session.commit()
flash("New product added! ")
else:
flash("Error while saving the photo file!")
if section_id:
return redirect(url_for('section', section_id=section_id))
return redirect(url_for('viewProducts'))
def createUser(login_session):
try:
user = User(login_session['username'],
login_session['email'],
login_session['picture'],
True)
session.add(user)
session.commit()
user = session.query(User).filter_by(email=login_session['email']).one()
return user.id
except:
return None
def newProduct(section_id):
sections = session.query(BodySection).all()
# Check if the request comes from a particular section
if section_id:
preselected_section = (session.query(BodySection).
filter(BodySection.id==section_id).one())
else:
preselected_section = section_id
form = NewProductForm(request.form)
product = Product()
if request.method == 'GET':
return render_template('newProduct.html', sections=sections,
ps_section=preselected_section,
image=login_session['picture'])
if request.method == 'POST' and form.validate():
form.populate_obj(product)
file = request.files['picture']
filename = secure_filename(file.filename)
product.user_id = login_session['user_id']
product.picture_name = app.config['IMAGES_FOLDER'] + filename
if allowed_file(filename):
file.save(app.config['UPLOAD_FOLDER'] + filename)
session.add(product)
session.commit()
flash("New product added! ")
else:
flash("Error while saving the photo file!")
if section_id:
return redirect(url_for('section', section_id=section_id))
return redirect(url_for('viewProducts'))
def product(product_id):
if 'username' in login_session:
picture = login_session['picture']
else:
picture = None
try:
product = (session.query(Product).
filter(Product.id==product_id).one())
if request.method == 'GET':
return render_template('product.html', product=product,
image=picture)
except:
flash("That particular product is not registered ")
return redirect(url_for('newProduct'))
def product(product_id):
if 'username' in login_session:
picture = login_session['picture']
else:
picture = None
try:
product = (session.query(Product).filter(
Product.id == product_id).one())
if request.method == 'GET':
return render_template('product.html',
product=product,
image=picture)
except:
flash("That particular product is not registered ")
return redirect(url_for('newProduct'))
def deleteProduct(product_id):
try:
product = (session.query(Product).
filter(Product.id==product_id).one())
form = NewProductForm(request.form)
except:
flash("That particular product is not registered ")
return redirect(url_for('newProduct'))
if product.user_id == login_session['user_id']:
if request.method == 'GET':
return render_template('deleteProduct.html', product=product,
image=login_session['picture'])
if request.method == 'POST':
if request.form['btn'] == 'Delete':
session.delete(product)
session.commit()
return redirect(url_for('viewProducts'))
else:
flash("Only the creator of every product can edit it")
return redirect(url_for('product', product_id=product_id ))
def deleteProduct(product_id):
try:
product = (session.query(Product).filter(
Product.id == product_id).one())
form = NewProductForm(request.form)
except:
flash("That particular product is not registered ")
return redirect(url_for('newProduct'))
if product.user_id == login_session['user_id']:
if request.method == 'GET':
return render_template('deleteProduct.html',
product=product,
image=login_session['picture'])
if request.method == 'POST':
if request.form['btn'] == 'Delete':
session.delete(product)
session.commit()
return redirect(url_for('viewProducts'))
else:
flash("Only the creator of every product can edit it")
return redirect(url_for('product', product_id=product_id))
def productJson(product_id):
try:
product = session.query(Product).filter_by(id=product_id).one()
return jsonify(Product_info=product.serialize)
except:
return (json.dumps(''))
def productJson(product_id):
try:
product = session.query(Product).filter_by(id=product_id).one()
return jsonify(Product_info=product.serialize)
except:
return (json.dumps(''))
