use std::cell::RefCell;
use std::sync::Arc;
use ::rusqlite::Connection;
use ::rusqlite::trace::{TraceEvent, TraceEventCodes};
use crate::record::{Analysis, Call, analyze, describe_metrics};
const MAX_OPEN: usize = 32;
struct Open {
sql: String,
analysis: Arc<Analysis>,
_span: tracing::Span,
}
thread_local! {
static OPEN: RefCell<Vec<Open>> = const { RefCell::new(Vec::new()) };
}
pub fn instrument(connection: &Connection) {
describe_metrics();
connection.trace_v2(
TraceEventCodes::SQLITE_TRACE_STMT | TraceEventCodes::SQLITE_TRACE_PROFILE,
Some(on_event),
);
}
const SQLITE: &str = "sqlite";
fn on_event(event: TraceEvent<'_>) {
match event {
TraceEvent::Stmt(statement, text) => {
if text.starts_with("--") {
return;
}
let sql = statement.sql();
let analysis = analyze(&sql);
let call = Call {
system: SQLITE,
namespace: None,
server: None,
analysis: &analysis,
};
let span = call.span();
OPEN.with(|open| {
let mut open = open.borrow_mut();
if open.len() >= MAX_OPEN {
open.remove(0);
}
open.push(Open {
sql: sql.into_owned(),
analysis,
_span: span,
});
});
}
TraceEvent::Profile(statement, duration) => {
let sql = statement.sql();
let finished = OPEN.with(|open| {
let mut open = open.borrow_mut();
let i = open.iter().rposition(|o| o.sql == sql)?;
Some(open.remove(i))
});
let analysis = match &finished {
Some(open) => Arc::clone(&open.analysis),
None => analyze(&sql),
};
let call = Call {
system: SQLITE,
namespace: None,
server: None,
analysis: &analysis,
};
call.record_duration(duration.as_secs_f64(), None);
drop(finished);
}
_ => {}
}
}