pub const SYS_METRICS: &str = "system.metrics";
pub const CREATE_METRICS_SQL: &str = r#"
CREATE TABLE IF NOT EXISTS system.metrics (
id INTEGER PRIMARY KEY AUTO_INCREMENT,
name TEXT NOT NULL,
description TEXT,
unit TEXT,
metric_type TEXT NOT NULL,
value FLOAT NOT NULL,
attributes TEXT,
timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
"#;
pub fn is_metrics_table(schema: &str, name: &str) -> bool {
schema.eq_ignore_ascii_case("system") && name.eq_ignore_ascii_case("metrics")
}
#[cfg(test)]
mod tests {
use super::*;
#[test]
fn test_is_metrics_table() {
assert!(is_metrics_table("system", "metrics"));
assert!(is_metrics_table("SYSTEM", "METRICS"));
assert!(!is_metrics_table("public", "metrics"));
assert!(!is_metrics_table("system", "tables"));
}
}