Running migrations in single transaction

[jalorenz94]

Hi everyone,

first of all, thanks a lot for the library :) Is there any chance to run the pending migrations umzug.up() in a single transaction? Currently, i build some logic around it, with the drawback that i have to remove the processed migrations from the SequelizeMeta table when the transaction was roll backed.

[mmkal]

This can be done with the 'beforeCommand'/'afterCommand' events, but locking varies pretty widely between databases so it might be tricky to do via sequelize. @slonik/migrator is postgres-only, based on umzug and allows running all migrations in a single transaction this way.