summaryrefslogtreecommitdiff
path: root/backend/src/queries/budget_updates
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/budget_updates
parent76974785294089965efc3f55b2a08d4089029c52 (diff)
All backend stuff lives in backend folder
Diffstat (limited to 'backend/src/queries/budget_updates')
-rw-r--r--backend/src/queries/budget_updates/get_all.rs13
-rw-r--r--backend/src/queries/budget_updates/get_first_with_date.rs19
-rw-r--r--backend/src/queries/budget_updates/get_most_recent_with_category_id.rs18
-rw-r--r--backend/src/queries/budget_updates/mod.rs7
4 files changed, 0 insertions, 57 deletions
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<Vec<BudgetUpdate>, Error> {
- budget_updates_table
- .select(BudgetUpdate::as_select())
- .load::<BudgetUpdate>(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<BudgetUpdate, Error> {
- 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<Option<String>, 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;