UserWarning: Neither SQLALCHEMY_DATABASE_URI...

Question

flask_sqlalchemy报错:

F:\shop\myshop\lib\site-packages\flask_sqlalchemy\__init__.py:774: UserWarning: Neither SQLALCHEMY_DATABASE_URI nor SQLALCHEMY_BINDS is set. Defaulting SQLALCHEMY_DATABASE_URI to "sqlite:///:memory:".
  'Neither SQLALCHEMY_DATABASE_URI nor SQLALCHEMY_BINDS is set. '

我按照文档上的改成mysql+pymysql后还是报错

modles.py

from datetime import datetime
from flask import Flask
from flask_sqlalchemy import SQLAlchemy
import pymysql


app = Flask(__name__)

app.config['SQLALCHEMY_DATABASES_URI'] = 'mysql+pymysql://root:admin@127.0.0.1:3306/movie'

#app.config['SQLALCHEMY_BINDS'] = 'mysql+pymysql://root:admin@127.0.0.1:3306/movie'

app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = True

db = SQLAlchemy(app)

flask_sqlalchemy/__init__.py:

    def init_app(self, app):
        """This callback can be used to initialize an application for the
        use with this database setup.  Never use a database in the context
        of an application not initialized that way or connections will
        leak.
        """
        if (
            'SQLALCHEMY_DATABASE_URI' not in app.config and
            'SQLALCHEMY_BINDS' not in app.config
        ):
            warnings.warn(
                'Neither SQLALCHEMY_DATABASE_URI nor SQLALCHEMY_BINDS is set. '
                'Defaulting SQLALCHEMY_DATABASE_URI to "sqlite:///:memory:".'
            )

怎么解决这个问题呢？

Answer 1

犯了个低级错误,

app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql+pymysql://root:admin@127.0.0.1:3306/movie'

DATABASE写成了DATABASES

Answer 2

拼写错误。SQLALCHEMY_DATABASES_URI是错的。SQLALCHEMY_DATABASE_URI才是对的。