Can't clone sqlx::Pool

[stanley355]

Hi, I'm trying to clone the sqlx::Pool and I saw that the function exists on the docs.

However, when I conduct the clone() I got the following error:

And here's my code:

use actix_web::{web, App, HttpServer};
use sqlx::Pool;
use sqlx::postgres::Postgres;

mod shorten;

#[actix_web::main]
async fn main() -> std::io::Result<()> {
    dotenv().ok();

    let pool = Pool::<Postgres>::connect(&env::var("PG_URL").unwrap()).await;
    let address = format!(
        "{}:{}",
        &env::var("HOST").unwrap_or("127.0.0.1".to_string()),
        &env::var("PORT").unwrap_or("8080".to_string())
    );

    HttpServer::new(|| {
        App::new().service(
            web::scope("/api")
                .data(pool.clone()) --> The issue is here
                .route("/v1", web::post().to(shorten::shorten_url)) 
        )
    })
    .bind(address)?
    .run()
    .await
}

Anybody having similar issue? I've been searching on Google yet couldn't find similar context
Thanks

[abonander]

Have a look at this line in your code:

    let pool = Pool::<Postgres>::connect(&env::var("PG_URL").unwrap()).await;

connect() is an async fn returning sqlx::Result<Pool>. You have to extract the Pool from that Result to use it.

The Rust Programming Language book has a chapter on this: https://doc.rust-lang.org/book/ch09-02-recoverable-errors-with-result.html

[stanley355]

Ah I see, it works now by working on the function below, thanks:

    let client = match PgPool::connect(&env::var("PG_URL").unwrap()).await {
        Ok(pool) => pool,
        Err(err) => println!("Can't connect to PG_POOl: {:?}", err),
    };