Execute migration in transaction

[gleb-chipiga]

Motivation

I think that in case of an error during the migration, it will be useful to automatically restore the database to a previous consistent state. Thus, a failed migration will not affect the operation of the application.

Proposed Solutions

To do this, we need to run the migration and update the seaql_migrations table in a transaction.

[billy1624]

Hey @gleb-chipiga, I think it's hard to achieve "atomic migration" because not all database engine support it. Please check previous discussion at #1059

[gleb-chipiga]

In sqlx, atomic migrations are supported at least for PostgreSQL. Although the set of database engines there is more than in SeaORM. I think the sqlx approach can be applied to SeaORM as well.

[billy1624]

Hey @gleb-chipiga, tracking issue #1378