A pure rust SQL driver for SAP HANA(TM).
Add hdbconnect to the dependencies section in your project's Cargo.toml:
toml
[dependencies]
hdbconnect = "0.22"
Assume you have a HANA (e.g. a HANA Express) accessible at port 30333 on host hxehost,
and you can log on to it as user HORST with password SECRET.
Then a first simple test might look like this:
```rust use hdbconnect::{Connection, HdbResult};
pub fn main() -> HdbResult<()> { // Get a connection let url = "hdbsql://HORST:SECRET@hxehost:39013"; let mut connection = Connection::new(url)?;
// Cleanup if necessary, and set up a test table
connection.multiple_statements_ignore_err(vec![
"drop table FOO_SQUARE"
]);
connection.multiple_statements(vec![
"create table FOO_SQUARE ( f1 INT primary key, f2 INT)",
])?;
// Insert some test data
let mut insert_stmt = connection.prepare(
"insert into FOO_SQUARE (f1, f2) values(?,?)"
)?;
for i in 0..100 {
insert_stmt.add_batch(&(i, i * i))?;
}
insert_stmt.execute_batch()?;
// Read the table data directly into a rust data structure
let stmt = "select * from FOO_SQUARE order by f1 asc";
let n_square: Vec<(i32, u64)> =
connection.query(stmt)?.try_into()?;
// Verify ...
for (idx, (n, square)) in n_square.into_iter().enumerate() {
assert_eq!(idx as i32, n);
assert_eq!((idx * idx) as u64, square);
}
Ok(())
} ```
See https://docs.rs/hdbconnect/ for the full functionality of hdbconnect.
There you also find more code examples, e.g. in the description of module code_examples.
See HANA in SCP for instructions how to obtain the necessary server certificate from a HANA in SAP Cloud Platform.
See the change log.