python - SQLAlchemy.exc.OperationalError : (sqlite3.OperationalError) 没有这样的表:用户
问题描述
运行.py 文件:
from flaskblog import app, db
if __name__ == '__main__':
db.create_all()
app.run(debug=True)
模型.py 文件:
from flaskblog import db
from datetime import datetime
class User(db.Model):
__tablename__ = 'user'
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(20), nullable=False)
email = db.Column(db.String(120), unique=True, nullable=False)
img_file = db.Column(db.String(20), nullable=False, default='default.jpeg')
password = db.Column(db.String(60), nullable=False)
posts = db.relationship('Post', backref='author', lazy=True)
def __repr__(self):
return f"User('{ self.username }', '{ self.email }', '{ self.img_file }')"
class Post(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(100), nullable=False)
date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
content = db.Column(db.Text, nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
def __repr__(self):
return f"User { self.title }, { self.date_posted })"
初始化.py 文件:
from flask import Flask
from flask_sqlalchemy import SQLAlchemy
from flask_bcrypt import Bcrypt
app = Flask(__name__)
app.config['SECRET_KEY'] = 'hard to guess'
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///site.db'
app.config['SQLALCHEMY_COMMIT_ON_TEARDOWN'] = True
db = SQLAlchemy(app)
bcrypt = Bcrypt(app)
from flaskblog import routes
在运行应用程序之前,我曾尝试使用终端创建表,db.create_all()
但它仍然无法正常工作。抛出以下错误:
SQLAlchemy.exc.OperationalError : (sqlite3.OperationalError) no such table: user
如果有人能解决这个问题,我将不胜感激。谢谢。
解决方案
#from flaskblog import db <- this import is wrong!
from my_project_name import db # the instancfe of SQLAlchemy that you use in your app
from datetime import datetime
class User(db.Model):
__tablename__ = 'user'
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(20), nullable=False)
email = db.Column(db.String(120), unique=True, nullable=False)
img_file = db.Column(db.String(20), nullable=False, default='default.jpeg')
password = db.Column(db.String(60), nullable=False)
posts = db.relationship('Post', backref='author', lazy=True)
def __repr__(self):
return f"User('{ self.username }', '{ self.email }', '{ self.img_file }')"
class Post(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(100), nullable=False)
date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
content = db.Column(db.Text, nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
def __repr__(self):
return f"User { self.title }, { self.date_posted })"
推荐阅读
- selenium-webdriver - 为什么显式等待正在等待整个等待时间,即使元素在等待时间结束之前可见/可点击
- zlib - 在 zlib 中,当字母的霍夫曼代码长度超过最大代码长度(15)时会发生什么?
- python-3.x - 如何将多字标题绑定到它的值从 csv 作为字典
- c++ - Qt 中的 GMock 和未定义的引用错误
- java - 在 recyclerView 制作的图像滑块中添加下一个,上一个按钮
- flask - Flask Limiter 在共享主机中不起作用
- osgi - 当我将我的功能安装到 odl 时,出现问题 aboule:zodiac.springsource.com: Name or service not known
- c# - 选择不发布所选项目
- javascript - 什么是hermes引擎(react-native)
- amazon-web-services - 将新密钥传递到 AWS CLI