schist_queries/src/transactions.rs


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

use anyhow::{Context, Result};
use diesel::{QueryDsl, RunQueryDsl, SelectableHelper, SqliteConnection};
use schist_models::transaction::Transaction;
use schist_schema::schema::transactions::dsl::transactions as transactions_table;

pub fn delete_all_transactions(connection: &mut SqliteConnection) -> Result<usize> {
    let num_rows_deleted = diesel::delete(transactions_table)
        .execute(connection)
        .with_context(|| "failed to delete all transactions")?;
    Ok(num_rows_deleted)
}

pub fn get_all_transactions(connection: &mut SqliteConnection) -> Result<Vec<Transaction>> {
    let all_transactions = transactions_table
        .select(Transaction::as_select())
        .load(connection)
        .with_context(|| "failed to get all category transfers")?;
    Ok(all_transactions)
}

pub fn insert_transactions(
    transactions: &[Transaction],
    connection: &mut SqliteConnection,
) -> Result<usize> {
    let num_rows_inserted = diesel::insert_into(transactions_table)
        .values(transactions)
        .execute(connection)
        .with_context(|| insert_err_msg(&transactions))?;
    Ok(num_rows_inserted)
}

fn insert_err_msg(transactions: &[Transaction]) -> String {
    format!(
        "failed to insert transactions: [{}]",
        transactions
            .iter()
            .map(|t| t.id.to_string())
            .collect::<Vec<String>>()
            .join(", ")
    )
}