Cannot run migration with migrate! macro

[esemeniuc]

When running sqlx::migrate!("migrations").run(&conn).await?;, I get this output:

error: paths relative to the current file's directory are not currently supported
  --> src/db.rs:24:20
   |
24 |     sqlx::migrate!("migrations").run(&conn).await?;
   |                    ^^^^^^^^^^^^

I get this result on rust 1.47 and 1.49 nightly. This is my Cargo.toml entry: sqlx = { version = "0.4.0-beta.1", features = [ "macros", "sqlite", "chrono", "migrate" ] }

Running sqlx::migrate!("/").run(&conn).await?; results in

error: absolute paths will only work on the current machine
  --> src/db.rs:24:20
   |
24 |     sqlx::migrate!("/").run(&conn).await?;
   |                    ^^^

All my work is based on this documentation: https://docs.rs/sqlx/0.4.0-beta.1/sqlx/macro.migrate.html

[abonander]

Try sqlx::migrate!("./migrations")

[ghost]

sqlx::migrate!("./migrations") gives me:

error: invalid digit found in string
  --> database/src/postgres.rs:29:9
   |
29 |         sqlx::migrate!("./migrations")
   |         ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

[izik1]

Could we get a list of your migration file names?

[abonander]

error: invalid digit found in string

Are you on Windows? That would explain that error. I thought we were normalizing paths for the OS though.

[ghost]

Was using a non integer prefix for the migration file. Thanks

[izik1]

I think I'm going to close this, perhaps another issue should be opened to make the migration naming format more obvious?

[izik1]

wait a second, got a mixup, uhh, @esemeniuc is everything okay on your end?

[esemeniuc]

It works with sqlx::migrate!();, thank you :)

[ketzu]

Try sqlx::migrate!("./migrations")

Thank you, from the documentation it was somewhat confusing to figure out that:

• sqlx::migrate!("migrations") is treated as a relative path to the cwd and refused
• sqlx::migrate!("./migrations") is treated as a relative path to the root and accepted
• sqlx::migrate!("db/migrations") is treated as a relative path to the root and accepted (the example from the documentation)

[your-diary]

The documentation uses

#[sqlx::test(migrations = "foo_migrations")]

, which doesn't work due to the reason discussed in this issue.