How can I disable logging?

[jlkiri]

sqlx::query logs every query in my terminal, but how can I disable it? It may be relevant that I use tide and its logging middleware.

[Xide]

Hey !

Here is the implementation i am using to do this (with MySQL, but the same should be usable with other backends):

use sqlx::mysql::{MySqlPool, MySqlPoolOptions, MySqlConnectOptions};
use std::str::FromStr;
use std::time::Duration;
use sqlx::ConnectOptions;

pub async fn connect(url: &str) -> Result<(), sqlx::Error> {
        let mut connection_options = MySqlConnectOptions::from_str(url)?;
        connection_options
            .log_statements(log::LevelFilter::Debug)
            .log_slow_statements(log::LevelFilter::Warn, Duration::from_secs(1));
        let pool = MySqlPoolOptions::new()
            .connect_with(connection_options)
            .await?;
        Ok(())
}

Here is the documentation of those functions : https://docs.rs/sqlx/0.5.1/sqlx/trait.ConnectOptions.html
You can also use the disable_statement_logging method of the connection_options to disable all log statements.

[jlkiri]

Oh, thanks! I didn't notice this option!