mmex_lib 0.1.0-beta.2

Library for interacting with Money Manager EX data and logic
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
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

use crate::MmexError;
use rusqlite::{Connection, Params, Row, Transaction};

/// Abstracción para ejecutar comandos SQL.
pub trait DbExecutor {
    fn query_row_ext<T, P, F>(&self, sql: &str, params: P, f: F) -> Result<T, MmexError>
    where
        P: Params,
        F: FnOnce(&Row<'_>) -> rusqlite::Result<T>;

    fn execute_ext<P>(&self, sql: &str, params: P) -> Result<usize, MmexError>
    where
        P: Params;

    fn query_map_ext<T, P, F>(&self, sql: &str, params: P, f: F) -> Result<Vec<T>, MmexError>
    where
        P: Params,
        F: FnMut(&Row<'_>) -> rusqlite::Result<T>;
}

impl DbExecutor for Connection {
    fn query_row_ext<T, P, F>(&self, sql: &str, params: P, f: F) -> Result<T, MmexError>
    where
        P: Params,
        F: FnOnce(&Row<'_>) -> rusqlite::Result<T>,
    {
        self.query_row(sql, params, f).map_err(MmexError::from)
    }

    fn execute_ext<P>(&self, sql: &str, params: P) -> Result<usize, MmexError>
    where
        P: Params,
    {
        self.execute(sql, params).map_err(MmexError::from)
    }

    fn query_map_ext<T, P, F>(&self, sql: &str, params: P, f: F) -> Result<Vec<T>, MmexError>
    where
        P: Params,
        F: FnMut(&Row<'_>) -> rusqlite::Result<T>,
    {
        let mut stmt = self.prepare(sql)?;
        let iter = stmt.query_map(params, f)?;
        let mut result = Vec::new();
        for item in iter {
            result.push(item?);
        }
        Ok(result)
    }
}

impl<'a> DbExecutor for Transaction<'a> {
    fn query_row_ext<T, P, F>(&self, sql: &str, params: P, f: F) -> Result<T, MmexError>
    where
        P: Params,
        F: FnOnce(&Row<'_>) -> rusqlite::Result<T>,
    {
        self.query_row(sql, params, f).map_err(MmexError::from)
    }

    fn execute_ext<P>(&self, sql: &str, params: P) -> Result<usize, MmexError>
    where
        P: Params,
    {
        self.execute(sql, params).map_err(MmexError::from)
    }

    fn query_map_ext<T, P, F>(&self, sql: &str, params: P, f: F) -> Result<Vec<T>, MmexError>
    where
        P: Params,
        F: FnMut(&Row<'_>) -> rusqlite::Result<T>,
    {
        let mut stmt = self.prepare(sql)?;
        let iter = stmt.query_map(params, f)?;
        let mut result = Vec::new();
        for item in iter {
            result.push(item?);
        }
        Ok(result)
    }
}