hdbconnect 0.32.0

A synchronous pure rust database driver for SAP HANA(TM)
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93

# hdbconnect

[![Latest version](https://img.shields.io/crates/v/hdbconnect.svg)](https://crates.io/crates/hdbconnect)
[![Documentation](https://docs.rs/hdbconnect/badge.svg)](https://docs.rs/hdbconnect)
[![License](https://img.shields.io/crates/l/hdbconnect.svg)](https://github.com/emabee/hdbconnect)
[![unsafe forbidden](https://img.shields.io/badge/unsafe-forbidden-success.svg)](https://github.com/rust-secure-code/safety-dance/)

A synchronous pure rust SQL driver for SAP HANA(TM).

Use [`hdbconnect_async`](https://crates.io/crates/hdbconnect_async)
if you want an asynchronous driver for SAP HANA.

## Usage

Add `hdbconnect` to the dependencies section in your project's `Cargo.toml`:

```toml
[dependencies]
hdbconnect = "0.32"
```

Assuming you have

- a HANA accessible at port `39013` on host `hxehost`,
- and you can log on to it as user `HORST` with password `SeCrEt`,

then a first simple test which sets up some table, inserts data and reads them back
might look like this:

```rust
use hdbconnect::{Connection, HdbResult};

pub fn main() -> HdbResult<()> {
    let mut connection = Connection::new("hdbsql://HORST:SeCrEt@hxehost:39013")?;

    // 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 BIGINT)",
    ])?;

    // 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(())
}
```

## Documentation

The [docs](https://docs.rs/hdbconnect/) contain more code examples,
especially in the description of module `code_examples`.

## TLS

The TLS implementation is based on `rustls`.

`rustls`'s flexibility to use non-default crypto providers is currently not (yet) exposed by `hdbconnect`.
Nevertheless, the need of `rustls` to initialize crypto shines through.
We thus recommend calling `hdbconnect::initialize_crypto` early in your main.

## Features

### `r2d2_pool`

Adds an implementation of a [`r2d2`](https://crates.io/crates/r2d2) database pool.

### `dist_tx`

Adds support for distributed transactions, based on [`dist_tx`](https://crates.io/crates/dist_tx).

## Versions

See the [change log](https://github.com/emabee/rust-hdbconnect/blob/master/CHANGELOG.md).