matdb 0.1.0

An experimental embedded SQL-like DBMS
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

use anyhow::Result;
use matdb::{Db, Value};

#[test]
fn hello_matdb() -> Result<()> {
    let mut db = Db::open_memory()?;

    db.run(
        "CREATE TABLE messages (id INT PRIMARY KEY, body TEXT NOT NULL);",
        Vec::new(),
    )?;
    db.run(
        "INSERT INTO messages (id, body) VALUES (?0, ?1);",
        vec![1.into(), "Hello, matdb!".to_string().into()],
    )?;
    db.finish_tx()?;

    assert_eq!(
        Value::String("Hello, matdb!".to_string()),
        db.run("SELECT body FROM messages WHERE id = 1;", Vec::new())?
            .unwrap()
            .rows[0][0]
    );

    Ok(())
}