SQLx CLI: cargo sqlx prepare with SQLite doesn't do anything

[tobymurray]

Following the documentation here, I'm trying to create my sqlx-data.json but SQLx does not appear to find any of my queries.

I've just started using SQLx with SQLite, so I'm not sure if I'm doing something unexpected but I think it's a pretty mundane project. I have a handful of queries that generally look something like:

sqlx::query!(
  "
  UPDATE products
  SET deleted = TRUE
  WHERE store_name = $1
  ",
  store_name,
)
.fetch_all(db)
.await?;

Running the application works fine, I get errors when I build if the schema doesn't line up. Trying to build the file does not appear to do anything with either environment variables in a .env nor provided directly:

$ SQLX_OFFLINE=true DATABASE_URL=sqlite://sqlite/production.db cargo sqlx prepare
   Compiling project-name v0.1.0 (/home/toby/git/rust/project-name)
    Finished dev [unoptimized + debuginfo] target(s) in 9.55s
warning: no queries found; please ensure that the `offline` feature is enabled in sqlx
query data written to `sqlx-data.json` in the current directory; please check this into version control

Yields a sqlx-data.json:

{
  "db": "SQLite"
}

Am I missing something obvious?

• SQLx: 0.5.13
• cargo-sqlx 0.5.13
• SQLite3: 3.31.1
• libsqlite3-sys: 0.24.2

[tobymurray]

Has no effect unless the offline feature of sqlx is enabled in your project. Omitting that feature is the most likely cause if you get a sqlx-data.json file that looks like this:

I misunderstood this, I thought SQLX_OFFLINE=true was enabling the offline feature (feature as in "functionality") but "offline feature" in this context means a Cargo feature (as in specified in Cargo.toml).

Adding offline so my Cargo.toml looks like

sqlx = { version = "0.5", features = [ "runtime-tokio-native-tls" , "sqlite", "chrono", "offline" ] }

yields a populated file.