engram-storage 0.6.0

SQLite storage with FTS5
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43

use rusqlite::params;

use crate::database::Database;
use crate::error::StorageError;

#[derive(Debug, Clone, PartialEq, Eq)]
pub struct ConsolidationLogEntry {
    pub id: String,
    pub action: String,
    pub memory_ids_json: String,
    pub reason: Option<String>,
    pub performed_at: String,
    pub performed_by: String,
}

impl Database {
    pub fn list_consolidation_log(
        &self,
        limit: usize,
    ) -> Result<Vec<ConsolidationLogEntry>, StorageError> {
        let mut statement = self.connection().prepare(
            "SELECT id, action, memory_ids, reason, performed_at, performed_by
             FROM consolidation_log
             ORDER BY performed_at DESC, id DESC
             LIMIT ?1",
        )?;
        let rows = statement.query_map(params![limit as i64], |row| {
            Ok(ConsolidationLogEntry {
                id: row.get(0)?,
                action: row.get(1)?,
                memory_ids_json: row.get(2)?,
                reason: row.get(3)?,
                performed_at: row.get(4)?,
                performed_by: row.get(5)?,
            })
        })?;
        let mut entries = Vec::new();
        for row in rows {
            entries.push(row?);
        }
        Ok(entries)
    }
}