postgres-cursor 0.1.0

Cursor abstraction for PostgreSQL
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

rust-postgres-cursor
====================

A cursor type for use with PostgreSQL.

## Example

```rust
extern crate postgres;
extern crate postgres_cursor;

use postgres::{Connection, TlsMode};
use postgres_cursor::Cursor;

fn main() {
    // First, establish a connection with postgres
    let conn = Connection::connect("postgres://jwilm@127.0.0.1/foo", TlsMode::None)
        .expect("connect");

    // Build the cursor
    let mut cursor = Cursor::build(&conn)
        // Batch size determines rows returned in each FETCH call
        .batch_size(10)
        // Query is the statement to build a cursor for
        .query("SELECT id FROM products")
        // Finalize turns this builder into a cursor
        .finalize();

    // Iterate over batches of rows
    for result in cursor.iter().unwrap() {
        // Each item returned from the iterator is a Result<Rows>.
        // This is because each call to `next()` makes a query
        // to the database.
        let rows = result.unwrap();

        // After handling errors, rows returned in this iteration
        // can be iterated over.
        for row in &rows {
            println!("{:?}", row);
        }
    }
}
```

## Features

The library is mostly complete since its only intent is providing a cursor
abstraction. However, there are some small planned features worth noting:

- [ ] Support query parameters (eg. `"SELECT foo FROM bar WHERE quux = $1"`) in
      cursor query string.