SQLAlchemy create_all() does not create tables

by

You should put your model class before create_all() call, like this:

from flask import Flask
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)

app.config['SQLALCHEMY_DATABASE_URI'] = 'postgresql+psycopg2://login:pass@localhost/flask_app'
db = SQLAlchemy(app)

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(80), unique=True)
    email = db.Column(db.String(120), unique=True)

    def __init__(self, username, email):
        self.username = username
        self.email = email

    def __repr__(self):
        return '<User %r>' % self.username

db.create_all()
db.session.commit()

admin = User('admin', '[email protected]')
guest = User('guest', '[email protected]')
db.session.add(admin)
db.session.add(guest)
db.session.commit()
users = User.query.all()
print users

If your models are declared in a separate module, import them before calling create_all().

Say, the User model is in a file called models.py,

from flask import Flask
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)

app.config['SQLALCHEMY_DATABASE_URI'] = 'postgresql+psycopg2://login:pass@localhost/flask_app'
db = SQLAlchemy(app)

# See important note below
from models import User

db.create_all()
db.session.commit()

admin = User('admin', '[email protected]')
guest = User('guest', '[email protected]')
db.session.add(admin)
db.session.add(guest)
db.session.commit()
users = User.query.all()
print users

Important note: It is important that you import your models after initializing the db object since, in your models.py _you also need to import the db object from this module.

More Related Contents:

  1. How to write DataFrame to postgres table
  2. CS50: LIKE operator, variable substitution with % expansion
  3. Executing multiple statements with Postgresql via SQLAlchemy does not persist changes
  4. How to create an SQL View with SQLAlchemy?
  5. Generate sql with subquery as a column in select statement using SQLAlchemy
  6. Updates to JSON field don’t persist to DB
  7. Complex foreign key constraint in SQLAlchemy
  8. Connection problems with SQLAlchemy and multiple processes
  9. How to upsert pandas DataFrame to PostgreSQL table?
  10. SQLAlchemy multiple foreign keys in one mapped class to the same primary key
  11. sqlalchemy.exc.NoSuchModuleError: Can’t load plugin: sqlalchemy.dialects:postgres
  12. SQLAlchemy – performing a bulk upsert (if exists, update, else insert) in postgresql
  13. Strange SQLAlchemy error message: TypeError: ‘dict’ object does not support indexing
  14. Creating partial unique index with sqlalchemy on Postgres
  15. SQLAlchemy func.count on boolean column
  16. How to set connection timeout in SQLAlchemy
  17. SQLAlchemy: filtering on values stored in nested list of the JSONB field
  18. How to prevent UUID primary key for new SQLAlchemy objects being created with the same value
  19. Does SQLAlchemy have an equivalent of Django’s get_or_create?
  20. SQLAlchemy: What’s the difference between flush() and commit()?
  21. Group by & count function in sqlalchemy
  22. Debugging (displaying) SQL command sent to the db by SQLAlchemy
  23. Case insensitive unique model fields in Django?
  24. python adds “E” to string
  25. Django-DB-Migrations: cannot ALTER TABLE because it has pending trigger events
  26. python pandas to_sql with sqlalchemy : how to speed up exporting to MS SQL?
  27. SQLAlchemy classes across files
  28. “Failed building wheel for psycopg2” – MacOSX using virtualenv and pip
  29. How can I achieve a self-referencing many-to-many relationship on the SQLAlchemy ORM back referencing to the same attribute?
  30. flask sqlalchemy query with keyword as variable

Leave a Comment