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

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

//! Persist sequence cache sizes and definition generations.

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

pub(super) fn migrate(tx: &rusqlite::Connection) -> Result<()> {
    let columns = Catalog::table_columns(tx, "_sequences")?.unwrap_or_default();
    if !columns.contains_key("cache_size") {
        tx.execute_batch(
            "ALTER TABLE _sequences ADD COLUMN cache_size INTEGER NOT NULL DEFAULT 1 CHECK (cache_size > 0);",
        )?;
    }
    if !columns.contains_key("definition_generation") {
        tx.execute_batch(
            "ALTER TABLE _sequences ADD COLUMN definition_generation BLOB NOT NULL DEFAULT X'';
             UPDATE _sequences SET definition_generation = object_id;",
        )?;
    }
    Ok(())
}