resolute 0.5.0

Compile-time-checked PostgreSQL queries with a pure-Rust wire protocol driver.
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

//! Named parameters example.
//!
//! Run: cargo run -p resolute --example named_params
//! Requires: docker compose up -d

use resolute::{sql, Client};

const ADDR: &str = "127.0.0.1:54322";

#[tokio::main]
async fn main() -> Result<(), Box<dyn std::error::Error>> {
    let client = Client::connect(ADDR, "postgres", "postgres", "postgrest_test").await?;

    // Style 1: raw slice.
    let rows = client
        .query_named(
            "SELECT id, name FROM api.authors WHERE id = :id",
            &[("id", &1i32)],
        )
        .await?;
    let name: String = rows[0].get(1)?;
    println!("Author 1: {name}");

    // Duplicate params: :val appears twice, bound once.
    let rows = client
        .query_named(
            "SELECT :val::int4 AS a, :val::int4 + 10 AS b",
            &[("val", &5i32)],
        )
        .await?;
    let a: i32 = rows[0].get(0)?;
    let b: i32 = rows[0].get(1)?;
    println!("Duplicate param: a={a}, b={b}");

    // Style 2: the fluent builder. :value::int4 cast in SQL is handled correctly.
    let doubled: i32 = sql("SELECT :value::int4 * 2 AS doubled")
        .bind_named("value", 21i32)
        .fetch_one(&client)
        .await?
        .get(0)?;
    println!("Doubled: {doubled}");

    Ok(())
}