ledgr 0.1.0

A TUI personal finance app: import bank/pension statements, build a local database, and analyze your finances.
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
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94

use super::Db;
use crate::model::{Id, NewTransaction, Transaction};
use rusqlite::params;

impl Db {
    pub fn insert_transaction(&self, new: &NewTransaction) -> rusqlite::Result<Id> {
        self.conn().execute(
            "INSERT INTO transactions
                (account_id, statement_id, posted_at, amount_minor, currency,
                 description, raw_description, category_id, external_id)
             VALUES (?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9)",
            params![
                new.account_id,
                new.statement_id,
                new.posted_at,
                new.amount_minor,
                new.currency,
                new.description,
                new.raw_description,
                new.category_id,
                new.external_id,
            ],
        )?;
        Ok(self.conn().last_insert_rowid())
    }

    pub fn list_transactions_for_account(
        &self,
        account_id: Id,
    ) -> rusqlite::Result<Vec<Transaction>> {
        let mut stmt = self.conn().prepare(
            "SELECT id, account_id, statement_id, posted_at, amount_minor, currency,
                    description, raw_description, category_id, external_id
             FROM transactions
             WHERE account_id = ?1
             ORDER BY posted_at DESC, id DESC",
        )?;
        let rows = stmt.query_map(params![account_id], Self::row_to_transaction)?;
        rows.collect()
    }

    fn row_to_transaction(row: &rusqlite::Row) -> rusqlite::Result<Transaction> {
        Ok(Transaction {
            id: row.get(0)?,
            account_id: row.get(1)?,
            statement_id: row.get(2)?,
            posted_at: row.get(3)?,
            amount_minor: row.get(4)?,
            currency: row.get(5)?,
            description: row.get(6)?,
            raw_description: row.get(7)?,
            category_id: row.get(8)?,
            external_id: row.get(9)?,
        })
    }
}

#[cfg(test)]
mod tests {
    use super::*;
    use crate::model::{AccountType, NewAccount};

    #[test]
    fn insert_and_list_transactions() {
        let db = Db::open_in_memory().expect("open db");
        let account_id = db
            .insert_account(&NewAccount {
                name: "Current Account".into(),
                institution: None,
                account_type: AccountType::Checking,
                currency: "GBP".into(),
            })
            .expect("insert account");

        db.insert_transaction(&NewTransaction {
            account_id,
            statement_id: None,
            posted_at: "2026-07-01".into(),
            amount_minor: -2599,
            currency: "GBP".into(),
            description: "Groceries".into(),
            raw_description: Some("TESCO STORES 1234".into()),
            category_id: None,
            external_id: None,
        })
        .expect("insert transaction");

        let txs = db
            .list_transactions_for_account(account_id)
            .expect("list transactions");
        assert_eq!(txs.len(), 1);
        assert_eq!(txs[0].amount_minor, -2599);
    }
}