From cd269b3540fb5e3a988c1b59d3763db360b1fb34 Mon Sep 17 00:00:00 2001 From: Joe Carstairs Date: Tue, 17 Sep 2024 13:20:04 +0100 Subject: many, many changes --- .../queries/budget_updates/get_most_recent_with_category_id.rs | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) (limited to 'backend/src/queries/budget_updates') 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 index a52e592..4753092 100644 --- 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 @@ -1,5 +1,8 @@ -use crate::schema::budget_updates::{ - self as budget_updates_schema, dsl::budget_updates as budget_updates_table, +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}; @@ -10,5 +13,6 @@ pub fn get_most_recent_budget_update_date_with_category_id( 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) } -- cgit v1.2.3