effectum 0.7.0

An embeddable task queue based on SQLite
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

use rusqlite::{functions::FunctionFlags, Error::UserFunctionError};
use serde_json::value::RawValue;
use smallvec::SmallVec;

type RawJsonArray<'a> = SmallVec<[&'a serde_json::value::RawValue; 5]>;

pub fn register_functions(conn: &mut rusqlite::Connection) -> Result<(), rusqlite::Error> {
    conn.create_scalar_function(
        "json_array_append",
        2,
        FunctionFlags::SQLITE_UTF8
            | FunctionFlags::SQLITE_DETERMINISTIC
            | FunctionFlags::SQLITE_INNOCUOUS,
        |ctx| {
            let json: String = ctx.get(0)?;
            let value: String = ctx.get(1)?;

            let json_item =
                RawValue::from_string(value).map_err(|e| UserFunctionError(e.into()))?;
            let mut json: RawJsonArray =
                serde_json::from_str(&json).map_err(|e| UserFunctionError(e.into()))?;

            json.push(&json_item);

            let result = serde_json::to_string(&json).map_err(|e| UserFunctionError(e.into()))?;
            Ok(result)
        },
    )?;

    rusqlite::vtab::array::load_module(conn)?;

    Ok(())
}