include-postgres-sql 0.2.2

A Yesql inspired macro for using PostgreSQL SQL in Rust
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39

use include_postgres_sql::*;

include_sql!("tests/sql/query_no_args.sql");
    
#[cfg(feature = "tokio")]
#[tokio::main]
async fn main() -> Result<(), tokio_postgres::Error> {
    use bb8_postgres::PostgresConnectionManager;
    use bb8_postgres::bb8::Pool;
    use tokio_postgres::{Config, NoTls};

    let mut config = Config::new();
    config.host("localhost").user("postgres").dbname("chinook");

    let manager = PostgresConnectionManager::new(config, NoTls);
    let pool = Pool::builder().build(manager).await?;

    let mut tasks = Vec::new();
    for _ in 0..20 {
        let pool = pool.clone();
        let task = tokio::spawn(async move {
            let conn = pool.get().await.unwrap();
            conn.get_top_artists(|row| {
                let artist_name : &str = row.try_get("artist_name")?;
                let num_albums  :  i64 = row.try_get("num_albums")?;
                println!("{artist_name}: {num_albums}");
                Ok(())
            }).await.unwrap();
        });
        tasks.push(task);
    }
    for task in tasks {
        let _ = task.await;
    }
    Ok(())
}

#[cfg(not(feature = "tokio"))]
fn main() {}