Crates.io | hdbconnect_async |
lib.rs | hdbconnect_async |
version | 0.28.6 |
source | src |
created_at | 2023-02-02 16:07:22.392092 |
updated_at | 2024-06-12 18:18:10.863121 |
description | An asynchronous pure rust database driver for SAP HANA(TM) |
homepage | |
repository | https://github.com/emabee/rust-hdbconnect |
max_upload_size | |
id | 774891 |
size | 104,515 |
An asynchronous pure rust SQL driver for SAP HANA(TM).
Add hdbconnect_async
to the dependencies section in your project's Cargo.toml
:
[dependencies]
hdbconnect_async = "0.28"
Assuming you have
39013
on host hxehost
,HORST
with password SeCrEt
,then a first simple test which sets up some table, inserts data and reads them back might look like this:
use hdbconnect_async::{Connection, HdbResult};
#[tokio::main]
pub async fn main() -> HdbResult<()> {
let mut connection = Connection::new("hdbsql://HORST:SeCrEt@hxehost:39013").await?;
// Cleanup if necessary, and set up a test table
connection.multiple_statements_ignore_err(vec![
"drop table FOO_SQUARE"
]).await;
connection.multiple_statements(vec![
"create table FOO_SQUARE ( f1 INT primary key, f2 BIGINT)",
]).await?;
// Insert some test data
let mut insert_stmt = connection.prepare(
"insert into FOO_SQUARE (f1, f2) values(?,?)"
).await?;
for i in 0..100 {
insert_stmt.add_batch(&(i, i * i))?;
}
insert_stmt.execute_batch().await?;
// 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).await?.try_into().await?;
// 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_async/ for the full functionality of hdbconnect_async.
There you find also more code examples, especially 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.
rocket_pool
Adds an implementation of a rocket_db_pools
database pool.
dist_tx
Adds support for distributed transactions, based on dist_tx
.
See the change log.