nodedb 0.3.0

Local-first, real-time, edge-to-cloud hybrid database for multi-modal workloads
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
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122

// SPDX-License-Identifier: BUSL-1.1

//! Materialized view metadata operations for the system catalog.

use super::types::{MATERIALIZED_VIEWS, StoredMaterializedView, SystemCatalog, catalog_err};

impl SystemCatalog {
    /// Store a materialized view record.
    pub fn put_materialized_view(&self, view: &StoredMaterializedView) -> crate::Result<()> {
        let key = format!("{}:{}", view.tenant_id, view.name);
        let bytes = zerompk::to_msgpack_vec(view)
            .map_err(|e| catalog_err("serialize materialized view", e))?;
        let write_txn = self
            .db
            .begin_write()
            .map_err(|e| catalog_err("write txn", e))?;
        {
            let mut table = write_txn
                .open_table(MATERIALIZED_VIEWS)
                .map_err(|e| catalog_err("open materialized_views", e))?;
            table
                .insert(key.as_str(), bytes.as_slice())
                .map_err(|e| catalog_err("insert materialized_view", e))?;
        }
        write_txn.commit().map_err(|e| catalog_err("commit", e))
    }

    /// Get a materialized view by name.
    pub fn get_materialized_view(
        &self,
        tenant_id: u64,
        name: &str,
    ) -> crate::Result<Option<StoredMaterializedView>> {
        let key = format!("{tenant_id}:{name}");
        let read_txn = self
            .db
            .begin_read()
            .map_err(|e| catalog_err("read txn", e))?;
        let table = read_txn
            .open_table(MATERIALIZED_VIEWS)
            .map_err(|e| catalog_err("open materialized_views", e))?;
        match table.get(key.as_str()) {
            Ok(Some(guard)) => {
                let bytes = guard.value();
                let view: StoredMaterializedView = zerompk::from_msgpack(bytes)
                    .map_err(|e| catalog_err("deserialize materialized view", e))?;
                Ok(Some(view))
            }
            Ok(None) => Ok(None),
            Err(e) => Err(catalog_err("get materialized_view", e)),
        }
    }

    /// Load every materialized view across all tenants. Used by
    /// the startup integrity check and any cross-tenant audit.
    pub fn load_all_materialized_views(&self) -> crate::Result<Vec<StoredMaterializedView>> {
        let read_txn = self
            .db
            .begin_read()
            .map_err(|e| catalog_err("read txn", e))?;
        let table = read_txn
            .open_table(MATERIALIZED_VIEWS)
            .map_err(|e| catalog_err("open materialized_views", e))?;
        let mut views = Vec::new();
        for entry in table
            .range::<&str>(..)
            .map_err(|e| catalog_err("range scan", e))?
        {
            let (_key, val) = entry.map_err(|e| catalog_err("read entry", e))?;
            let view: StoredMaterializedView = zerompk::from_msgpack(val.value())
                .map_err(|e| catalog_err("deser materialized_view", e))?;
            views.push(view);
        }
        Ok(views)
    }

    /// List all materialized views for a tenant.
    pub fn list_materialized_views(
        &self,
        tenant_id: u64,
    ) -> crate::Result<Vec<StoredMaterializedView>> {
        let prefix = format!("{tenant_id}:");
        let read_txn = self
            .db
            .begin_read()
            .map_err(|e| catalog_err("read txn", e))?;
        let table = read_txn
            .open_table(MATERIALIZED_VIEWS)
            .map_err(|e| catalog_err("open materialized_views", e))?;
        let mut views = Vec::new();
        for entry in table
            .range::<&str>(..)
            .map_err(|e| catalog_err("range scan", e))?
        {
            let (key, val) = entry.map_err(|e| catalog_err("read entry", e))?;
            if key.value().starts_with(&prefix)
                && let Ok(view) = zerompk::from_msgpack::<StoredMaterializedView>(val.value())
            {
                views.push(view);
            }
        }
        Ok(views)
    }

    /// Delete a materialized view by name.
    pub fn delete_materialized_view(&self, tenant_id: u64, name: &str) -> crate::Result<()> {
        let key = format!("{tenant_id}:{name}");
        let write_txn = self
            .db
            .begin_write()
            .map_err(|e| catalog_err("write txn", e))?;
        {
            let mut table = write_txn
                .open_table(MATERIALIZED_VIEWS)
                .map_err(|e| catalog_err("open materialized_views", e))?;
            table
                .remove(key.as_str())
                .map_err(|e| catalog_err("delete materialized_view", e))?;
        }
        write_txn.commit().map_err(|e| catalog_err("commit", e))
    }
}