def addItem(): categories = session.query(Category).all() if request.method == 'GET': return render_template('addItem.html', categories=categories) else: item_cat_name = request.form.get('category_select') print(item_cat_name) item_cat_id = getCatagoryId(item_cat_name) print(item_cat_id) newitem = Items() newitem.item_name = request.form['item_name'] newitem.item_description = request.form['item_description'] newitem.cat_item_id = item_cat_id newitem.item_cat_name = item_cat_name session.add(newitem) session.commit() return redirect(url_for('getAllCategories'))