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

#[cfg(not(feature = "tokio"))]
mod test {
    use include_postgres_sql::{include_sql, impl_sql};
    use postgres::{Config, NoTls, Error, fallible_iterator::FallibleIterator};
    
    include_sql!("tests/sql/query_with_gen_args_into_rows.sql");
    
    #[test]
    fn impl_method_with_params() -> Result<(), Error> {
        let mut db = Config::new()
            .host("localhost")
            .user("postgres")
            .dbname("chinook")
            .connect(NoTls)?
        ;
    
        let mut row_num = 0;
        let mut rows = db.get_top_sales("London", 2i64)?;
        while let Some(row) = rows.next()? {
            let artist_name : &str = row.try_get("artist_name")?;
            let track_name  : &str = row.try_get("track_name")?;
            let num_sold    :  i64 = row.try_get("num_sold")?;
            
            assert_eq!(artist_name, "Cidade Negra");
            assert_eq!(track_name, "Firmamento");
            assert_eq!(num_sold, 2);
    
            row_num += 1;
        }
        assert_eq!(row_num, 1);
    
        Ok(())
    }
}