This is an Oracle database driver for Rust based on ODPI-C.
Don't use this until the version number reaches to 0.1.0.
Compile-time Requirements in this document.Rust-oracle was published to crates.io. However it is old. Use rust-oracle in the github.
text
[dependencies]
oracle = { git = "https://github.com/kubo/rust-oracle.git" }
When you need to fetch or bind chrono
data types, enable chrono feature:
text
[dependencies]
oracle = { git = "https://github.com/kubo/rust-oracle.git", features = ["chrono"] }
Select a table:
```rust extern crate oracle;
fn main() { // Connect to a database. let conn = oracle::Connection::new("scott", "tiger", "//localhost/XE").unwrap(); // Select a table with a bind variable. let mut stmt = conn.execute("select ename, sal, comm from emp where deptno = :1", &[&30]).unwrap();
// Print column names
for info in stmt.column_info() {
print!(" {:14}|", info.name());
}
println!("");
// Print column types
for info in stmt.column_info() {
print!(" {:14}|", info.oracle_type().to_string());
}
println!("");
// Print column values
println!("---------------|---------------|---------------|");
while let Ok(row) = stmt.fetch() {
// get a column value by position (0-based)
let ename: String = row.get(0).unwrap();
// get a column by name (case-insensitive)
let sal: i32 = row.get("sal").unwrap();
// get a nullable column
let comm: Option<i32> = row.get(2).unwrap();
println!(" {:14}| {:>10} | {:>10} |",
ename,
sal,
comm.map_or("".to_string(), |v| v.to_string()));
}
} ```
NLS_LANG consists of three components: language, territory and charset. However the charset component is ignored and UTF-8(AL32UTF8) is used as charset because rust characters are UTF-8.
The territory component specifies numeric format, date format and so on. However it affects only conversion in Oracle. See the following example:
```rust // The territory is France. std::env::setvar("NLSLANG", "french_france.AL32UTF8"); let conn = oracle::Connection::new("scott", "tiger", "").unwrap();
// 10.1 is converted to a string in Oracle and fetched as a string. let mut stmt = conn.execute("select tochar(10.1) from dual", &[]).unwrap(); let row = stmt.fetch().unwrap(); let result: String = row.get(0).unwrap(); asserteq!(result, "10,1"); // The decimal mark depends on the territory.
// 10.1 is fetched as a number and converted to a string in rust-oracle let mut stmt = conn.execute("select 10.1 from dual", &[]).unwrap(); let row = stmt.fetch().unwrap(); let result: String = row.get(0).unwrap(); assert_eq!(result, "10.1"); // The decimal mark is always period(.). ```
Note that NLS_LANG must be set before first rust-oracle function execution if required.
Rust-oracle itself is under 2-clause BSD-style license.
ODPI-C bundled in rust-oracle is under the terms of: