second-brain-core 0.13.0

Core library for second-brain: SQLite storage with vector and lexical indexes, BGE embeddings, and hybrid retrieval
Documentation
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 {
    /// Distinct (session key, file) pairs of keyed `source` files ingested
    /// at or after `since`, ordered by session key then file.
    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<_>>>()?)
    }
}