ifwenvlook 2016-03-24 12:32 采纳率: 0%
浏览 4309

web开发时sqlalchemy报错

原本运行正常的web服务,在数据库模型中加了一行之后报错:
sqlalchemy.exc.OperationalError
sqlalchemy.exc.OperationalError: (OperationalError) no such column: comments.confirmed 'SELECT count(*) AS count_1 \nFROM (SELECT comments.id AS comments_id, comments.author_id AS comments_author_id, comments.post_id AS comments_post_id, comments.confirmed AS comments_confirmed \nFROM comments \nWHERE ? = comments.post_id) AS anon_1' (104,)

用的是python内置sqlite,代码如下:

class Comment(db.Model):
tablename = 'comments'
id = db.Column(db.Integer, primary_key=True)
body = db.Column(db.Text)
body_html = db.Column(db.Text)
timestamp = db.Column(db.DateTime, index=True, default=datetime.utcnow)
disabled = db.Column(db.Boolean)
author_id = db.Column(db.Integer, db.ForeignKey('users.id'))
post_id = db.Column(db.Integer, db.ForeignKey('posts.id'))
confirmed = db.Column(db.Boolean, default=False) ##就只是加了这一行,添加后也更新过数据库模型

shell中能查到这一列:

(venv) F:\flask\flask1>python manage.py db upgrade
INFO [alembic.migration] Context impl SQLiteImpl.
INFO [alembic.migration] Will assume non-transactional DDL.

(venv) F:\flask\flask1>python manage.py shell

~~Comment.confirmed

sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x000000000436BB70>

求帮忙,自学中……(:哭

  • 写回答

3条回答 默认 最新

  • oyljerry 2016-03-24 12:36
    关注

    没有那一列,列名不正确。看配置好了没

    评论

报告相同问题?

悬赏问题

  • ¥15 delta降尺度计算的一些细节,有偿
  • ¥15 Arduino红外遥控代码有问题
  • ¥15 数值计算离散正交多项式
  • ¥30 数值计算均差系数编程
  • ¥15 redis-full-check比较 两个集群的数据出错
  • ¥15 Matlab编程问题
  • ¥15 训练的多模态特征融合模型准确度很低怎么办
  • ¥15 kylin启动报错log4j类冲突
  • ¥15 超声波模块测距控制点灯,灯的闪烁很不稳定,经过调试发现测的距离偏大
  • ¥15 import arcpy出现importing _arcgisscripting 找不到相关程序