From 2361adeb0ca77904138e3466d51c2f44cf6df613 Mon Sep 17 00:00:00 2001 From: Joe Carstairs Date: Mon, 28 Jul 2025 13:22:53 +0100 Subject: Tidier folders --- schist_queries/src/transactions.rs | 41 -------------------------------------- 1 file changed, 41 deletions(-) delete mode 100644 schist_queries/src/transactions.rs (limited to 'schist_queries/src/transactions.rs') diff --git a/schist_queries/src/transactions.rs b/schist_queries/src/transactions.rs deleted file mode 100644 index 70b14e7..0000000 --- a/schist_queries/src/transactions.rs +++ /dev/null @@ -1,41 +0,0 @@ -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 { - 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> { - 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 { - 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::>() - .join(", ") - ) -} -- cgit v1.2.3