mysql database uri,未设置SQLALCHEMY_DATABASE_URI

I tried to work with CURD operation using Flask and SQLAlchemy.But getting Error while connecting to database.

Here is the Error log.

/usr/local/lib/python3.4/dist-packages/flask_sqlalchemy/__init__.py:819: UserWarning: SQLALCHEMY_DATABASE_URI not set. Defaulting to "sqlite:///:memory:".

'SQLALCHEMY_DATABASE_URI not set. Defaulting to '

/usr/local/lib/python3.4/dist-packages/flask_sqlalchemy/__init__.py:839: FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.

'SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and '

here is my code & setup

# database.py

from flask import Flask

from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)

sqldb = SQLAlchemy(app)

app.config['SQLALCHEMY_DATABASE_URI'] = "mysql+pymysql://root:root@localhost/myDbName"

# create app

def create_app():

sqlDB = SQLAlchemy(app)

sqlDB.init_app(app)

sqlDB.create_all()

return app

here is models.py

from ..database import create_app

sqldb = create_app()

# Users Model

class Users(sqldb.Model):

__tablename__ = 'users'

id = sqldb.Column(sqldb.Integer, primary_key = True)

db = sqldb.Column(sqldb.String(40))

def __init__(self,email,db):

self.email = email

self.db = db

def __repr__(self,db):

return '' % self.db

here is routes.py

# Import __init__ file

from __init__ import app

import sys

# JSON

from bson import dumps

# login

@app.route('/', methods = ['GET'])

def login():

try:

# import users model

from Model.models import Users,sqldb

sqldb.init_app(app)

sqldb.create_all()

getUser = Users.query.all()

print(getUser)

return 'dsf'

except Exception as e:

print(e)

return "error."

解决方案

You probably need to put this line app.config['SQLALCHEMY_DATABASE_URI'] = "mysql..." before the SQLAlchemy(app) instanciation.

Another option is to create SQLAlchemy() without parametters, to configure URI, and finally to tell SQLAlchemy to link with your app via sqldb.init_app(app)

Note that it is what you've done in your create_app function, but you never use it ?