From 27b95c9186bd45edd4c982a7cc89cf69cf2c5d46 Mon Sep 17 00:00:00 2001 From: Joe Carstairs Date: Wed, 16 Oct 2024 12:51:21 +0100 Subject: All backend stuff lives in backend folder --- backend/src/queries/budget_updates/get_all.rs | 13 ------------- .../src/queries/budget_updates/get_first_with_date.rs | 19 ------------------- .../get_most_recent_with_category_id.rs | 18 ------------------ backend/src/queries/budget_updates/mod.rs | 7 ------- 4 files changed, 57 deletions(-) delete mode 100644 backend/src/queries/budget_updates/get_all.rs delete mode 100644 backend/src/queries/budget_updates/get_first_with_date.rs delete mode 100644 backend/src/queries/budget_updates/get_most_recent_with_category_id.rs delete mode 100644 backend/src/queries/budget_updates/mod.rs (limited to 'backend/src/queries/budget_updates') diff --git a/backend/src/queries/budget_updates/get_all.rs b/backend/src/queries/budget_updates/get_all.rs deleted file mode 100644 index 97f2f2f..0000000 --- a/backend/src/queries/budget_updates/get_all.rs +++ /dev/null @@ -1,13 +0,0 @@ -use crate::{ - models::budget_update::BudgetUpdate, - schema::budget_updates::dsl::budget_updates as budget_updates_table, -}; -use diesel::{result::Error, QueryDsl, RunQueryDsl, SelectableHelper, SqliteConnection}; - -pub fn get_all_budget_updates( - connection: &mut SqliteConnection, -) -> Result, Error> { - budget_updates_table - .select(BudgetUpdate::as_select()) - .load::(connection) -} diff --git a/backend/src/queries/budget_updates/get_first_with_date.rs b/backend/src/queries/budget_updates/get_first_with_date.rs deleted file mode 100644 index a2824be..0000000 --- a/backend/src/queries/budget_updates/get_first_with_date.rs +++ /dev/null @@ -1,19 +0,0 @@ -use crate::{ - models::budget_update::BudgetUpdate, - schema::budget_updates::{ - self as budget_updates_schema, dsl::budget_updates as budget_updates_table, - }, -}; -use diesel::{ - result::Error, ExpressionMethods, QueryDsl, RunQueryDsl, SelectableHelper, SqliteConnection, -}; - -pub fn get_first_budget_update_with_date( - date: &str, - connection: &mut SqliteConnection, -) -> Result { - budget_updates_table - .select(BudgetUpdate::as_select()) - .filter(budget_updates_schema::date.eq(date)) - .first(connection) -} diff --git a/backend/src/queries/budget_updates/get_most_recent_with_category_id.rs b/backend/src/queries/budget_updates/get_most_recent_with_category_id.rs deleted file mode 100644 index 4753092..0000000 --- a/backend/src/queries/budget_updates/get_most_recent_with_category_id.rs +++ /dev/null @@ -1,18 +0,0 @@ -use crate::{ - models::date_time_utc::DateTimeUtc, - schema::budget_updates::{ - self as budget_updates_schema, dsl::budget_updates as budget_updates_table, - }, -}; -use diesel::{dsl::max, result::Error, ExpressionMethods, QueryDsl, RunQueryDsl, SqliteConnection}; - -pub fn get_most_recent_budget_update_date_with_category_id( - category_id: i32, - connection: &mut SqliteConnection, -) -> Result, Error> { - budget_updates_table - .select(max(budget_updates_schema::date)) - .filter(budget_updates_schema::category_id.eq(category_id)) - .filter(budget_updates_schema::date.le(DateTimeUtc::now().to_day_str())) - .first(connection) -} diff --git a/backend/src/queries/budget_updates/mod.rs b/backend/src/queries/budget_updates/mod.rs deleted file mode 100644 index 3b514dd..0000000 --- a/backend/src/queries/budget_updates/mod.rs +++ /dev/null @@ -1,7 +0,0 @@ -mod get_all; -mod get_first_with_date; -mod get_most_recent_with_category_id; - -pub use get_all::get_all_budget_updates; -pub use get_first_with_date::get_first_budget_update_with_date; -pub use get_most_recent_with_category_id::get_most_recent_budget_update_date_with_category_id; -- cgit v1.2.3