Flask开发中遇到Foreign key associated with column 'users
发布时间:2020-12-17 17:03:30 所属栏目:Python 来源:网络整理
导读:代码: import?osfrom?flask_sqlalchemy?import?SQLAlchemyapp.config['SECRET_KEY']?=?'hard?to?guess?string'app.config['SQLALCHEMY_DATABASE_URI']?=????"sqlite:///"?+?os.path.join(basedir,?"data.sqlite")app.config['SQLALCHEMY_COMMIT_ON_TEARDOWN
代码: import?os from?flask_sqlalchemy?import?SQLAlchemy app.config['SECRET_KEY']?=?'hard?to?guess?string' app.config['SQLALCHEMY_DATABASE_URI']?= ????"sqlite:///"?+?os.path.join(basedir,?"data.sqlite") app.config['SQLALCHEMY_COMMIT_ON_TEARDOWN']?=?True basedir?=?os.path.abspath(os.path.dirname(__name__)) db?=?SQLAlchemy(app) class?Role(db.Model): ????__tablename__?="roles" ????id?=?db.Column(db.Integer,?primary_key=True) ????name?=?db.Column(db.String(64),unique=True) ????users?=?db.relationship('User',?backref='role') ????def?__repr__(self): ????????return?"<Role?%r>"?%?self.name ???????? class?User(db.Model): ????__tablename__?=?"users" ????id?=?db.Column(db.Integer,?primary_key=True) ????username?=?db.Column(db.String(64),?unique=True,?index=True) ????role_id?=?db.Column(db.Integer,?db.ForeignKey("role.id")) 更改代码: db.ForeignKey("role.id")中role少了一个s,且role是不存在这个表 role_id?=?db.Column(db.Integer,?db.ForeignKey("roles.id")) (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |