def newItem():
# First we make sure we are loged in
if 'username' not in login_session:
return redirect('/login')
# Then we process the request, creating and item
categories = session.query(Categories)
if request.method == 'POST':
new = Items(name=request.form['name'], description=request.form[
'description'], price=request.form['price'], category=request.form['category'])
session.add(new)
session.commit()
flash("New item created!")
# Go back to main page and notify user
return redirect(url_for('catalog'))
else:
# Display form
return render_template('new.html', categories=categories)
def editItem(category, item):
# First we make sure we are loged in
if 'username' not in login_session:
return redirect('/login')
categories = session.query(Categories)
items = session.query(Items)
editedItem = session.query(Items).filter_by(name=item).one()
# Process the request and make sure everything is there then we update
if request.method == 'POST':
if request.form['name']:
editedItem.name = request.form['name']
if request.form['description']:
editedItem.description = request.form['description']
if request.form['price']:
editedItem.price = request.form['price']
if request.form['category']:
editedItem.category = request.form['category']
session.add(editedItem)
session.commit()
flash("Item edited!")
return redirect(url_for('catalog'))
else:
return render_template('edit.html', categories=categories, category=category, item=item, items=items)
# this file fills the books data and put them to database
from db_setup import session
from db_setup import Category, Book
# populate the database:
geography = Category(name="Geography")
session.add(geography)
session.commit()
history = Category(name="History")
session.add(history)
session.commit()
computer_science = Category(name="Computer Science")
session.add(computer_science)
session.commit()
history_of_england = Book(
name="History of England",
author="Arthur Dale",
category=history.id,
)
session.add(history_of_england)
session.commit()
def log():
cpu = psutil.cpu_percent()
newLog = Reading(reading=cpu)
session.add(newLog)
session.commit()
print "CPU: " + str(cpu)
