From 1ae19eb3315c40e3f9062592c27fa76c11cf626c Mon Sep 17 00:00:00 2001
From: Joe Carstairs <me@joeac.net>
Date: Sun, 17 Nov 2024 09:23:28 +0000
Subject: Renames workspace folder

---
 .../queries/transaction_categorisations/delete_all.rs  |  7 -------
 .../src/queries/transaction_categorisations/get_all.rs | 11 -----------
 .../src/queries/transaction_categorisations/insert.rs  | 15 ---------------
 .../src/queries/transaction_categorisations/mod.rs     |  9 ---------
 .../sum_quantity_per_category_id.rs                    | 18 ------------------
 5 files changed, 60 deletions(-)
 delete mode 100644 backend/core/src/queries/transaction_categorisations/delete_all.rs
 delete mode 100644 backend/core/src/queries/transaction_categorisations/get_all.rs
 delete mode 100644 backend/core/src/queries/transaction_categorisations/insert.rs
 delete mode 100644 backend/core/src/queries/transaction_categorisations/mod.rs
 delete mode 100644 backend/core/src/queries/transaction_categorisations/sum_quantity_per_category_id.rs

(limited to 'backend/core/src/queries/transaction_categorisations')

diff --git a/backend/core/src/queries/transaction_categorisations/delete_all.rs b/backend/core/src/queries/transaction_categorisations/delete_all.rs
deleted file mode 100644
index e80a0ca..0000000
--- a/backend/core/src/queries/transaction_categorisations/delete_all.rs
+++ /dev/null
@@ -1,7 +0,0 @@
-use diesel::{result::Error, RunQueryDsl, SqliteConnection};
-
-use crate::schema::transaction_categorisations::dsl::transaction_categorisations;
-
-pub fn delete_all_transaction_categorisations(connection: &mut SqliteConnection) -> Result<usize, Error> {
-    diesel::delete(transaction_categorisations).execute(connection)
-}
diff --git a/backend/core/src/queries/transaction_categorisations/get_all.rs b/backend/core/src/queries/transaction_categorisations/get_all.rs
deleted file mode 100644
index 0cacfe6..0000000
--- a/backend/core/src/queries/transaction_categorisations/get_all.rs
+++ /dev/null
@@ -1,11 +0,0 @@
-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<Vec<TransactionCategorisation>> {
-    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/insert.rs b/backend/core/src/queries/transaction_categorisations/insert.rs
deleted file mode 100644
index 3da1c33..0000000
--- a/backend/core/src/queries/transaction_categorisations/insert.rs
+++ /dev/null
@@ -1,15 +0,0 @@
-use crate::{
-    models::transaction_categorisation::TransactionCategorisation,
-    schema::transaction_categorisations::dsl::transaction_categorisations as transaction_categorisations_table,
-};
-use diesel::prelude::*;
-use diesel::result::Error;
-
-pub fn insert_transaction_categorisations(
-    transaction_categorisations: &[TransactionCategorisation],
-    connection: &mut SqliteConnection,
-) -> Result<usize, Error> {
-    diesel::insert_into(transaction_categorisations_table)
-        .values(transaction_categorisations)
-        .execute(connection)
-}
diff --git a/backend/core/src/queries/transaction_categorisations/mod.rs b/backend/core/src/queries/transaction_categorisations/mod.rs
deleted file mode 100644
index d383791..0000000
--- a/backend/core/src/queries/transaction_categorisations/mod.rs
+++ /dev/null
@@ -1,9 +0,0 @@
-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;
diff --git a/backend/core/src/queries/transaction_categorisations/sum_quantity_per_category_id.rs b/backend/core/src/queries/transaction_categorisations/sum_quantity_per_category_id.rs
deleted file mode 100644
index 61f3492..0000000
--- a/backend/core/src/queries/transaction_categorisations/sum_quantity_per_category_id.rs
+++ /dev/null
@@ -1,18 +0,0 @@
-use crate::schema::transaction_categorisations::{
-    self as transaction_categorisations_schema,
-    dsl::transaction_categorisations as transaction_categorisations_table,
-};
-use diesel::{dsl::sum, result::Error, QueryDsl, RunQueryDsl, SqliteConnection};
-
-pub fn sum_transaction_categorisation_quantity_per_category_id(
-    connection: &mut SqliteConnection,
-) -> Result<Vec<(i32, i64)>, Error> {
-    transaction_categorisations_table
-        .group_by(transaction_categorisations_schema::category_id)
-        .select((
-            transaction_categorisations_schema::category_id,
-            sum(transaction_categorisations_schema::quantity),
-        ))
-        .load::<(i32, Option<i64>)>(connection)
-        .map(|vec| vec.iter().map(|(category_id, sum)| (*category_id, sum.unwrap_or(0))).collect())
-}
-- 
cgit v1.2.3