From 99f483927b1b8dd96be5846f338d37a37ab667ec Mon Sep 17 00:00:00 2001
From: Joris
Date: Fri, 7 Feb 2025 11:12:56 +0100
Subject: Use named_params in querier

---
 src/db/categories.rs | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'src/db/categories.rs')

diff --git a/src/db/categories.rs b/src/db/categories.rs
index ebefb6d..f81b855 100644
--- a/src/db/categories.rs
+++ b/src/db/categories.rs
@@ -5,7 +5,8 @@ use uuid::Uuid;
 use crate::model::category::Category;
 
 pub fn list(conn: &Connection) -> Result<Vec<Category>> {
-    let mut stmt = conn.prepare("SELECT id, name, color FROM categories")?;
+    let query = r#"SELECT id, name, color FROM categories"#;
+    let mut stmt = conn.prepare(query)?;
 
     let iter = stmt.query_map([], |row| {
         Ok(read_category(row.get(0)?, row.get(1)?, row.get(2)?))
@@ -20,6 +21,5 @@ pub fn list(conn: &Connection) -> Result<Vec<Category>> {
 
 fn read_category(id: String, name: String, color: String) -> Result<Category> {
     let id = Uuid::parse_str(&id)?;
-
     Ok(Category { id, name, color })
 }
-- 
cgit v1.2.3