Flask App Not Posting to Database

Question

I can't seem to get this form to post data to my database. I'm working in the Flask framework for Python. When I submit the form, I see a POST event execute (see below), but nothing is written to the database.

[21/Nov/2015 04:21:47] "POST /create-event HTTP/1.1" 200 -

I know the database connection itself is good because another write function is working. Below is the code along with an indication of which file it is in.

app.py

# CREATE EVENT
@app.route('/create-event', methods=('GET', 'POST'))
@login_required
def create_event():
    form = forms.EventForm()
    if form.validate_on_submit():
        models.Event.create(user=g.user.id,
                            name=form.name.data.strip(),
                            description=form.description.data.strip(),
                            date=form.date.data.strip()
                            )
        flash("Event created!", "success")
        return redirect(url_for('timeline'))
    return render_template('userpages/event_create.html', form=form)

forms.py

class EventForm(Form):
    name = StringField("Event Name", validators=[DataRequired()])
    description = TextAreaField("Description", validators=[DataRequired()])
    date = DateField("Date", validators=[DataRequired()])

models.py

class Event(Model):
    timestamp = DateTimeField(default=datetime.datetime.now)
    user = ForeignKeyField(
        rel_model=User,
        related_name='events'
    )
    name = CharField()
    description = TextField()
    date = DateField()

    class Meta:
        database = DATABASE
        order_by = ('-timestamp',)

event_create.html

{% extends "layout.html" %}
{% from 'macros.html' import render_field %}

{% block content %}

<h1>Create New Event</h1>

<form method="POST" action="" class="form">
    {{ form.hidden_tag() }}
    {% for field in form %}
        {{ render_field(field) }}
    {% endfor %}
    <button type="submit" id="submit">Create</button>
</form>

{% endblock %}

Any ideas?

Answer 1 · 2015-11-21T08:11:00Z

November 21, 2015 8:11am

I mocked up your code to run (using scaffolding from the flask-social project). In debug, in addition to also see the Post 200 log message, I saw a runtime error when trying to create the event:

builtins.AttributeError
AttributeError: 'datetime.date' object has no attribute 'strip'

Looking at your create_event code, removing the.strip()` from the date field seems to fix the issue.

@app.route('/create-event', methods=('GET', 'POST'))
@login_required
def create_event():
    form = forms.EventForm()
    if form.validate_on_submit():
        models.Event.create(user=g.user.id,
                            name=form.name.data.strip(),
                            description=form.description.data.strip(),
                            # date=form.date.data.strip()  # NO strip() attribute
                            date=form.date.data
                            )
        flash("Event created!", "success")
        # return redirect(url_for('timeline'))
        return redirect(url_for('index'))
    # return render_template('userpages/event_create.html', form=form)
    return render_template('event_create.html', form=form)

Welcome to the Treehouse Community

Looking to learn something new?

Kyle Barney

Kyle Barney

Flask App Not Posting to Database

Chris Freeman

Chris Freeman

Kyle Barney

Kyle Barney

1 Answer

Chris Freeman

Chris Freeman

Kyle Barney

Kyle Barney

Kyle Barney

Kyle Barney