Sibyl

Sibyl is an OCI-based interface between Rust applications and Oracle databases. Sibyl supports both sync (blocking) and async (nonblocking) API.

MIT

Example

Blocking Mode

```rust use sibyl as oracle; // pun intended :)

fn main() -> Result<(),Box> { let oracle = oracle::env()?;

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 session = oracle.connect(&dbname, &dbuser, &dbpass)?;
let stmt = session.prepare("
    SELECT first_name, last_name, hire_date
      FROM hr.employees
     WHERE hire_date >= :hire_date
  ORDER BY hire_date
")?;
let date = oracle::Date::from_string("January 1, 2005", "MONTH DD, YYYY", &session)?;
let rows = stmt.query(&date)?;
while let Some( row ) = rows.next()? {
    let first_name : Option<&str>  = row.get(0)?;
    let last_name  : &str          = row.get_not_null(1)?;
    let hire_date  : oracle::Date  = row.get_not_null(2)?;

    let hire_date = hire_date.to_string("FMMonth DD, YYYY")?;
    if first_name.is_some() {
        println!("{}: {} {}", hire_date, first_name.unwrap(), last_name);
    } else {
        println!("{}: {}", hire_date, last_name);
    }
}
if stmt.row_count()? == 0 {
    println!("No one was hired after {}", date.to_string("FMMonth DD, YYYY")?);
}
Ok(())

} ```

Nonblocking Mode

```rust use sibyl as oracle;

[tokio::main]

async fn main() -> Result<(),Box> { let oracle = oracle::env()?;

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 session = oracle.connect(&dbname, &dbuser, &dbpass).await?;
let stmt = session.prepare("
    SELECT first_name, last_name, hire_date
      FROM hr.employees
     WHERE hire_date >= :hire_date
  ORDER BY hire_date
").await?;
let date = oracle::Date::from_string("January 1, 2005", "MONTH DD, YYYY", &oracle)?;
let rows = stmt.query(&date).await?;
while let Some( row ) = rows.next().await? {
    let first_name : Option<&str>  = row.get(0)?;
    let last_name  : &str          = row.get_not_null(1)?;
    let hire_date  : oracle::Date  = row.get_not_null(2)?;

    let hire_date = hire_date.to_string("FMMonth DD, YYYY")?;
    if first_name.is_some() {
        println!("{}: {} {}", hire_date, first_name.unwrap(), last_name);
    } else {
        println!("{}: {}", hire_date, last_name);
    }
}
if stmt.row_count()? == 0 {
    println!("No one was hired after {}", date.to_string("FMMonth DD, YYYY")?);
}
Ok(())