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

#[cfg(feature = "tokio")]
mod test {
    use include_postgres_sql::{ include_sql, impl_sql };
    use tokio_postgres::{Config, NoTls};

    include_sql!("tests/sql/dml_returning.sql");

    #[tokio::test]
    async fn impl_method_returning_row() -> Result<(),tokio_postgres::Error> {
        let (mut db, conn) = Config::new()
            .host("localhost")
            .user("postgres")
            .dbname("chinook")
            .connect(NoTls).await?;

        tokio::spawn(async move {
            if let Err(e) = conn.await {
                eprintln!("connection error: {}", e);
            }
        });

        let tr = db.transaction().await?;
        let res = tr.new_genre("New Age").await?;
        let new_id = res.try_get("genre_id")?;
        assert!(new_id > 0);
        tr.delete_genre(new_id).await?;
        tr.rollback().await?;

        Ok(())
    }
}