bprinty / flask-continuum Goto Github PK

from flask import Flask
from flask_sqlalchemy import SQLAlchemy
from flask_continuum import Continuum

app = Flask(__name__)
db = SQLAlchemy(app)
continuum = Continuum(app, db)

from flask_continuum import VersioningMixin

# defining database schema
class Article(db.Model, VersioningMixin):
    __tablename__ = 'article'

    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    name = db.Column(db.Unicode(255))
    content = db.Column(db.UnicodeText)

$ flask shell
>>> from app import db, Article
>>> article = Article(name='Some article', content='Some content') 
>>> db.session.add(article)
>>> db.session.commit()
[...]
sqlite3.OperationalError: no such table: transaction
[...]

flask db migrate -m 'Add continuum.'
[...]
INFO  [alembic.env] No changes in schema detected.

from sqlalchemy import orm
[...]
orm.configure_mappers()

flask db migrate -m 'Add continuum.'
[...]
INFO  [alembic.autogenerate.compare] Detected added table 'transaction'
[...]

from flask import Flask
from flask_sqlalchemy import SQLAlchemy
from flask_continuum import Continuum, VersioningMixin
from flask_migrate import Migrate
from sqlalchemy import orm

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

db = SQLAlchemy(app)
continuum = Continuum(app, db)
migrate = Migrate(app, db)

class User(VersioningMixin, db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(123))                                               

orm.configure_mappers()