Flask-SqlAlchemy declaring models

Question

This is application.py file:

db = SQLAlchemy()
migrate = Migrate()

db.app = app
db.init_app(app)
migrate.init_app(app, db)

I find out that, I can declare model with two different ways.

from application import db


class MyModel(db.Model):
    id = db.Column(db.Integer, primary_key=True)

or

from sqlalchemy import Model, Column, Integer

class MyModel(Model):
    id = Column(Integer, primary_key=True)

Which one is right or what all these means?

There is no `Model` in vanilla SQLAlchemy. – Ilja Everilä Feb 19 '18 at 18:17 — Ilja Everilä, Feb 19 '18 at 18:17

gtalarico · Accepted Answer · 2018-02-18T17:14:02.233

They are both correct. One uses flask-sqlalchemy the other just uses 'raw' sqlalchemy.

The advantages of 'pure' sqlalchemy is that the models can more easily be used outside of the flask application.

If you are not planning on using them outside flask, just stick with the method described in the flask-sqlalchemy docs as it will save you a lot of time and effort.

Flask sqlalchemy is just a lightweight extension to make it easier to integrate sqlalchemy with flask.

Simply put, it handles the database connection code integrated with flask requests, and adds some convenient functionalities, for. Instance, access Model, Column, session, engine, and other useful sqlalchemy classes directly from the db object

I think db.Column is flask-sqlalchemy. – Gep Gecici Feb 18 '18 at 10:06 — Gep Gecici, Feb 18 '18 at 10:06

Flask-SqlAlchemy declaring models

1 Answers1