aboutsummaryrefslogtreecommitdiff
path: root/src/db/payments.rs
diff options
context:
space:
mode:
authorJoris2025-02-06 16:40:32 +0100
committerJoris2025-02-06 16:40:40 +0100
commit20f4642f9dd53f1dc399b3d54f59ea13ad69b8cd (patch)
tree6c1519d3e124e54da8bf8b3cc24c89632009068f /src/db/payments.rs
parent9244780d6c689936d8a33a0d123d0a54ee284319 (diff)
Fix search on payment name
Diffstat (limited to 'src/db/payments.rs')
-rw-r--r--src/db/payments.rs9
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)));
}
}
}