diff options
Diffstat (limited to 'backend/src/queries/category_transfers')
3 files changed, 0 insertions, 39 deletions
diff --git a/backend/src/queries/category_transfers/mod.rs b/backend/src/queries/category_transfers/mod.rs deleted file mode 100644 index 85eb1c8..0000000 --- a/backend/src/queries/category_transfers/mod.rs +++ /dev/null @@ -1,5 +0,0 @@ -mod sum_quantity_per_from_category_id; -mod sum_quantity_per_to_category_id; - -pub use sum_quantity_per_from_category_id::sum_category_transfer_quantity_per_from_category_id; -pub use sum_quantity_per_to_category_id::sum_category_transfer_quantity_per_to_category_id; diff --git a/backend/src/queries/category_transfers/sum_quantity_per_from_category_id.rs b/backend/src/queries/category_transfers/sum_quantity_per_from_category_id.rs deleted file mode 100644 index ae3a51a..0000000 --- a/backend/src/queries/category_transfers/sum_quantity_per_from_category_id.rs +++ /dev/null @@ -1,17 +0,0 @@ -use diesel::{dsl::sum, result::Error, QueryDsl, RunQueryDsl, SqliteConnection}; - -use crate::schema::category_transfers::{ - self as category_transfers_schema, dsl::category_transfers as category_transfers_table, -}; - -pub fn sum_category_transfer_quantity_per_from_category_id( - connection: &mut SqliteConnection, -) -> Result<Vec<(i32, Option<i64>)>, Error> { - category_transfers_table - .group_by(category_transfers_schema::from_category_id) - .select(( - category_transfers_schema::from_category_id, - sum(category_transfers_schema::quantity), - )) - .load::<(i32, Option<i64>)>(connection) -} diff --git a/backend/src/queries/category_transfers/sum_quantity_per_to_category_id.rs b/backend/src/queries/category_transfers/sum_quantity_per_to_category_id.rs deleted file mode 100644 index fe6f3a7..0000000 --- a/backend/src/queries/category_transfers/sum_quantity_per_to_category_id.rs +++ /dev/null @@ -1,17 +0,0 @@ -use diesel::{dsl::sum, result::Error, QueryDsl, RunQueryDsl, SqliteConnection}; - -use crate::schema::category_transfers::{ - self as category_transfers_schema, dsl::category_transfers as category_transfers_table, -}; - -pub fn sum_category_transfer_quantity_per_to_category_id( - connection: &mut SqliteConnection, -) -> Result<Vec<(i32, Option<i64>)>, Error> { - category_transfers_table - .group_by(category_transfers_schema::to_category_id) - .select(( - category_transfers_schema::to_category_id, - sum(category_transfers_schema::quantity), - )) - .load::<(i32, Option<i64>)>(connection) -} |