sqll 0.13.3

Efficient interface to SQLite that doesn't get in your way
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

use sqll::OpenOptions;

use anyhow::Context;

fn main() -> Result<(), Box<dyn std::error::Error>> {
    let c = OpenOptions::new()
        .create()
        .read_write()
        .no_mutex()
        .open("wal-people.db")?;

    c.execute(
        r#"
        pragma journal_mode = WAL;

        CREATE TABLE IF NOT EXISTS persons (
            id INTEGER PRIMARY KEY,
            name TEXT NOT NULL
        )
        "#,
    )?;

    // WAL only supports one writer, if you run this in multiple processes this
    // checks at what point the write operation fails.
    loop {
        c.execute("BEGIN").context("Beginning transaction")?;

        c.execute("DELETE FROM persons;")
            .context("Deleting all records")?;

        c.execute("INSERT INTO persons (name) VALUES ('Alice')")
            .context("Inserting Alice")?;

        c.execute("INSERT INTO persons (name) VALUES ('Bob')")
            .context("Inserting Bob")?;

        c.execute("INSERT INTO persons (name) VALUES ('Charlie')")
            .context("Inserting Charlie")?;

        c.execute("COMMIT").context("Committing transaction")?;
    }
}