flask-sqlalchemy – 在错误的Flask中使用SQLAlchemy,没有这样的
发布时间:2020-12-20 12:05:58 所属栏目:Python 来源:网络整理
导读:run.py if __name__ == '__main__': config() app.run() main.py import databaseapp = Flask(__name__)def config(): app.config.from_object('config.DevConfig') # Run SQLAlchemy _that uses app.config_ and add entities if in DEBUG mode database.in
run.py
if __name__ == '__main__': config() app.run() main.py import database app = Flask(__name__) def config(): app.config.from_object('config.DevConfig') # Run SQLAlchemy _that uses app.config_ and add entities if in DEBUG mode database.init_db(app) import blueprints.auth app.register_blueprint(blueprints.auth.auth) database.py db = None def init_db(app): global db db = SQLAlchemy(app) from models import User,Interest,Event if app.config['DEBUG']: print 'Recreating all db' db.create_all() # I DO create everything print 'Loading test data' ... (here I add some Users and etc. and everything works fine - tests pass) models.py from database import db class User(db.Model): id = db.Column(db.Integer,primary_key=True) username = db.Column(db.String(80),unique=True) email = db.Column(db.String(120),unique=True) ... 蓝图/ auth.py from models import User auth = Blueprint('auth',__name__) @auth.route('/') def index(): return str(User.query.get(1).interests) 所以我明白了 OperationalError: (OperationalError) no such table: user u'SELECT user.id AS user_id,user.username AS user_username,user.email AS user_email,user.passhash AS user_passhash,user.vk_page AS user_vk_page nFROM user nWHERE user.id = ?' (1,) 我究竟做错了什么? 解决方法
为了让一切顺利,我不得不改变一些事情.
>在config中用SQLALCHEMY_DATABASE_URI参数替换DATABASE_URI 现在它工作正常. (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |