uqa-storage-sqlite 0.3.8

SQLite catalog, indexes, compressed storage, graph and key/value providers
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
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92

//
// Unified Query Algebra
//
// Copyright (c) 2023-2026 Cognica, Inc.
//

use super::*;

fn column_acl() -> std::collections::BTreeMap<String, Vec<uqa_storage::catalog::TableAclEntry>> {
    std::collections::BTreeMap::from([(
        "visible".into(),
        vec![uqa_storage::catalog::TableAclEntry {
            role: "reader".into(),
            grantor: Some("owner".into()),
            privileges: uqa_storage::catalog::TablePrivileges {
                select: true,
                ..uqa_storage::catalog::TablePrivileges::default()
            },
            grant_options: uqa_storage::catalog::TablePrivileges::default(),
        }],
    )])
}

#[test]
fn migration_37_adds_empty_column_acls_to_legacy_tables() {
    let connection = ManagedConnection::open_in_memory().unwrap();
    let current = Catalog::open(connection.clone()).unwrap();
    current
        .save_table(&TableSchema {
            relation: RelationIdentity::new("public", "legacy_column_acl"),
            role_owner: "owner".into(),
            acl: None,
            column_acls: column_acl(),
            object_id: [37; 16],
            storage_generation: [37; 16],
            analyzer_json: "{}".into(),
            fts_fields: Vec::new(),
            vector_fields: Vec::new(),
            columns_json: "[]".into(),
            constraints_json: String::new(),
        })
        .unwrap();
    drop(current);
    connection
        .with(|database| {
            database.execute("ALTER TABLE _tables DROP COLUMN column_acls_json", [])?;
            database.execute(
                "UPDATE _metadata SET value = '36' WHERE key = 'schema_version'",
                [],
            )?;
            Ok(())
        })
        .unwrap();

    let upgraded = Catalog::open(connection).unwrap();
    assert!(upgraded.load_tables().unwrap()[0].column_acls.is_empty());
}

#[test]
fn migration_37_preserves_column_acls_installed_before_its_version_marker() {
    let connection = ManagedConnection::open_in_memory().unwrap();
    let current = Catalog::open(connection.clone()).unwrap();
    let expected = column_acl();
    current
        .save_table(&TableSchema {
            relation: RelationIdentity::new("public", "early_column_acl"),
            role_owner: "owner".into(),
            acl: None,
            column_acls: expected.clone(),
            object_id: [38; 16],
            storage_generation: [38; 16],
            analyzer_json: "{}".into(),
            fts_fields: Vec::new(),
            vector_fields: Vec::new(),
            columns_json: "[]".into(),
            constraints_json: String::new(),
        })
        .unwrap();
    drop(current);
    connection
        .with(|database| {
            database.execute(
                "UPDATE _metadata SET value = '36' WHERE key = 'schema_version'",
                [],
            )?;
            Ok(())
        })
        .unwrap();

    let upgraded = Catalog::open(connection).unwrap();
    assert_eq!(upgraded.load_tables().unwrap()[0].column_acls, expected);
}