summaryrefslogtreecommitdiff
path: root/backend/core/tests/queries/transaction_categorisations.rs
diff options
context:
space:
mode:
authorJoe Carstairs <me@joeac.net>2024-11-17 09:23:28 +0000
committerJoe Carstairs <me@joeac.net>2024-11-17 09:23:28 +0000
commit1ae19eb3315c40e3f9062592c27fa76c11cf626c (patch)
tree09d9ce380795971f4b50e1d4b0ca3c57c9e1db1a /backend/core/tests/queries/transaction_categorisations.rs
parent1a494937021561595d0fb29e26fb707aef9e55de (diff)
Renames workspace folder
Diffstat (limited to 'backend/core/tests/queries/transaction_categorisations.rs')
-rw-r--r--backend/core/tests/queries/transaction_categorisations.rs127
1 files changed, 0 insertions, 127 deletions
diff --git a/backend/core/tests/queries/transaction_categorisations.rs b/backend/core/tests/queries/transaction_categorisations.rs
deleted file mode 100644
index 123ee6e..0000000
--- a/backend/core/tests/queries/transaction_categorisations.rs
+++ /dev/null
@@ -1,127 +0,0 @@
-use budgeting_app_core::{models::{account::Account, category::Category, transaction::Transaction}, queries};
-use diesel::{Connection, SqliteConnection};
-
-use crate::common::{fakes::{account::make_fake_account, category::make_fake_category, transaction::make_fake_transaction_builder, transaction_categorisation::make_fake_transaction_categorisation_builder}, test_context::TestContext};
-
-fn given_accounts(connection: &mut SqliteConnection) -> Vec<Account> {
- let accounts = vec![make_fake_account(0)];
- let _ = queries::accounts::insert_accounts(&accounts, connection);
- accounts
-}
-
-fn given_categories(connection: &mut SqliteConnection) -> Vec<Category> {
- let categories = vec![make_fake_category(0), make_fake_category(1)];
- let _ = queries::categories::insert_categories(&categories, connection);
- categories
-}
-
-fn given_transactions(connection: &mut SqliteConnection) -> Vec<Transaction> {
- let transactions = vec![
- make_fake_transaction_builder(0).account_id(0).build().unwrap(),
- make_fake_transaction_builder(1).account_id(0).build().unwrap(),
- ];
- let _ = queries::transactions::insert_transactions(&transactions, connection);
- transactions
-}
-
-#[test]
-fn when_insert_transaction_categorisations_then_returns_num_transaction_categorisations() {
- let context = TestContext::new();
- let connection = &mut SqliteConnection::establish(&context.db_url).unwrap();
- given_accounts(connection);
- given_categories(connection);
- given_transactions(connection);
- let transaction_categorisations = [
- make_fake_transaction_categorisation_builder(0).category_id(0).build().unwrap(),
- make_fake_transaction_categorisation_builder(1).category_id(0).build().unwrap(),
- ];
-
- let num_transaction_categorisations_inserted = queries::transaction_categorisations::insert_transaction_categorisations(&transaction_categorisations, connection).unwrap();
-
- assert_eq!(num_transaction_categorisations_inserted, 2);
-}
-
-#[test]
-fn given_transaction_categorisations_when_get_all_transaction_categorisations_then_return_transaction_categorisations() {
- let context = TestContext::new();
- let connection = &mut SqliteConnection::establish(&context.db_url).unwrap();
- given_accounts(connection);
- given_categories(connection);
- given_transactions(connection);
- let transaction_categorisations = [
- make_fake_transaction_categorisation_builder(0).category_id(0).build().unwrap(),
- make_fake_transaction_categorisation_builder(1).category_id(0).build().unwrap(),
- ];
- let _ = queries::transaction_categorisations::insert_transaction_categorisations(&transaction_categorisations, connection);
-
- let transaction_categorisations_in_db = queries::transaction_categorisations::get_all_transaction_categorisations(connection).unwrap();
-
- assert_eq!(transaction_categorisations_in_db.len(), transaction_categorisations.len());
- for transaction_categorisation in &transaction_categorisations {
- assert!(transaction_categorisations_in_db.iter().any(|transaction_categorisation_in_db| transaction_categorisation_in_db.eq(&transaction_categorisation)));
- }
- for transaction_categorisation_in_db in transaction_categorisations_in_db {
- assert!(transaction_categorisations.iter().any(|transaction_categorisation| transaction_categorisation.eq(&transaction_categorisation_in_db)));
- }
-}
-
-#[test]
-fn given_transaction_categorisations_when_delete_all_transaction_categorisations_then_return_num_of_transaction_categorisations() {
- let context = TestContext::new();
- let connection = &mut SqliteConnection::establish(&context.db_url).unwrap();
- given_accounts(connection);
- given_categories(connection);
- given_transactions(connection);
- let transaction_categorisations = [
- make_fake_transaction_categorisation_builder(0).category_id(0).build().unwrap(),
- make_fake_transaction_categorisation_builder(1).category_id(0).build().unwrap(),
- ];
- let _ = queries::transaction_categorisations::insert_transaction_categorisations(&transaction_categorisations, connection);
-
- let num_transaction_categorisations_deleted = queries::transaction_categorisations::delete_all_transaction_categorisations(connection).unwrap();
-
- assert_eq!(num_transaction_categorisations_deleted, transaction_categorisations.len());
-}
-
-#[test]
-fn given_deleted_transaction_categorisations_when_get_all_transaction_categorisations_then_return_empty() {
- let context = TestContext::new();
- let connection = &mut SqliteConnection::establish(&context.db_url).unwrap();
- given_accounts(connection);
- given_categories(connection);
- given_transactions(connection);
- let transaction_categorisations = [
- make_fake_transaction_categorisation_builder(0).category_id(0).build().unwrap(),
- make_fake_transaction_categorisation_builder(1).category_id(0).build().unwrap(),
- ];
- let _ = queries::transaction_categorisations::insert_transaction_categorisations(&transaction_categorisations, connection);
- let _ = queries::transaction_categorisations::delete_all_transaction_categorisations(connection);
-
- let transaction_categorisations_returned = queries::transaction_categorisations::get_all_transaction_categorisations(connection).unwrap();
-
- assert_eq!(transaction_categorisations_returned.len(), 0);
-}
-
-#[test]
-fn given_transaction_categorisations_when_sum_quantity_per_category_id_then_returns_sum_quantity_per_category_id() {
- let context = TestContext::new();
- let connection = &mut SqliteConnection::establish(&context.db_url).unwrap();
- given_accounts(connection);
- let categories = given_categories(connection);
- given_transactions(connection);
- let transaction_categorisations = [
- make_fake_transaction_categorisation_builder(0).category_id(0).quantity(1).build().unwrap(),
- make_fake_transaction_categorisation_builder(1).category_id(0).quantity(2).build().unwrap(),
- make_fake_transaction_categorisation_builder(2).category_id(1).quantity(4).build().unwrap(),
- ];
- let _ = queries::transaction_categorisations::insert_transaction_categorisations(&transaction_categorisations, connection);
-
- let sums = queries::transaction_categorisations::sum_transaction_categorisation_quantity_per_category_id(connection);
-
- assert!(sums.is_ok());
- let mut sums = sums.unwrap();
- sums.sort_by_key(|sum| sum.0);
- assert_eq!(categories.len(), sums.len());
- assert_eq!(3, sums[0].1);
- assert_eq!(4, sums[1].1);
-}