[Flask] Flasks and forms query

[Corey Boyle]

Perhaps this...
SubCategories(subcategory=form.subcategory.data)
should be this...
SubCategories(subcategory=form.subcategoryfield.data)


On Mon, Aug 5, 2019 at 6:25 AM <mhysnm1964 at gmail.com> wrote:

> All,
>
>
>
> I am fairly new to Python and Flask. So there is a lot of concepts I will
> not understand. So please bare with me if I don’t use the right terminology.
>
>
>
> The issue I am having is with flask_wtf and forms. I am using SelectFields
> which I want to grab the selected item from the list of options. I cannot
> get the data from the selector. If there is five items and I select the 2
> nd option. I want the value related to option 2 to be retrieved and
> updating a database. Below is the information I hope will make things clear.
>
>
>
> HTML template:
>
>
>
> {% extends "base.html" %}
>
>
>
> {% block content %}
>
>     <h1>New  Sub Category</h1>
>
>         <form action="" method="post" novalidate>
>
>         {{ form.hidden_tag() }}
>
>         {{ form.categoriesfield.label }}
>
>         {{ form.categoriesfield(rows=10) }}
>
>         <p>
>
>             {{ form.subcategoryfield.label }}<br>
>
>             {{ form.subcategoryfield(size=64) }}<br>
>
>             {% for error in form.subcategoryfield.errors %}
>
>             <span style="color: red;">[{{ error }}]</span>
>
>             {% endfor %}
>
>         </p>
>
>         <p>{{ form.submit() }}</p>
>
>     </form>
>
> … More HTML is here but not related to the question.
>
> {% endblock %}
>
>
>
> Now for the form.py class related to this form:
>
>
>
> from flask_wtf import FlaskForm
>
> from wtforms import StringField,  BooleanField, SubmitField,
> TextAreaField, TextField, IntegerField, RadioField, SelectField,
> SelectMultipleField
>
> from wtforms.validators import ValidationError, DataRequired, EqualTo,
> Length
>
> from app.models import  * # all table model classes
>
>
>
> class SubCategoryForm (FlaskForm):
>
>     categoriesfield = SelectField('Categories', choices= [(c.id,
> c.category) for c in Categories.query.order_by('category')])
>
>     subcategoryfield = StringField('Sub Category Name')
>
>     submit = SubmitField('Create SubCategory')
>
>
>
> Now for the routes.py function which the issue occurs. As you can tell
> below, I am passing the category id and category text value to the
> SelectField field to create the HTML code. The text value is being
> displayed and I want the ID to be retrieved. Then I am planning to update
> the SubCategory  table with the category id to establish the relationship
> for a new sub_category.
>
>
>
> from datetime import datetime
>
> from flask import render_template, flash, redirect, url_for, request
>
> from app import app, db
>
> from app.forms import CategoryForm, SubCategoryForm
>
> from app.models import * # all table model classes
>
>
>
> @app.route('/subcategories', methods=['GET', 'POST'])
>
> def subcategories ():
>
>     tables = Accounts.query.all()
>
>     form = SubCategoryForm()
>
>     print (form.categoriesfield.data)
>
>     if form.validate_on_submit():
>
>         subcategory_value  =
> SubCategories(subcategory=form.subcategory.data)
>
>         db.session.add(subcategory_value)
>
>         db.session.commit()
>
>         flash('Congratulations, a sub category was added. {}
> {}'.format(subcategory_value, form.categoriesfield.data))
>
>         return redirect(url_for('subcategories'))
>
>     page = request.args.get('page', 1, type=int)
>
>     records  =
> SubCategories.query.order_by(SubCategories.id).paginate(page,
> app.config['POSTS_PER_PAGE'], False)
>
>     next_url = url_for('subcategories', page=records.next_num) if
> records.has_next else None
>
>     prev_url = url_for('subcategories', page=records.prev_num) if
> records.has_prev else None
>
>     return render_template('subcategories.html', tables = tables,
> title='Manage  sub Categories', form=form, records = records.items,
> next_url = next_url, prev_url = prev_url)
>
>
>
> I cannot work how to get the category ID. If I use validate or not on any
> fields, it doesn’t produce anything in the flash. The page refreshes and
> leave the content in the field. The database isn’t being  updated with the
> new sub_category. All the database relationships are working when I
> manually insert the data into the table via SQLIte3.
>
>
>
> Any thoughts? Have I made myself clear enough?
>
>
>
> Sean
>
>
> _______________________________________________
> Flask mailing list
> Flask at python.org
> https://mail.python.org/mailman/listinfo/flask
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/flask/attachments/20190805/90ff6ab0/attachment-0001.html>