ImportError: cannot import name 'SQLALchemy' from 'flask_sqlalchemy'

Question

i am running a simple code

from flask import Flask, render_template, url_for
from flask_sqlalchemy import SQLALchemy  
from datetime import datetime

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///test.db'
db = SQLALchemy(app)

class Todo(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    content = db.Column(db.Integer, default = 0)
    data_created = db.Column(db.datetime, default=datetime.utcnow)

    def __repr__(self):
        return '<Task %r>' % self.id



@app.route("/")
def index():
    return render_template("index.html")

if __name__ == "__main__":
    app.run(debug=True)

and typing this in the terminal

python app.py

but getting error and i dont know the reason for this.

ImportError: cannot import name 'SQLALchemy' from 'flask_sqlalchemy'

Do you have a local file named `flask_alchemy.py`? Add these lines to the top of your code and show us the output: `import flask_sqlalchemy; print (flask_sqlalchemy.__file__)` — John Gordon, Mar 23 '20 at 15:28
what version of python are you running? Type `python --version` on cmd line and what do you get? — AzyCrw4282, Mar 23 '20 at 15:29
@JohnGordon i got this as output C:\Users\(My User)\OneDrive\Documents\flask\env\lib\site-packages\flask_sqlalchemy\__init__.py — Sanidhya Tyagi, Mar 23 '20 at 15:47

AzyCrw4282 · Answer 1 · 2020-03-23T15:49:25.970

0

Try the solutions below.

1st does not apply if you are using python 3.x

Your question does not have the full context, but I assume the file above is called my_app/flask_alchemy.py or similar and the directory does not contain a __init__.py file. Python needs that file to see a directory as a module that it can import from. Add an empty file called my_app/__init__.py and the problem should be solved
It looks like your issues maybe caused by the file called flask_alchemy.py within the same folder. Try deleting/renaming this file since the name of it will conflict with the real sqlalchemy module...

Edit:

I am thinking that it may be to do with how you installed it.

Try to install it with this command:

pip3 install flask-sqlalchemy

if it doesnt worked then try above commands with --user at the end of both commands

pip3 install flask-sqlalchemy --user

edited Mar 23 '20 at 15:49

answered Mar 23 '20 at 15:34

AzyCrw4282

6,391
5
15
29

1

1. doesn't apply to python3 anymore. – jordanm Mar 23 '20 at 15:35
i have 3 folders in env/lib/site-packages/ -- one is flask_sqlalchemy and another is FLASK_SQLALchemy dist info and third as sqlalchemy – Sanidhya Tyagi Mar 23 '20 at 15:42
all are different – Sanidhya Tyagi Mar 23 '20 at 15:43
without --user command output == requirement already satisfied – Sanidhya Tyagi Mar 23 '20 at 15:51
with --user command output == ERROR: Can not perform a '--user' install. User site-packages are not visible in this virtualenv. – Sanidhya Tyagi Mar 23 '20 at 15:51
Can you try [this](https://stackoverflow.com/questions/57801495/pip-wont-install-packages-in-virtualenv) first and if it doenst work follow the steps [here](https://pycbc.org/pycbc/latest/html/install_virtualenv.html) – AzyCrw4282 Mar 23 '20 at 16:01
Solved? Seems like the question is now closed, so if you do have any other problems then ask another question – AzyCrw4282 Mar 23 '20 at 16:31

ImportError: cannot import name 'SQLALchemy' from 'flask_sqlalchemy'

1 Answers1