Change Log

Compile-time Requirements

Run-time Requirements

Supported Rust Versions

Usage

[dependencies]oracle = "0.6.3"

Optional Features

Examples

use oracle::{Connection,Error};// Connect to a database.let conn =Connection::connect("scott","tiger","//localhost/XE")?;let sql ="select ename, sal, comm from emp where deptno = :1";// Select a table with a bind variable.println!("---------------|---------------|---------------|");let rows = conn.query(sql,&[&30])?;for row_resultin rows{let row = row_result?;// get a column value by position (0-based)let ename:String = row.get(0)?;// get a column by name (case-insensitive)let sal:i32 = row.get("sal")?;// Use `Option<...>` to get a nullable column.// Otherwise, `Err(Error::NullValue)` is returned// for null values.let comm:Option<i32> = row.get(2)?;println!(" {:14}| {:>10}    | {:>10}    |",             ename,             sal,             comm.map_or("".to_string(), |v| v.to_string()));}// Another way to fetch rows.// The rows iterator returns Result<(String, i32, Option<i32>)>.println!("---------------|---------------|---------------|");let rows = conn.query_as::<(String,i32,Option<i32>)>(sql,&[&10])?;for row_resultin rows{let(ename, sal, comm) = row_result?;println!(" {:14}| {:>10}    | {:>10}    |",             ename,             sal,             comm.map_or("".to_string(), |v| v.to_string()));}#Ok::<(), oracle::Error>(())

use oracle::Connection;// Connect to a database.let conn =Connection::connect("scott","tiger","//localhost/XE")?;let sql ="select ename, sal, comm from emp where empno = :1";// Print the first row.let row = conn.query_row(sql,&[&7369])?;let ename:String = row.get("empno")?;let sal:i32 = row.get("sal")?;let comm:Option<i32> = row.get("comm")?;println!("---------------|---------------|---------------|");println!(" {:14}| {:>10}    | {:>10}    |",         ename,         sal,         comm.map_or("".to_string(), |v| v.to_string()));// When no rows are found, conn.query_row() returns `Err(Error::NoDataFound)`.// Get the first row as a tupplelet row = conn.query_row_as::<(String,i32,Option<i32>)>(sql,&[&7566])?;println!("---------------|---------------|---------------|");println!(" {:14}| {:>10}    | {:>10}    |",         row.0,         row.1,         row.2.map_or("".to_string(), |v| v.to_string()));#Ok::<(), oracle::Error>(())

use oracle::Connection;// Connect to a database.let conn =Connection::connect("scott","tiger","//localhost/XE")?;conn.execute("create table person (id number(38), name varchar2(40))",&[])?;// Execute a statement with positional parameters.conn.execute("insert into person values (:1, :2)",&[&1,// first parameter&"John"// second parameter])?;// Execute a statement with named parameters.conn.execute_named("insert into person values (:id, :name)",&[("id",&2),// 'id' parameter("name",&"Smith"),// 'name' parameter])?;// Commit the transaction.conn.commit()?;// Delete rowsconn.execute("delete from person",&[])?;// Rollback the transaction.conn.rollback()?;#Ok::<(), oracle::Error>(())

use oracle::Connection;// Connect to a database.let conn =Connection::connect("scott","tiger","//localhost/XE")?;let sql ="select ename, sal, comm from emp where 1 = 2";let rows = conn.query(sql,&[])?;// Print column namesfor infoin rows.column_info(){print!(" {:14}|", info.name());}println!("");// Print column typesfor infoin rows.column_info(){print!(" {:14}|", info.oracle_type().to_string());}println!("");#Ok::<(), oracle::Error>(())

use oracle::Connection;let conn =Connection::connect("scott","tiger","//localhost/XE")?;// Create a prepared statementletmut stmt = conn.statement("insert into person values (:1, :2)").build()?;// Insert one rowstmt.execute(&[&1,&"John"])?;// Insert another rowstmt.execute(&[&2,&"Smith"])?;#Ok::<(), oracle::Error>(())

NLS_LANG parameter

use oracle::Connection;// The territory is France.std::env::set_var("NLS_LANG","french_france.AL32UTF8");let conn =Connection::connect("scott","tiger","")?;// 10.1 is converted to a string in Oracle and fetched as a string.let result = conn.query_row_as::<String>("select to_char(10.1) from dual",&[])?;assert_eq!(result,"10,1");// The decimal mark depends on the territory.// 10.1 is fetched as a number and converted to a string in rust-oraclelet result = conn.query_row_as::<String>("select 10.1 from dual",&[])?;assert_eq!(result,"10.1");// The decimal mark is always period(.).#Ok::<(), oracle::Error>(())

TODO

Related Projects

License