elephantry 5.1.1

Object model manager for PostgreSQL
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
40
41
42
43

mod employee {
    #[derive(Debug, elephantry::Entity)]
    pub struct Entity {
        pub employee_id: i32,
        pub first_name: String,
        pub last_name: String,
        pub birth_date: chrono::NaiveDate,
        pub is_manager: bool,
        pub day_salary: bigdecimal::BigDecimal,
        pub department_id: i32,
    }
}

fn main() -> elephantry::Result {
    smol::block_on(async {
        let database_url =
            std::env::var("DATABASE_URL").unwrap_or_else(|_| "postgres://localhost".to_string());
        let elephantry = elephantry::Pool::new(&database_url)?;

        elephantry
            .r#async()
            .execute(include_str!("structure.sql"))
            .await?;

        let employees = elephantry
            .r#async()
            .query::<employee::Entity>("select * from employee", &[])
            .await?;

        for employee in employees {
            dbg!(employee);
        }

        let total_salary = elephantry
            .r#async()
            .query_one::<bigdecimal::BigDecimal>("select sum(day_salary) from employee", &[])
            .await?;

        dbg!(total_salary);

        Ok(())
    })
}