2 files changed, 5 insertions, 3 deletions
diff --git a/backend/core/src/queries/budget_updates/get_first_with_date.rs b/backend/core/src/queries/budget_updates/get_first_with_date_and_category_id.rs
index 0d5b2e1..2d8f97c 100644
--- a/backend/core/src/queries/budget_updates/get_first_with_date.rs
+++ b/backend/core/src/queries/budget_updates/get_first_with_date_and_category_id.rs
@@ -9,13 +9,15 @@ use diesel::{
     ExpressionMethods, OptionalExtension, QueryDsl, RunQueryDsl, SelectableHelper, SqliteConnection
 };
 
-pub fn get_first_budget_update_with_date(
+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()))?;
diff --git a/backend/core/src/queries/budget_updates/mod.rs b/backend/core/src/queries/budget_updates/mod.rs
index 337197e..6fc7de0 100644
--- a/backend/core/src/queries/budget_updates/mod.rs
+++ b/backend/core/src/queries/budget_updates/mod.rs
@@ -1,11 +1,11 @@
 mod delete_all;
 mod get_all;
-mod get_first_with_date;
+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::get_first_budget_update_with_date;
+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;