summaryrefslogtreecommitdiff
path: root/backend/core/src/queries/budget_updates
diff options
context:
space:
mode:
authorJoe Carstairs <me@joeac.net>2024-11-17 09:23:28 +0000
committerJoe Carstairs <me@joeac.net>2024-11-17 09:23:28 +0000
commit1ae19eb3315c40e3f9062592c27fa76c11cf626c (patch)
tree09d9ce380795971f4b50e1d4b0ca3c57c9e1db1a /backend/core/src/queries/budget_updates
parent1a494937021561595d0fb29e26fb707aef9e55de (diff)
Renames workspace folder
Diffstat (limited to 'backend/core/src/queries/budget_updates')
-rw-r--r--backend/core/src/queries/budget_updates/delete_all.rs11
-rw-r--r--backend/core/src/queries/budget_updates/get_all.rs16
-rw-r--r--backend/core/src/queries/budget_updates/get_first_with_date_and_category_id.rs25
-rw-r--r--backend/core/src/queries/budget_updates/get_most_recent_with_category_id.rs21
-rw-r--r--backend/core/src/queries/budget_updates/insert.rs28
-rw-r--r--backend/core/src/queries/budget_updates/mod.rs11
6 files changed, 0 insertions, 112 deletions
diff --git a/backend/core/src/queries/budget_updates/delete_all.rs b/backend/core/src/queries/budget_updates/delete_all.rs
deleted file mode 100644
index b7ad082..0000000
--- a/backend/core/src/queries/budget_updates/delete_all.rs
+++ /dev/null
@@ -1,11 +0,0 @@
-use anyhow::{Context, Result};
-use diesel::{RunQueryDsl, SqliteConnection};
-
-use crate::schema::budget_updates::dsl::budget_updates;
-
-pub fn delete_all_budget_updates(connection: &mut SqliteConnection) -> Result<usize> {
- let num_rows_deleted = diesel::delete(budget_updates)
- .execute(connection)
- .with_context(|| "failed to delete all budget updates")?;
- Ok(num_rows_deleted)
-}
diff --git a/backend/core/src/queries/budget_updates/get_all.rs b/backend/core/src/queries/budget_updates/get_all.rs
deleted file mode 100644
index 9c9310b..0000000
--- a/backend/core/src/queries/budget_updates/get_all.rs
+++ /dev/null
@@ -1,16 +0,0 @@
-use anyhow::{Context, Result};
-use crate::{
- models::budget_update::BudgetUpdate,
- schema::budget_updates::dsl::budget_updates as budget_updates_table,
-};
-use diesel::{QueryDsl, RunQueryDsl, SelectableHelper, SqliteConnection};
-
-pub fn get_all_budget_updates(
- connection: &mut SqliteConnection,
-) -> Result<Vec<BudgetUpdate>> {
- let all_budget_updates = budget_updates_table
- .select(BudgetUpdate::as_select())
- .load::<BudgetUpdate>(connection)
- .with_context(|| "failed to get all budget updates")?;
- Ok(all_budget_updates)
-}
diff --git a/backend/core/src/queries/budget_updates/get_first_with_date_and_category_id.rs b/backend/core/src/queries/budget_updates/get_first_with_date_and_category_id.rs
deleted file mode 100644
index 2d8f97c..0000000
--- a/backend/core/src/queries/budget_updates/get_first_with_date_and_category_id.rs
+++ /dev/null
@@ -1,25 +0,0 @@
-use anyhow::{Context, Result};
-use crate::{
- models::{budget_update::BudgetUpdate, date_utc::DateUtc},
- schema::budget_updates::{
- self as budget_updates_schema, dsl::budget_updates as budget_updates_table,
- },
-};
-use diesel::{
- ExpressionMethods, OptionalExtension, QueryDsl, RunQueryDsl, SelectableHelper, SqliteConnection
-};
-
-pub fn get_first_budget_update_with_date_and_category_id(
- date: &DateUtc,
- category_id: i32,
- connection: &mut SqliteConnection,
-) -> Result<Option<BudgetUpdate>> {
- let first_budget_update = budget_updates_table
- .select(BudgetUpdate::as_select())
- .filter(budget_updates_schema::date.eq(date.to_string()))
- .filter(budget_updates_schema::category_id.eq(category_id))
- .first(connection)
- .optional()
- .with_context(|| format!("failed to get first budget update with date {}", date.to_string()))?;
- Ok(first_budget_update)
-}
diff --git a/backend/core/src/queries/budget_updates/get_most_recent_with_category_id.rs b/backend/core/src/queries/budget_updates/get_most_recent_with_category_id.rs
deleted file mode 100644
index 41ef5ec..0000000
--- a/backend/core/src/queries/budget_updates/get_most_recent_with_category_id.rs
+++ /dev/null
@@ -1,21 +0,0 @@
-use anyhow::{Context, Result};
-use crate::{
- models::date_utc::DateUtc,
- schema::budget_updates::{
- self as budget_updates_schema, dsl::budget_updates as budget_updates_table,
- }, traits::nowlike::Nowlike,
-};
-use diesel::{dsl::max, ExpressionMethods, QueryDsl, RunQueryDsl, SqliteConnection};
-
-pub fn get_most_recent_budget_update_date_with_category_id(
- category_id: i32,
- connection: &mut SqliteConnection,
-) -> Result<Option<DateUtc>> {
- let most_recent_date = budget_updates_table
- .select(max(budget_updates_schema::date))
- .filter(budget_updates_schema::category_id.eq(category_id))
- .filter(budget_updates_schema::date.le(DateUtc::now()))
- .first(connection)
- .with_context(|| format!("failed to get most recent budget update date with category ID {}", category_id))?;
- Ok(most_recent_date)
-}
diff --git a/backend/core/src/queries/budget_updates/insert.rs b/backend/core/src/queries/budget_updates/insert.rs
deleted file mode 100644
index e8ae271..0000000
--- a/backend/core/src/queries/budget_updates/insert.rs
+++ /dev/null
@@ -1,28 +0,0 @@
-use anyhow::{Context, Result};
-use crate::{
- models::budget_update::BudgetUpdate,
- schema::budget_updates::dsl::budget_updates as budget_updates_table,
-};
-use diesel::prelude::*;
-
-pub fn insert_budget_updates(
- budget_updates: &[BudgetUpdate],
- connection: &mut SqliteConnection,
-) -> Result<usize> {
- let num_rows_inserted = diesel::insert_into(budget_updates_table)
- .values(budget_updates)
- .execute(connection)
- .with_context(|| err_msg(budget_updates))?;
- Ok(num_rows_inserted)
-}
-
-fn err_msg(budget_updates: &[BudgetUpdate]) -> String {
- format!(
- "failed to insert budget updates: [{}]",
- budget_updates
- .iter()
- .map(|a| a.id.to_string())
- .collect::<Vec<String>>()
- .join(", ")
- )
-}
diff --git a/backend/core/src/queries/budget_updates/mod.rs b/backend/core/src/queries/budget_updates/mod.rs
deleted file mode 100644
index 6fc7de0..0000000
--- a/backend/core/src/queries/budget_updates/mod.rs
+++ /dev/null
@@ -1,11 +0,0 @@
-mod delete_all;
-mod get_all;
-mod get_first_with_date_and_category_id;
-mod get_most_recent_with_category_id;
-mod insert;
-
-pub use delete_all::delete_all_budget_updates;
-pub use get_all::get_all_budget_updates;
-pub use get_first_with_date_and_category_id::get_first_budget_update_with_date_and_category_id;
-pub use get_most_recent_with_category_id::get_most_recent_budget_update_date_with_category_id;
-pub use insert::insert_budget_updates;