resolute 0.4.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
45
46
47
48
49
50
51
52
53
54
55

//! Basic CRUD operations with resolute.
//!
//! Run: cargo run -p resolute --example basic_crud
//! Requires: docker compose up -d

use resolute::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?;

    // CREATE
    client
        .simple_query(
            "CREATE TABLE IF NOT EXISTS example_users (id serial PRIMARY KEY, name text NOT NULL)",
        )
        .await?;

    // INSERT
    let count = client
        .execute(
            "INSERT INTO example_users (name) VALUES ($1)",
            &[&"Alice".to_string()],
        )
        .await?;
    println!("Inserted {count} row(s)");

    // READ
    let rows = client
        .query("SELECT id, name FROM example_users ORDER BY id", &[])
        .await?;
    for row in &rows {
        let id: i32 = row.get(0)?;
        let name: String = row.get(1)?;
        println!("  {id}: {name}");
    }

    // UPDATE
    let updated = client
        .execute(
            "UPDATE example_users SET name = $1 WHERE name = $2",
            &[&"Bob".to_string(), &"Alice".to_string()],
        )
        .await?;
    println!("Updated {updated} row(s)");

    // DELETE
    client.execute("DELETE FROM example_users", &[]).await?;
    client.simple_query("DROP TABLE example_users").await?;
    println!("Cleanup done");

    Ok(())
}