diff options
author | Joris | 2025-02-06 16:40:32 +0100 |
---|---|---|
committer | Joris | 2025-02-06 16:40:40 +0100 |
commit | 20f4642f9dd53f1dc399b3d54f59ea13ad69b8cd (patch) | |
tree | 6c1519d3e124e54da8bf8b3cc24c89632009068f /src/db/payments.rs | |
parent | 9244780d6c689936d8a33a0d123d0a54ee284319 (diff) |
Fix search on payment name
Diffstat (limited to 'src/db/payments.rs')
-rw-r--r-- | src/db/payments.rs | 9 |
1 files changed, 3 insertions, 6 deletions
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))); } } } |