error: DATABASE_URL must be set to use query macros

[Rustixir]

I Build a pool

let db_options = SqliteConnectOptions::from_str("sqlite::memory:")?
    .journal_mode(SqliteJournalMode::Wal)
    .statement_cache_capacity(53)
    .busy_timeout(Duration::from_secs(30));

let pool = SqlitePoolOptions::new()
    .max_connections(3)
    .connect_with(db_options)
    .await?;


let runtime = Runtime::new(pool).await; 

This error raised : DATABASE_URL must be set to use query macros
for this query

    let mut conn = self.pool.acquire().await;

    sqlx::query!("INSERT INTO country (id, name_fa, name_en) VALUES (?1, ?2, ?3)",
          newId , req.name_fa, req.name_en).execute(&mut conn).await?; 

Where is my problem ??

[marshoepial]

From the readme:

The DATABASE_URL environment variable must be set at build time to a database which it can prepare queries against; the database does not have to contain any data but must be the same kind (MySQL, Postgres, etc.) and have the same schema as the database you will be connecting to at runtime.

For convenience, you can use a .env file to set DATABASE_URL so that you don't have to pass it every time:

DATABASE_URL=mysql://localhost/my_database

For Sqlite, you need to set the DATABASE_URL environment variable to the path towards your database file before building.