mobc-postgres

```rust use mobc::Error; use mobc::Pool; use mobcpostgres::tokiopostgres; use mobcpostgres::PostgresConnectionManager; use std::str::FromStr; use std::time::Instant; use tokio::prelude::*; use tokio::sync::mpsc; use tokiopostgres::Config; use tokiopostgres::Error as PostgresError; use tokiopostgres::NoTls;

const MAX: usize = 5000;

async fn simplequery( pool: Pool>, mut sender: mpsc::Sender<()>, ) -> Result<(), Error> { let conn = pool.get().await?; // let statement = conn.prepare("SELECT 1").await?; let r = conn.execute("SELECT 1", &[]).await?; asserteq!(r, 1); sender.send(()).await.unwrap(); Ok(()) }

async fn dopostgres(sender: mpsc::Sender<()>) -> Result<(), Error> { let config = Config::fromstr("postgres://jiaju:jiaju@localhost:5432")?; let manager = PostgresConnectionManager::new(config, NoTls); let pool = Pool::new(manager).await?;

for _ in 0..MAX {
    let pool = pool.clone();
    let tx = sender.clone();
    tokio::spawn(simple_query(pool, tx).map(|_| ()));
}

Ok(())

}

[tokio::main]

async fn main() { let mark = Instant::now(); let (tx, mut rx) = mpsc::channel::<()>(MAX);

if let Err(e) = do_postgres(tx).await {
    println!("some error {}", e.to_string());
}

let mut num: usize = 0;
while let Some(_) = rx.next().await {
    num += 1;
    if num == MAX {
        break;
    }
}

println!("cost {:?}", mark.elapsed());

}

```