How to run up/down migration before service starts?

[shengchaohua]

Hi, all

We put the migration sql files in our codebase and they are embed into our program. We just add a command flag migrate into our main function, so that the up migrate can be run before our service starts.

The question is that we can not run down migration when our service needs downgrade, because the downgraded docker image (golang binary) does not have the corresponding migration files.

For example, the program is v1.0, then we upgrade it v1.1 and do some up migrates. Once we downgrade to v1.0, the docker images of v1.0 doesnot have the migration files.

Does anyone has any idea?