diff options
| author | Joe Carstairs <jcarstairs@scottlogic.com> | 2025-07-28 13:22:53 +0100 |
|---|---|---|
| committer | Joe Carstairs <jcarstairs@scottlogic.com> | 2025-07-28 13:30:27 +0100 |
| commit | 2361adeb0ca77904138e3466d51c2f44cf6df613 (patch) | |
| tree | f6e7192908f99fab62061913d8a1e9d2b918414b /schist_queries/src/transactions.rs | |
| parent | c7ed1e61ce2218be0b9e60577454124c4e43a366 (diff) | |
Tidier folders
Diffstat (limited to 'schist_queries/src/transactions.rs')
| -rw-r--r-- | schist_queries/src/transactions.rs | 41 |
1 files changed, 0 insertions, 41 deletions
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<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(", ") - ) -} |
