aboutsummaryrefslogtreecommitdiff
path: root/src/db/categories.rs
diff options
context:
space:
mode:
authorJoris2025-02-07 11:12:56 +0100
committerJoris2025-02-07 11:12:56 +0100
commit99f483927b1b8dd96be5846f338d37a37ab667ec (patch)
tree22f38fb549b7d7babb7e51c8677fe6a6aaa81638 /src/db/categories.rs
parenta217f4c75def40889710cfcf776ff827745fb6ff (diff)
Use named_params in queriermain
Diffstat (limited to 'src/db/categories.rs')
-rw-r--r--src/db/categories.rs4
1 files changed, 2 insertions, 2 deletions
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 })
}