Add support for migrations in sqlmodel

[rajiknows]

Currently alembic only supports the models written in SqlAlchemy , there is some hack around making it compatible with sqlmodel

reference : https://stackoverflow.com/questions/68932099/how-to-get-alembic-to-recognise-sqlmodel-database-model

we can integrate it to alembic itself with a configuration parameter for e.g sqlmodel = true
and generate migrations accordingly .....

[CaselIT]

Hi,

I don't see what that flag would be supported to do. The metadata used by sqlmodel needs to be provided to alembic by modifying the env.py, but that's the same as when using sqlalchemy directly

[rajiknows]

hey , i apologise for the inconvenience , i should have checked the hack around , also it would have been good ux to just ship with import sqlmodel if the model are using sqlmodel....

[CaselIT]

how does alembic know that the model are using sqlmodel?

[zzzeek]

No modifications to alembic are needed to support SQLmodel, the stackoverflow post shows ordinary changes to the env.py file to locate the metadata collection.

SQLModel can provide out of the box integration for this by providing a custom template. See flask-sqlalchemy for how this can be done