graphitesql 0.0.13

A pure, safe, no_std Rust re-implementation of SQLite, compatible with the SQLite 3 file format.
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

//! `json_pretty(X [, indent])` — byte-compatible with sqlite3's formatting.

#![cfg(feature = "std")]

use graphitesql::{Connection, Value};

fn text(c: &Connection, sql: &str) -> String {
    match &c.query(sql).unwrap().rows[0][0] {
        Value::Text(s) => s.clone(),
        other => panic!("not text: {other:?}"),
    }
}

#[test]
fn pretty_default_four_space_indent() {
    let c = Connection::open_memory().unwrap();
    let got = text(
        &c,
        "SELECT json_pretty('{\"a\":1,\"b\":[2,3],\"c\":{\"d\":4}}')",
    );
    let want = "{\n    \"a\": 1,\n    \"b\": [\n        2,\n        3\n    ],\n    \"c\": {\n        \"d\": 4\n    }\n}";
    assert_eq!(got, want);
}

#[test]
fn pretty_custom_indent_and_compact_cases() {
    let c = Connection::open_memory().unwrap();
    assert_eq!(
        text(&c, "SELECT json_pretty('{\"a\":1}', '  ')"),
        "{\n  \"a\": 1\n}"
    );
    // Empty containers and scalars stay on one line.
    assert_eq!(text(&c, "SELECT json_pretty('[]')"), "[]");
    assert_eq!(text(&c, "SELECT json_pretty('{}')"), "{}");
    assert_eq!(text(&c, "SELECT json_pretty('5')"), "5");
    assert_eq!(text(&c, "SELECT json_pretty('\"hi\"')"), "\"hi\"");
}

#[test]
fn pretty_null_and_errors() {
    let c = Connection::open_memory().unwrap();
    assert_eq!(
        c.query("SELECT json_pretty(NULL)").unwrap().rows[0][0],
        Value::Null
    );
    assert!(c.query("SELECT json_pretty('{bad')").is_err());
    assert!(c.query("SELECT json_pretty()").is_err());
}