Could not load the module

Question

I am new to Python and Flask module. I got an error after running my code. My code look like this:

from flask import Flask, render_template, url_for
from sqlalchemy import sql
from datetime import datetime

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

class Todo(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    content = db.Column(db.String(200), nullable=False)
    date_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)

I need to proceed this code to create a website. However, I got an error from line 7, that is:

TypeError: 'module' object is not callable

Selcuk · Accepted Answer · 2019-07-31 03:41:50Z

2

You should not directly use the sqlalchemy package (and you are doing it wrong, anyway). The correct way of using SQLAlchemy with Flask is:

from flask_sqlalchemy import SQLAlchemy
...
db = SQLAlchemy(app)

edited Jul 31, 2019 at 3:41

answered Jul 31, 2019 at 3:28

Selcuk

60.1k12 gold badges113 silver badges118 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Selcuk Over a year ago

@LAI In that case simply use flask_sqlalchemy. I have updated the answer. You should install it using pip if you haven't already done so: flask-sqlalchemy.palletsprojects.com/en/2.x

Selcuk Over a year ago

@LAI It is flask-sqlalchemy (with a dash instead of an underscore). Please also read the documentation as we can't provide all the information here as comments.

LAI Over a year ago

For your information @Selcuk, I still cannot install the module by using the command. Any solution can solve it? Is it version problem or anything?

Selcuk Over a year ago

It is certainly on PyPI. You must be doing something wrong. Double check your command: pypi.org/project/Flask-SQLAlchemy

everfight · Accepted Answer · 2019-07-31 03:34:41Z

You can change your code like this, use flask_sqlalchemy

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

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

class Todo(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    content = db.Column(db.String(200), nullable=False)
    date_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)

My Flask library don't have this flask_sqlalchemy module, I have tried this way before, but still cannot work.
OK, another answer is quite good, I think that is just the right answer you want.

Collectives™ on Stack Overflow

Could not load the module

2 Answers 2

4 Comments

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

2 Comments

Related