From 20f4642f9dd53f1dc399b3d54f59ea13ad69b8cd Mon Sep 17 00:00:00 2001 From: Joris Date: Thu, 6 Feb 2025 16:40:32 +0100 Subject: Fix search on payment name --- src/db/payments.rs | 9 +++------ 1 file changed, 3 insertions(+), 6 deletions(-) (limited to 'src/db/payments.rs') diff --git a/src/db/payments.rs b/src/db/payments.rs index 4a6774c..93b815f 100644 --- a/src/db/payments.rs +++ b/src/db/payments.rs @@ -61,9 +61,7 @@ pub async fn count( payment_query: &queries::Payments, ) -> Count { let mut query = r#" - SELECT - COUNT(*) AS count, - SUM(payments.cost) AS total_cost + SELECT COUNT(*), SUM(payments.cost) FROM payments INNER JOIN users ON users.id = payments.user_id INNER JOIN categories ON categories.id = payments.category_id @@ -85,8 +83,7 @@ pub async fn count( match res { Ok(count) => count, - Err(err) => { - log::error!("Error counting payments: {:?}", err); + Err(_) => { Count { count: 0, total_cost: 0, @@ -192,7 +189,7 @@ fn complete_name( ) .as_str(), ); - params.push(Box::new(name)); + params.push(Box::new(text::format_search(&name))); } } } -- cgit v1.2.3