pub const SYS_LOGS: &str = "system.logs";
pub const CREATE_LOGS_SQL: &str = r#"
CREATE TABLE IF NOT EXISTS system.logs (
id INTEGER PRIMARY KEY AUTO_INCREMENT,
timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
level TEXT NOT NULL,
target TEXT NOT NULL,
message TEXT NOT NULL,
json_fields TEXT,
trace_id TEXT,
span_id TEXT
);
"#;
pub fn is_logs_table(schema: &str, name: &str) -> bool {
schema.eq_ignore_ascii_case("system") && name.eq_ignore_ascii_case("logs")
}
#[cfg(test)]
mod tests {
use super::*;
#[test]
fn test_is_logs_table() {
assert!(is_logs_table("system", "logs"));
assert!(is_logs_table("SYSTEM", "LOGS"));
assert!(!is_logs_table("public", "logs"));
assert!(!is_logs_table("system", "tables"));
}
}