include-oracle-sql 0.2.2

A Yesql inspired macro for using Oracle 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
40
41
42
43
44
45
46

use include_oracle_sql::*;

include_sql!("examples/dyn_query.sql");

#[cfg(not(feature = "tokio"))]
fn main() -> sibyl::Result<()> {
    let dbname = std::env::var("DBNAME").expect("database name");
    let dbuser = std::env::var("DBUSER").expect("user name");
    let dbpass = std::env::var("DBPASS").expect("password");

    let oracle = sibyl::env()?;
    let session = oracle.connect(&dbname, &dbuser, &dbpass)?;

    let from_date = sibyl::Date::with_date(2005,  1,  1, &session);
    let thru_date = sibyl::Date::with_date(2007, 12, 31, &session);
    session.median_salary(&from_date, &thru_date, &["CA", "DE", "US", "UK"], |row| {
        let country_name: &str = row.get(0)?;
        let median_salary: u16 = row.get(1)?;
        println!("{country_name:25}: {median_salary:>5}");
        Ok(())
    })?;

    Ok(())
}

#[cfg(feature = "tokio")]
#[tokio::main]
async fn main() -> sibyl::Result<()> {
    let dbname = std::env::var("DBNAME").expect("database name");
    let dbuser = std::env::var("DBUSER").expect("user name");
    let dbpass = std::env::var("DBPASS").expect("password");

    let oracle = sibyl::env()?;
    let session = oracle.connect(&dbname, &dbuser, &dbpass).await?;

    let from_date = sibyl::Date::with_date(2005,  1,  1, &session);
    let thru_date = sibyl::Date::with_date(2007, 12, 31, &session);
    session.median_salary(&from_date, &thru_date, &["CA", "DE", "US", "UK"], |row| {
        let country_name: &str = row.get(0)?;
        let median_salary: u16 = row.get(1)?;
        println!("{country_name:25}: {median_salary:>5}");
        Ok(())
    }).await?;

    Ok(())
}