Let Evolve Run some custom bash or powershell script

guy-lud commented 5 years ago

Hi,

I know that Evolve is mainly for DB migration, yet some times there is need to execute some code (via script or what ever) once as part of a migration.

I think it would be nice feature in Evolve.

WDYT ?

lecaillon commented 5 years ago

I don't know, not sure about it. Can you give me a example, which can lead to a more precise need ?

majkinetor commented 5 years ago

This would be great to have for multiple reasons.

There might be some specific things to do during the migration that are not easily done without a script and are easy enought to do in script without fireing up full blown programming language and IDE.

Examples:

Export of existing data into some format before migration destroys it.
Full or partial database backup and restore
Sending migration metrics to specific server
Making sure some arbitrary prerequisites are in check before migration kicks off like number of users online, CPU usage on db server etc.

All above could be done in just several lines of shell script.

Furthremore, being able to just ad ad hoc stuff into Powershell script along with migration would be epic, likely with an easy way to access migration config such as db name and service (via script parameters, env. vars etc.).

Options could include:

Is script run only if there are no newer migrations or always
Hooks to run set of scripts before/after each migration and all migrations

I honestly wouldn't consider using migration tool without such thing and if doesn't exist I would create shell wrapper of the original tool that provides such behavior on top of it, however, that is certainly less capable solution then integrated one.

mfedatto commented 4 years ago

Well, I can't see why it should be considered a part of a migration process, but I understand it would be awesome to have a tool analog to a migration to run shell scripts.

lecaillon commented 3 years ago

I'm finally thinking about adding this kind of feature to Evolve. Give the possibility to run powershell on Windows, Bash on Linux at some specific points of the Evolve execution workflow. Something like :

OnMigrateStarting.ps1/sh : when Evolve runs a migrate command
OnMigrateValidated.ps1/sh : after Evolve successfully validates its pre-requisites
OnMigrating.ps1/sh : before each execution of a migration
OnMigrated.ps1/sh: after each execution of a migration
OnErrorMigrating.ps1/sh: when a migration fails
OnMigrateEnded.ps1/sh: when Evolve ends a migrate command

If you have any idea about this subject, don't hesitate to post a comment

lecaillon / Evolve

Let Evolve Run some custom bash or powershell script #92