To see all available options for these commands, use the
flag, for example
piccolo migrations forwards --help.
To see the SQL queries of a migration without actually running them , use the
flag, for example:
piccolo migrations forwards my_app --preview or
piccolo migrations backwards 2018-09-04T19:44:09 --preview.
When the migration is run, the forwards function is executed. To do this:
piccolo migrations forwards my_app
To reverse the migration, run the following command, specifying the ID of a migration:
piccolo migrations backwards my_app 2018-09-04T19:44:09
Piccolo will then reverse the migrations for the given app, starting with the most recent migration, up to and including the migration with the specified ID.
You can try going forwards and backwards a few times to make sure it works as expected.
You can easily check which migrations have and haven’t ran using the following:
piccolo migrations check