Document down migrations

[felixwatts]

sqlx migrate revert --help states Revert the latest migration with a down file but its not clear what a "down file" is.

It would be helpful to either document the usage of down migrations (in README and in CLI?) or to implement #356 or both.

[jplatte]

#356 should be closed, sqlx migrate add already has a -r flag to create a set of up / down migrations.

[mammothcoding]

sqlx migrate -r add create_main_table
error: unexpected argument '-r' found

[nukiro]

@mammothcoding

sqlx migrate -r add create_main_table error: unexpected argument '-r' found

Usage: sqlx migrate add [OPTIONS]

sqlx migrate add -r create_users_table creates two files: 20241231141112_create_users_table.up.sql and 20241231141112_create_users_table.down.sql.

sqlx migrate run executes "up" files and sqlx migrate revert executes "down" ones.

[mammothcoding]

@mammothcoding

sqlx migrate -r add create_main_table error: unexpected argument '-r' found

Usage: sqlx migrate add [OPTIONS]

sqlx migrate add -r create_users_table creates two files: 20241231141112_create_users_table.up.sql and 20241231141112_create_users_table.down.sql.

sqlx migrate run executes "up" files and sqlx migrate revert executes "down" ones.

Don't work :(

sqlx migrate add -r create_main_table
Creating migrations/20250101152639_create_main_table.sql

sqlx = "0.8.2"
sqlx-cli = "0.8.2"