use chrono::{DateTime, Utc};
use rustango::core::Model as _;
use rustango::sql::Auto;
use rustango::Model;
use serde::{Deserialize, Serialize};
#[derive(Model, Debug, Clone, Serialize, Deserialize)]
#[rustango(table = "cms_analytics_event", app = "cms")]
pub struct AnalyticsEvent {
#[rustango(primary_key)]
pub id: Auto<i64>,
#[rustango(max_length = 36)]
pub visitor_id: String,
#[rustango(max_length = 36)]
pub session_id: String,
#[rustango(max_length = 16)]
pub event_type: String,
#[rustango(max_length = 512)]
pub path: String,
#[rustango(max_length = 255)]
pub referrer_host: String,
#[rustango(max_length = 2)]
pub country: String,
#[rustango(max_length = 16)]
pub device: String,
#[rustango(max_length = 32)]
pub browser: String,
#[rustango(max_length = 32)]
pub os: String,
pub screen_w: i32,
pub screen_h: i32,
pub duration_ms: i64,
pub max_scroll_pct: i32,
pub is_bounce: bool,
#[rustango(max_length = 16)]
pub locale: String,
pub created_at: DateTime<Utc>,
}
pub async fn ensure_table(pool: &rustango::sql::Pool) -> Result<(), rustango::sql::ExecError> {
let ddl = rustango::migrate::ddl::create_table_if_not_exists_sql_with_dialect(
pool.dialect(),
&AnalyticsEvent::SCHEMA,
);
for stmt in ddl.split(';').map(str::trim).filter(|s| !s.is_empty()) {
rustango::sql::raw_execute_pool(pool, stmt, Vec::new()).await?;
}
let index_sql: Vec<String> = {
let d = pool.dialect();
let if_not_exists = if d.supports_create_index_if_not_exists() {
"IF NOT EXISTS "
} else {
""
};
let table = d.quote_ident("cms_analytics_event");
let mut v = Vec::new();
for (name, col) in [
("idx_cms_analytics_created", "created_at"),
("idx_cms_analytics_visitor", "visitor_id"),
("idx_cms_analytics_session", "session_id"),
("idx_cms_analytics_path", "path"),
] {
v.push(format!(
"CREATE INDEX {if_not_exists}{} ON {} ({})",
d.quote_ident(name),
table,
d.quote_ident(col),
));
}
v
};
for sql in &index_sql {
if let Err(e) = rustango::sql::run_ddl_idempotent(pool, sql).await {
tracing::warn!(target: "rustango_cms::analytics", error = %e, %sql, "analytics index not created");
}
}
Ok(())
}