asqlite 1.3.1

SQLite wrapper using async Rust
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 futures::StreamExt;
use std::io;

#[tokio::main]
async fn main() -> io::Result<()> {
    // Create an in-memory database connection with the name db1
    let mut conn = asqlite::Connection::builder()
        .create(true) // create if it does not exists
        .write(true) // read and write
        .open_memory("db1") // to open a file, use .open(path)
        .await?;

    // Create a table
    conn.execute(
        "CREATE TABLE fruit (name TEXT, color TEXT)",
        (), // no parameters
    )
    .await?;

    // Populate the table
    let _apple_id = conn
        .insert(
            "INSERT INTO fruit (name, color) VALUES (?, ?)",
            asqlite::params!("apple", "red"),
        )
        .await?;

    // Check all red fruits
    let mut rows = conn.query(
        "SELECT name FROM fruit WHERE color = ?",
        asqlite::params!("red"),
    );

    // Iterate rows
    while let Some(row) = rows.next().await {
        let name: String = row?;

        println!("{} is red", name);
    }

    Ok(())
}