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)