nodedb 0.4.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

// SPDX-License-Identifier: BUSL-1.1

//! Protocol-neutral `SHOW TRIGGERS` DDL handler.
//!
//! Ported from the pgwire `ddl::trigger::show` handler. The registry read,
//! `sort_key` ordering, optional `ON <collection>` filter, and the exact
//! column set / per-column text encoding are preserved verbatim; only the
//! result construction changed from pgwire `Response` / `QueryResponse` to the
//! protocol-neutral [`DdlResult::Rows`] over [`ShapedRows`].

use serde_json::{Map, Value as JsonValue};

use crate::control::security::identity::AuthenticatedIdentity;
use crate::control::server::response_shape::types::ShapedRows;
use crate::control::state::SharedState;

use super::super::super::result::{DdlError, DdlResult};

/// Handle `SHOW TRIGGERS [ON <collection>]`
pub fn show_triggers(
    state: &SharedState,
    identity: &AuthenticatedIdentity,
    parts: &[&str],
) -> Result<Vec<DdlResult>, DdlError> {
    let tenant_id = identity.tenant_id.as_u64();

    // Optional collection filter: SHOW TRIGGERS ON <collection>
    let collection_filter = if parts.len() >= 4 && parts[2].eq_ignore_ascii_case("ON") {
        Some(parts[3].to_lowercase())
    } else {
        None
    };

    let columns = vec![
        "name".to_string(),
        "collection".to_string(),
        "timing".to_string(),
        "events".to_string(),
        "granularity".to_string(),
        "execution".to_string(),
        "enabled".to_string(),
        "priority".to_string(),
        "owner".to_string(),
    ];

    let triggers = state.trigger_registry.list_for_tenant(tenant_id);
    let mut sorted = triggers;
    sorted.sort_by(|a, b| a.sort_key().cmp(&b.sort_key()));

    let mut rows = Vec::new();
    for t in &sorted {
        if let Some(ref filter) = collection_filter
            && &t.collection != filter
        {
            continue;
        }
        let mut row = Map::new();
        row.insert("name".to_string(), JsonValue::String(t.name.clone()));
        row.insert(
            "collection".to_string(),
            JsonValue::String(t.collection.clone()),
        );
        row.insert(
            "timing".to_string(),
            JsonValue::String(t.timing.as_str().to_string()),
        );
        row.insert("events".to_string(), JsonValue::String(t.events.display()));
        row.insert(
            "granularity".to_string(),
            JsonValue::String(t.granularity.as_str().to_string()),
        );
        row.insert(
            "execution".to_string(),
            JsonValue::String(t.execution_mode.as_str().to_string()),
        );
        row.insert(
            "enabled".to_string(),
            JsonValue::String(t.enabled.to_string()),
        );
        row.insert(
            "priority".to_string(),
            JsonValue::String(t.priority.to_string()),
        );
        row.insert("owner".to_string(), JsonValue::String(t.owner.clone()));
        rows.push(row);
    }

    let column_types = ShapedRows::text_types(columns.len());
    Ok(vec![DdlResult::Rows(ShapedRows {
        columns,
        column_types,
        rows,
        notice: None,
    })])
}