用于将日期和时间捕获到 SQLAlchemy 的 Python 表单

Question

我正试图在python和flask中使用wtf_form，让用户输入日期和时间，然后将其保存到Sqlalchemy。我会分享我所拥有的，但现在我的烧瓶表格一旦填写完毕，在我提交表格时就不会接受日期条目。它不会给我任何错误，所以我确信这是不匹配的。任何想法都将不胜感激。非常感谢你的帮助。我目前正在使用SQLite作为我的数据库。

class Events(db.Model):
__tablename__ = 'events'
id = db.Column(db.Integer, primary_key=True)
eventname = db.Column(db.Text(64))
eventstart = db.Column(db.DateTime, nullable=False)
eventstop = db.Column(db.DateTime, nullable=False)
def __init__(
self, eventname, eventstart, eventstop
):
self.eventname = eventname
self.eventstart = eventstart
self.eventstop = eventstop

我的forms.py是：

# /myproject/events
from flask_wtf import FlaskForm
from wtforms import StringField, SubmitField, IntegerField
from wtforms.validators import DataRequired
from wtforms.fields import DateField

# Building the form in order to get a date picker and save it to the database.
class RegistrationForm(FlaskForm):
eventname = StringField('Event Name', validators=[DataRequired()])
eventstart = DateField(
'Enter start date and time', id='datepick', validators=[DataRequired()]
)
eventstop = DateField(
'Enter end date and time', id='datepick', validators=[DataRequired()]
)
submit = SubmitField('Register!')

我的观点.py是：

from myproject import app, db
from flask import (
render_template, redirect, url_for, flash,
Blueprint, request
)
from flask_login import login_user, login_required, logout_user
from myproject.models import Events
from myproject.events.forms import RegistrationForm
import validators
from flask_bootstrap import Bootstrap
Bootstrap(app)
events_blueprint = Blueprint(
'events', __name__,
template_folder='templates/events'
)
# @login_required
@events_blueprint.route('/add', methods=['GET', 'POST'])
def register():
try:
form = RegistrationForm()
if form.validate_on_submit():
event = Events(
eventname=form.eventname.data,
eventstart=form.eventstart.data,
eventstop=form.eventstop.data,
)
db.session.add(event)
db.session.commit()
flash("Thank you for registering your event.")
return redirect(url_for('list_event'))
return render_template('add.html', form=form)
except Exception as e:
print(e)

最后，我的HTML是：

{% extends "bootstrap/base.html" %}
{% import "bootstrap/wtf.html" as wtf %}
{% block title %}This is an example page{% endblock %}
{% block head %}
{{ super() }}
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datetimepicker/4.17.47/css/bootstrap-datetimepicker.min.css">
{% endblock %}
{% block content %}
<div class="container">
<h1>Hello, Bootstrap</h1>
<div class="row">
<div class='col-sm-6'>
<form method="POST">
{{form.hidden_tag()}}
{{form.eventname.label}}{{form.eventname()}}<br><br>
{{form.eventstart.label}}{{form.eventstart()}}<br><br>
{{form.eventstop.label}}{{form.eventstop()}}<br><br>
{{form.submit()}}
</form>
</div>
</div>
</div>
{% endblock %}
{% block scripts %}
{{ super() }}
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.18.1/moment.min.js"></script>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datetimepicker/4.17.47/js/bootstrap-datetimepicker.min.js"></script>
<script type="text/javascript">
$(function () {
$('#datepick').datetimepicker();
});
</script>
{% endblock %}

Answer 1

问题是在将表单信息保存到数据库中时。您已经在models.py中正确地将事件开始和事件停止声明为Datetime对象，并且您还正确地将DateField输入与Flask WTF一起使用，因此前端看起来一切都是正确的，但当您从表单中获得日期时，它会返回为字符串，需要将其解析并格式化为日期。幸运的是有办法做到这一点！

将以下导入添加到view.py文件中，并进行这些编辑以在数据库中创建事件。

from datetime import datetime
... 
eventstart=datetime.strptime(form.eventstart.data, '%Y-%m-%d')
eventstop=datetime.strptime(form.eventstop.data, '%Y-%m-%d')

这应该能解决问题！希望这会有所帮助。