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

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)
}