Why do I have to change the uri in Flask for SQLAlchemy?
I'm a little unclear what you're asking, where you're setting this DATABASE value and where the flaskr.json value is coming from. But I'll give it a shot, and hopefully it'll be of some use.
So, obviously, you need to tell your app how to connect to your database. You generally set this up in the app configuration like so:
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:////tmp/test.db'For SQLlite, you just need a file path (as above) For MySQL, I have our app set up like so:
app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql+pymysql://username:password@server.site.com/database'You can read way more than you ever wanted to know about this in the SQLAlchemy docs:
http://docs.sqlalchemy.org/en/latest/core/engines.html#database-urls
Also, have you looked at the Flask-SQLAlchemy plugin? It gives you some nice tools to work with this.
http://flask-sqlalchemy.pocoo.org/2.3/quickstart/#a-minimal-application
For windows use this
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///E:\\account-verification-flask\\src\\example.db'# sqlite:///absolute pathFor more information. visit here