NameError: The global name 'form' is undefined. Flask-mysql

I am new to Python and Flask. I am trying to create a site where you can add books and write them to a MySQL database. When I run my project with PyCharm it works great until I go to the site where I would like to add my books. The error says: NameError: The global name 'form' is undefined. Can someone please help me fix this? Maybe I'm writing the code in the wrong place, I don't know.

My code:

views.py:

from flask import render_template, flash, redirect, session, url_for, request
from flask.ext.login import login_user, logout_user, current_user, login_required
from app import app, db, mysql
from .forms import LoginForm, AddForm, RegForm
from .models import User

@app.route('/books/add/admin', methods=['GET', 'POST'])
def books_add_admin():
    add = AddForm()

    if request.method == 'POST':
        cursor = mysql.connect().cursor()
             '''
             cursor = mysql.get_db().cursor()
             author = request.args.get(form.author.data)
             '''
        test = request.args.get(form.title.data)
        author = request.args.get(form.author.data)
        verlag = request.args.get(form.publisher.data)
        isbn = request.args.get(form.isbn.data)
        auflage = request.args.get(form.edition.data)
        exemplare = request.args.get(form.copies.data)
        kurztext = request.args.get(form.short_text.data)
        cursor.execute("INSERT INTO books (Titel, Autor, Verlag, ISBN, Auflage, Info)
        VALUES (titel, author, verlag, isbn, auflage, info);")

             #cursor = mysql.connect().cursor()
        con.commit()
        curser.close()

      

And the .py form code:

from flask.ext.wtf import Form
from wtforms import StringField, IntegerField, BooleanField, PasswordField, validators,
TextAreaField
from wtforms.validators import DataRequired, Length


class LoginForm(Form):
    student_number = IntegerField('student_number', validators=[DataRequired()])
    password = PasswordField('password', validators=[DataRequired()])
    #remember_me = BooleanField('remember_me', default=False)

class AddForm(Form):
    title = StringField('title', validators=[DataRequired()])
    author = StringField('author', validators=[DataRequired()])
    publisher = StringField('publisher', validators=[DataRequired()])
    isbn = IntegerField('isbn', validators=[Length(min=10, max=13)])
    edition = IntegerField('edition', validators=[Length(min=1, max=3)])
    copies = IntegerField('copies', validators=[Length(min=1, max=3)])
    short_info = TextAreaField('short_info', validators=[Length(min=0, max=1040)])

class RegForm(Form):
    student_number = IntegerField('student_number', validators=[Length(min=6, max=7)])
    forname = StringField('forname', validators=[DataRequired()])
    surname = StringField('surname', validators=[DataRequired()])
    email = StringField('email', validators=[DataRequired()])
    password = PasswordField('password', validators=[Length(min=6, max=24)])
    password2 = PasswordField('password2', validators=[Length(min=6, max=24)])

      

+3


source to share


2 answers


This appears to be the problem:

add = AddForm()

      

You have specified your variable add

, whereas you are referencing a variable reference form

here:



test = request.args.get(form.title.data)
author = request.args.get(form.author.data)
verlag = request.args.get(form.publisher.data)
isbn = request.args.get(form.isbn.data)
auflage = request.args.get(form.edition.data)
exemplare = request.args.get(form.copies.data)

      

The simplest solution is to rename the variable:

form = AddForm()

      

+2


source


In views.py, try changing:

add = AddForm()

      



For

form = AddForm()

      

+2


source







All Articles