Separate SQLAlchemy models by file in Flask


Question

Many examples for Flask apps that I have seen have the models stored directly in the main app file (http://pythonhosted.org/Flask-SQLAlchemy/quickstart.html, http://maximebf.com/blog/2012/10/building-websites-in-python-with-flask/). Other ones (http://flask.pocoo.org/docs/patterns/sqlalchemy/) have a "models.py" file in which models are placed.

How can I have my Flask app import models from separate files, e.x. "User.py"? When I try creating a User.py file with these contents:

from app import db

class User(db.Model):
    [...]

I get the following error:

File "/Users/stackoverflow/myapp/models/User.py", line 1, in <module>
from app import db
ImportError: No module named app

When I insert from models import User in my module file.

1
32
2/9/2013 3:37:17 PM

Accepted Answer

This answer was extremely helpful: https://stackoverflow.com/a/9695045/353878.

I needed to not initialize the db right away.

24
5/23/2017 11:54:09 AM

Licensed under: CC-BY-SA with attribution
Not affiliated with: Stack Overflow
Icon