summaryrefslogtreecommitdiff
path: root/backend/src/queries/transaction_categorisations
diff options
context:
space:
mode:
authorJoe Carstairs <me@joeac.net>2024-10-16 12:51:21 +0100
committerJoe Carstairs <me@joeac.net>2024-10-16 12:51:21 +0100
commit27b95c9186bd45edd4c982a7cc89cf69cf2c5d46 (patch)
treebf104ff9d64e601bfec5516eb51ef298f3095e9b /backend/src/queries/transaction_categorisations
parent76974785294089965efc3f55b2a08d4089029c52 (diff)
All backend stuff lives in backend folder
Diffstat (limited to 'backend/src/queries/transaction_categorisations')
-rw-r--r--backend/src/queries/transaction_categorisations/mod.rs3
-rw-r--r--backend/src/queries/transaction_categorisations/sum_quantity_per_category_id.rs17
-rw-r--r--backend/src/queries/transaction_categorisations/sum_quantity_per_to_category_id.rs0
3 files changed, 0 insertions, 20 deletions
diff --git a/backend/src/queries/transaction_categorisations/mod.rs b/backend/src/queries/transaction_categorisations/mod.rs
deleted file mode 100644
index d4217cc..0000000
--- a/backend/src/queries/transaction_categorisations/mod.rs
+++ /dev/null
@@ -1,3 +0,0 @@
-mod sum_quantity_per_category_id;
-
-pub use sum_quantity_per_category_id::sum_transaction_categorisation_quantity_per_category_id;
diff --git a/backend/src/queries/transaction_categorisations/sum_quantity_per_category_id.rs b/backend/src/queries/transaction_categorisations/sum_quantity_per_category_id.rs
deleted file mode 100644
index 7f93e0c..0000000
--- a/backend/src/queries/transaction_categorisations/sum_quantity_per_category_id.rs
+++ /dev/null
@@ -1,17 +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, Option<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)
-}
diff --git a/backend/src/queries/transaction_categorisations/sum_quantity_per_to_category_id.rs b/backend/src/queries/transaction_categorisations/sum_quantity_per_to_category_id.rs
deleted file mode 100644
index e69de29..0000000
--- a/backend/src/queries/transaction_categorisations/sum_quantity_per_to_category_id.rs
+++ /dev/null