Set the migrations directory path

[mjovanc]

Is it possible to set the migrations directory path? I would not like to have it in the root of the cargo workspace and would like to have it in my specific crate. For example:

crates/my-db/Cargo.toml
crates/my-db/src
crates/my-db/migrations
crates/my-db/sqlx (cache files)
Cargo.toml

Also for the .sqlx directory if possible. Maybe name it just sqlx.

This would make it much better for us to have more flexible way of setting the path to that directory.

[fstephany]

I don't know if that answers your question but you can specify the migrations directory path when you use the sqlx cli: cargo sqlx migrate run --source <path/to/migration/folder>

[mjovanc]

Yes, but what about when doing sqlx prepare? Then that doesnt work it seems.

[fstephany]

I don't think the sqlx prepare command needs to know the migration directory, does it? I've checked my scripts and I use cargo sqlx prepare --workspace -- --tests to generate my sqlx metadata file.