CODEWITHSUNDEEP
pythonsqlalchemy
user981023
user981023

Reputation: 243

Flask-SQLAlchemy nullable=False

I'm messing around with Flask and the Flask-SQLAlchemy extension to create a simple registration form. In my User class, I have the attribute "email" set to nullable=False, but when I test the form on the site without including an email, it saves the new user to the db instead of throwing an exception as I expected. Any idea why that's happening? Thanks for looking!

Here's the code:

from flask import Flask, url_for, render_template, request, redirect
from flaskext.sqlalchemy import SQLAlchemy

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:////tmp/kloubi.db'
db = SQLAlchemy(app)

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(80), unique=True)
    email = db.Column(db.String(80), unique=True, nullable=False)
    fname = db.Column(db.String(80))
    lname = db.Column(db.String(80))

    def __init__(self, username, email, fname, lname):
        self.username = username
        self.email = email
        self.fname = fname
        self.lname = lname

@app.route('/')
def index():
    return render_template('index.html')

@app.route('/register/', methods=['GET', 'POST'])
def register():
    if request.method == 'POST':
        new_user = User(fname = request.form['name'], 
                        lname = request.form['surname'],
                        email = request.form['email'],
                        username = request.form['username'])
        db.session.add(new_user)
        db.session.commit()
        return redirect(url_for('index'))
    return render_template('register.html')

if __name__ == '__main__':
    app.debug = True
    app.run(host='0.0.0.0')

Upvotes: 5

Views: 18177

Answers (4)

Pratik149
Pratik149

Reputation: 1108

Option1: If you are defining form by yourself in HTML

Just by using the required attribute in input HTML tag will prompt the user that an input field must be filled out before submitting the form.

<form action="#">
  <input type="email" name="email" required>
  <input type="submit">
</form>

Option2: If you are using WTforms to define the form

Then by using validators.required() while defining form class you can achieve the same result

class MyForm(Form):
    email = EmailField(u'Email', [validators.required()])

Upvotes: 1

hasty001
hasty001

Reputation: 13

you can use html5 attribute email directly in html. See this.

Upvotes: -1

Ying.Zhao
Ying.Zhao

Reputation: 164

You can add a judgment if email != ''

Upvotes: 1

Bastian
Bastian

Reputation: 10433

The problem is when you submit the webform without entering an email it will contain an empty string "" .. not None... and an empty string is not the same als null and it is ok to store it in the field.

I suggest using something like wtforms to validate the input of the user.

Upvotes: 17

Related Questions