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
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
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143

// SPDX-License-Identifier: BUSL-1.1

//! `SHOW STORAGE FOR collection` and `SHOW COMPACTION STATUS` handlers.
//!
//! Ported from the pgwire maintenance handlers. Both result sets are all-text
//! columns (`text_field`), so the protocol-neutral [`ShapedRows`] carries
//! `DdlColType::Text` per column and each cell as its `String` form — the same
//! bytes `DataRowEncoder::encode_field(&str)` produced, keeping the
//! RowDescription and DataRow output byte-identical.

use nodedb_types::DatabaseId;

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

use crate::control::security::identity::AuthenticatedIdentity;
use crate::control::server::response_shape::types::{DdlColType, ShapedRows};
use crate::control::state::SharedState;

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

/// Handle `SHOW STORAGE FOR collection`.
pub fn handle_show_storage(
    state: &SharedState,
    identity: &AuthenticatedIdentity,
    parts: &[&str],
) -> Result<Vec<DdlResult>, DdlError> {
    // SHOW STORAGE FOR collection
    let collection = parts
        .get(3)
        .ok_or_else(|| ddl_err("42601", "syntax: SHOW STORAGE FOR <collection>"))?
        .to_lowercase();

    let tenant_id = identity.tenant_id.as_u64();

    // Verify collection exists.
    if state
        .credentials
        .catalog()
        .get_collection(DatabaseId::DEFAULT, tenant_id, &collection)
        .ok()
        .flatten()
        .is_none()
    {
        return Err(ddl_err(
            "42P01",
            format!("collection \"{collection}\" does not exist"),
        ));
    }

    // Load column stats if available (from last ANALYZE).
    let stats = state
        .credentials
        .catalog()
        .load_column_stats(tenant_id, &collection)
        .ok()
        .unwrap_or_default();

    let columns = vec![
        "collection".to_string(),
        "columns".to_string(),
        "row_count".to_string(),
        "last_analyzed".to_string(),
    ];
    let column_types = vec![DdlColType::Text; 4];

    let row_count = stats.first().map(|s| s.row_count).unwrap_or(0);
    let last_analyzed = stats
        .first()
        .map(|s| {
            if s.analyzed_at > 0 {
                format!("{}ms ago", now_ms().saturating_sub(s.analyzed_at))
            } else {
                "never".to_string()
            }
        })
        .unwrap_or_else(|| "never".to_string());

    let mut row = Map::new();
    row.insert(
        "collection".to_string(),
        JsonValue::String(collection.clone()),
    );
    row.insert(
        "columns".to_string(),
        JsonValue::String(stats.len().to_string()),
    );
    row.insert(
        "row_count".to_string(),
        JsonValue::String(row_count.to_string()),
    );
    row.insert(
        "last_analyzed".to_string(),
        JsonValue::String(last_analyzed),
    );

    Ok(vec![DdlResult::Rows(ShapedRows {
        columns,
        column_types,
        rows: vec![row],
        notice: None,
    })])
}

/// Handle `SHOW COMPACTION STATUS`.
pub fn handle_show_compaction_status(
    _state: &SharedState,
    _identity: &AuthenticatedIdentity,
) -> Result<Vec<DdlResult>, DdlError> {
    let columns = vec![
        "status".to_string(),
        "pending_jobs".to_string(),
        "compaction_debt".to_string(),
    ];
    let column_types = vec![DdlColType::Text; 3];

    // Compaction runs automatically in the Data Plane. We report the current
    // state as "idle" — detailed stats require Data Plane query support.
    let mut row = Map::new();
    row.insert("status".to_string(), JsonValue::String("idle".to_string()));
    row.insert(
        "pending_jobs".to_string(),
        JsonValue::String("0".to_string()),
    );
    row.insert(
        "compaction_debt".to_string(),
        JsonValue::String("0".to_string()),
    );

    Ok(vec![DdlResult::Rows(ShapedRows {
        columns,
        column_types,
        rows: vec![row],
        notice: None,
    })])
}

fn now_ms() -> u64 {
    std::time::SystemTime::now()
        .duration_since(std::time::UNIX_EPOCH)
        .unwrap_or_default()
        .as_millis() as u64
}