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

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

//! Persist foreign-table relation and column ACLs.

use super::super::super::{Catalog, Result};

pub(super) fn migrate(tx: &rusqlite::Connection) -> Result<()> {
    let columns = Catalog::table_columns(tx, "_foreign_tables")?.unwrap_or_default();
    if !columns.contains_key("acl_json") {
        tx.execute_batch("ALTER TABLE _foreign_tables ADD COLUMN acl_json TEXT;")?;
    }
    if !columns.contains_key("column_acls_json") {
        tx.execute_batch(
            "ALTER TABLE _foreign_tables
             ADD COLUMN column_acls_json TEXT NOT NULL DEFAULT '{}';",
        )?;
    }
    tx.execute(
        "UPDATE _foreign_tables SET column_acls_json = '{}' WHERE column_acls_json IS NULL",
        [],
    )?;
    Ok(())
}