Run migrations using db.create_all()

Question

I needed to write my own Trigger to be able to update some search vectors in my Postgres database and alembic/ Sqlalchemy weren't able to autogenerate these.

For that I added my custom SQL into a migrations file. Using my dev machine everything works fine. But I noticed that the trigger is created when running my tests.

For testing I use purest and tox. My conftest.py creates the database like so:

@pytest.fixture
def db(app):
    _db.app = app

    with app.app_context():
        _db.create_all()

    Role.insert_roles()  # insert roles

    yield _db  # teardown

    _db.session.close()
    _db.drop_all()

But this script only creates the raw tables. What should I change, so that my custom SQL will be executed every time a new database is created?

Thank you

score 0 · Answer 1 · answered May 29 '19 at 12:56

0

I found a solution. I added the Trigger DDL like it was suggested in this question: SQLAlchemy declarative: defining triggers and indexes (Postgres 9)

answered May 29 '19 at 12:56

Leonleon1

165
2
8

Run migrations using db.create_all()

1 Answers1