python - (builtins.TypeError) SQLite Time 类型只接受 Python 时间对象作为输入
问题描述
我尝试使用 Flask Login 将输入时间从 HTML 输入到 sqlite
这是模型
class Shop(db.Model):
__tablename__ = 'shop'
id = db.Column(db.Integer, primary_key=True)
shop_id = db.Column(db.BigInteger)
shop_name = db.Column(db.String(50))
shop_phone = db.Column(db.String(10))
shop_email = db.Column(db.String(100))
shop_calendarId = db.Column(db.String)
shop_address = db.Column(db.String(300))
shop_provinces = db.Column(db.String(20))
shop_start_time = db.Column(db.Time)
shop_end_time = db.Column(db.Time)
shop_workers = db.Column(db.Integer)
shop_slots = db.Column(db.Integer)
shop_step_time = db.Column(db.Integer)
shop_duration = db.Column(db.Integer)
shop_web = db.Column(db.String)
shop_fanpage = db.Column(db.String)
shop_facebook_mes = db.Column(db.String)
shop_logo = db.Column(db.String)
shop_description = db.Column(db.String(300))
shop_created_date = db.Column(db.Date)
shop_ended_date = db.Column(db.Date)
shop_token = db.Column(db.String)
def __str__(self):
return "{}".format(self.name)
def __repr__(self):
return "{}: {}".format(self.shop_id, self.__str__())
这是获取表单的python代码
@main.route('/dashboard', methods=['POST'])
@login_required
def dashboard_post():
email = current_user.email
shop = Shop.query.filter_by(shop_email=email).first()
shop_workers = request.form.get('shop_workers')
shop_slots = request.form.get('shop_slots')
shop_step_time = request.form.get('shop_step_time')
shop_duration = request.form.get('shop_duration')
shop_provinces = request.form.get('shop_provinces')
shop_address = request.form.get('shop_address')
shop_phone = request.form.get('shop_phone')
shop_token = request.form.get('shop_token')
shop_name = request.form.get('shop_name')
shop_start_time = request.form.get('shop_start_time')
shop_end_time = request.form.get('shop_end_time')
shop_web = request.form.get('shop_web')
shop_fanpage = request.form.get('shop_fanpage')
shop_facebook_mes = request.form.get('shop_facebook_mes')
shop_logo = request.form.get('shop_logo')
shop_description = request.form.get('shop_description')
if shop_workers != '':
shop.shop_workers = shop_workers
db.session.commit()
if shop_slots != '':
shop.shop_slots = shop_slots
db.session.commit()
if shop_step_time != shop_step_time:
shop.shop_step_time = shop_step_time
db.session.commit()
if shop_duration != '':
shop.shop_duration = shop_duration
db.session.commit()
if shop_provinces !='':
shop.shop_provinces = shop_provinces
db.session.commit()
if shop_phone !='':
shop.shop_phone = shop_phone
db.session.commit()
if shop_address !='':
shop.shop_address = shop_address
db.session.commit()
if shop_name !='':
shop.shop_name = shop_name
db.session.commit()
if shop_address !='':
shop.shop_address = shop_address
db.session.commit()
if shop_start_time !='':
shop.shop_start_time = shop_start_time
db.session.commit()
if shop_end_time !='':
shop.shop_end_time = shop_end_time
db.session.commit()
if shop_web !='':
shop.shop_web = shop_web
db.session.commit()
if shop_fanpage !='':
shop.shop_fanpage = shop_fanpage
db.session.commit()
if shop_facebook_mes !='':
shop.shop_facebook_mes = shop_facebook_mes
db.session.commit()
if shop_logo !='':
shop.shop_logo = shop_logo
db.session.commit()
if shop_description !='':
shop.shop_description = shop_description
db.session.commit()
return redirect(url_for('main.dashboard_redirect'))
这是html代码
<div class="col"><label
class="label-input-group">Giờ mở cửa: {{ shop_start_time }}</label>
<div class=""><input id="shop_start_time" name="shop_start_time" type="Time"
class="next-input"
placeholder="{{ shop_start_time }}" step="1"
value="">
</div>
</div>
<div class="col"><label
class="label-input-group">Giờ đóng cửa: {{ shop_end_time }}</label>
<div class=""><input id="shop_end_time" name="shop_end_time" type="Time"
class="next-input"
placeholder="{{ shop_end_time }}" step="1"
value="">
</div>
</div>
错误如下
sqlalchemy.exc.StatementError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely)
(builtins.TypeError) SQLite Time type only accepts Python time objects as input.
[SQL: UPDATE shop SET shop_start_time=? WHERE shop.id = ?]
[parameters: [{'shop_start_time': '08:00', 'shop_id_1': 1}]]
有谁帮帮我,谢谢
解决方案
引发异常是因为您尝试将字符串“08:00”直接从输入字段传递给对象。
该对象希望您提供一个time
对象,例如使用datetime
. 更多关于 python 的时间对象。. 您可以使用例如datetime 的 strptime构建这些对象。如果您想自动解析它,请查看Flask wtf。
推荐阅读
- vue.js - 页面重新加载后无法获取 Vuex getter 和突变中的状态
- python - 用于测试的无头 VTK
- join - 如何在 Solr 中使用 join 和 sort?
- group-by - Cassandra 3.11.4 CQL GROUP BY 不工作
- javascript - 如何等待访问短信的权限请求被确认
- sql-server - 尝试计算自 1900 年 1 月 1 日以来的天数并且 DateDiff 函数已关闭
- python - 我试图为python(linux)安装emcee和corner。我在安装过程中丢失了“python.h”。如何修复角落安装?
- javascript - 有没有更快的方法来对 HTML 表格进行排序?
- java - 在 Oreo 上复制 SQLite 数据库
- javascript - 如何在 Google 跟踪代码管理器中通过 JavaScript 发送 MailChimp API 请求?