use anyhow::Result;
use chrono::{DateTime, Utc};
use rusqlite::params;
use super::SqliteStore;
#[derive(Debug, Clone, PartialEq, Eq)]
pub struct IngestedSession {
pub session_key: String,
pub file_path: String,
}
impl SqliteStore {
pub fn ingested_sessions_since(
&self,
source: &str,
since: DateTime<Utc>,
) -> Result<Vec<IngestedSession>> {
let conn = self.reader();
let mut stmt = conn.prepare(
"SELECT DISTINCT session_key, file_path FROM ingest_log \
WHERE source = ?1 AND session_key IS NOT NULL \
AND julianday(ingested_at) >= julianday(?2) \
ORDER BY session_key, file_path",
)?;
let rows = stmt.query_map(params![source, since.to_rfc3339()], |r| {
Ok(IngestedSession {
session_key: r.get(0)?,
file_path: r.get(1)?,
})
})?;
Ok(rows.collect::<rusqlite::Result<Vec<_>>>()?)
}
}