persistant-sqlx 0.9.7

PersistAnt's relational driver over sqlx: implements RelationalBackend for PostgreSQL, with typed error classification.
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
49
50
51
52
53
54
55

// SPDX-License-Identifier: MIT OR Apache-2.0
//! The checked-in `matrix/sqlx-sqlite.tsv` parses and records every certified leaf on, except rel.row_lock (SQLite has no row locks).

use persistant_core::{Config, Lookup, Matrix};

#[test]
fn the_recorded_sqlite_rows_are_all_on_and_read_by_the_gate() {
    let m = Matrix::parse(include_str!("../../../matrix/sqlx-sqlite.tsv"))
        .expect("the checked-in matrix parses");
    assert_eq!(
        m.rows().len(),
        53,
        "eighteen kv/lock leaves on each of sqlite and sqlite-full, and seventeen relational leaves (eleven contract, six migration) are certified"
    );
    for r in m.rows() {
        // SQLite has no row locks and holds the write lock from `begin`: those leaves are recorded off.
        assert_eq!(
            r.enabled,
            !matches!(
                r.subject.as_str(),
                "rel.row_lock"
                    | "rel.isolation.repeatable_read"
                    | "rel.isolation.serializable"
                    | "kv.bounded_call"
            ),
            "{}: {}",
            r.subject,
            r.note
        );
        // kv rows are keyed by the adapter (plain and the durable `open_durable` profile), relational
        // rows by the server itself.
        if r.subject.as_str().starts_with("rel.") {
            assert_eq!(r.backend, "sqlite");
        } else {
            assert!(
                ["kv-on-relational:sqlite", "kv-on-relational:sqlite-full"]
                    .contains(&r.backend.as_str()),
                "{}",
                r.backend
            );
        }
        assert_eq!(r.config.get("dialect"), Some("sqlite"));
        assert!(r.metadata.get("test").is_some());
    }
    let first = &m.rows()[0];
    let actual = Config::new().with("dialect", "sqlite");
    assert_eq!(
        m.lookup(&first.subject, &first.backend, &first.version, &actual),
        Lookup::On
    );
    assert_eq!(
        m.lookup(&first.subject, &first.backend, "0.0-not-certified", &actual),
        Lookup::NoRow
    );
}