Flask migrations

[LeoJavaAI]

I am not sure how I can use flask-migrate and alembic to generate migrations which create the functions and triggers. I have done this manually but is there a way to automate via migrations? Also the tsvector type is available in sqlalchemy-util, I have to manually add it to the migrations file, How can this be done automatically when i run "db migrate"

[kvesteri]

I've been doing this manually myself. Better support for alembic would be awesome.

[siddhantgoel]

I've been doing this manually myself.

Do you just run sql_expressions in alembic's env.py? I was thinking of doing that before the context.run_migrations() call but thought I'll check first what people here are doing/recommend.

[kvesteri]

I run the expressions in a migration file. Also if the expressions change (for example the latest version of SA-Searchable changed those) then they need to be run again using a separate migration.