def store(user_id):
"""
Store item to database.
params:
user_id: foreign key that should exists in table users.id
"""
form = ItemForm()
if not form.validate():
return ItemController.message(False, form.errors)
item = Item()
item.name = form.name.data.strip()
item.description = form.description.data
item.category_id = CategoryHash.decode(form.category_id.data)
item.user_id = user_id
db.session.add(item)
if item.commit_changes():
return ItemController.message(True, item)
else:
return ItemController.message(
False, 'Could not save \
the given item.')
def new_item_save():
"""
saves the new item to db
"""
form = request.form
item = Item()
item.category_id = int(form['category'])
item.title = form['title']
item.description = form['description']
item.created_at = datetime.now()
item.user_id = current_user.id
db.session.add(item)
db.session.commit()
return redirect(url_for('index'))
def item_create(category_id):
"""
This creates a new item only if the user is logged in
"""
if not logged_in():
flash('Please log in to create items')
return redirect(url_for('category_list'))
form = ItemForm()
if form.validate_on_submit():
item = Item()
item.title = form.title.data
item.description = form.description.data
item.category_id = category_id
item.ctlg_user = get_current_user()
db.session.add(item)
db.session.commit()
return redirect(url_for('item_create', category_id=category_id))
return render_template('item_create.html',
form=form,
category_id=category_id)
db.session.commit() print "User - Sophie Reddimalla created ID=" + str(user.id) print "Creating Sample Category Football ..." category = Category() category.title = "Football" category.user_id = user.id category.created = datetime.utcnow() category.modified = datetime.utcnow() db.session.add(category) db.session.commit() print "Category - Football created ID=" + str(category.id) print "Creating Sample Items in Football ..." item = Item() item.category_id = category.id item.title = "Soccer Ball" item.description = "High Quality ,Tournament grade" item.created = datetime.utcnow() item.modified = datetime.utcnow() item.user_id = user.id db.session.add(item) db.session.commit() print "Item - %s created ID=%d" % (item.title, item.id) print "Creating Sample Items in Football ..." item = Item() item.category_id = category.id item.title = "Studs - Reebok" item.description = "Imported Studs from Taiwan" item.created = datetime.utcnow()
