From 6e9f0069f5d1e4cfbf7f9feb8536795a78c818f6 Mon Sep 17 00:00:00 2001 From: Joe Carstairs Date: Mon, 28 Oct 2024 07:52:51 +0000 Subject: Integration tests for basic CRD queries --- .../core/src/queries/transaction_categorisations/get_all.rs | 11 +++++++++++ backend/core/src/queries/transaction_categorisations/mod.rs | 2 ++ 2 files changed, 13 insertions(+) create mode 100644 backend/core/src/queries/transaction_categorisations/get_all.rs (limited to 'backend/core/src/queries/transaction_categorisations') diff --git a/backend/core/src/queries/transaction_categorisations/get_all.rs b/backend/core/src/queries/transaction_categorisations/get_all.rs new file mode 100644 index 0000000..0cacfe6 --- /dev/null +++ b/backend/core/src/queries/transaction_categorisations/get_all.rs @@ -0,0 +1,11 @@ +use anyhow::{Context, Result}; +use crate::{models::transaction_categorisation::TransactionCategorisation, schema::transaction_categorisations::dsl::transaction_categorisations as transaction_categorisations_table}; +use diesel::{QueryDsl, RunQueryDsl, SelectableHelper, SqliteConnection}; + +pub fn get_all_transaction_categorisations(connection: &mut SqliteConnection) -> Result> { + let all_transaction_categorisations = transaction_categorisations_table + .select(TransactionCategorisation::as_select()) + .load(connection) + .with_context(|| "failed to get all transaction categorisations")?; + Ok(all_transaction_categorisations) +} diff --git a/backend/core/src/queries/transaction_categorisations/mod.rs b/backend/core/src/queries/transaction_categorisations/mod.rs index 3664fa6..d383791 100644 --- a/backend/core/src/queries/transaction_categorisations/mod.rs +++ b/backend/core/src/queries/transaction_categorisations/mod.rs @@ -1,7 +1,9 @@ mod delete_all; +mod get_all; mod insert; mod sum_quantity_per_category_id; pub use delete_all::delete_all_transaction_categorisations; +pub use get_all::get_all_transaction_categorisations; pub use insert::insert_transaction_categorisations; pub use sum_quantity_per_category_id::sum_transaction_categorisation_quantity_per_category_id; -- cgit v1.2.3