aboutsummaryrefslogtreecommitdiff
path: root/src/db/categories.rs
diff options
context:
space:
mode:
Diffstat (limited to 'src/db/categories.rs')
-rw-r--r--src/db/categories.rs19
1 files changed, 8 insertions, 11 deletions
diff --git a/src/db/categories.rs b/src/db/categories.rs
index 31cb3d0..abcba59 100644
--- a/src/db/categories.rs
+++ b/src/db/categories.rs
@@ -1,4 +1,4 @@
-use tokio_rusqlite::{named_params, Connection, Row};
+use tokio_rusqlite::{Connection, Row, named_params};
use crate::db::utils;
use crate::model::category::{Category, Create, Update};
@@ -26,11 +26,8 @@ pub async fn list(conn: &Connection) -> Vec<Category> {
.call(move |conn| {
let mut stmt = conn.prepare(query)?;
- let users = stmt
- .query_map([], row_to_category)?
- .collect::<Result<Vec<Category>, _>>()?;
-
- Ok(users)
+ stmt.query_map([], row_to_category)?
+ .collect::<Result<Vec<Category>, _>>()
})
.await;
@@ -76,7 +73,7 @@ pub async fn get(conn: &Connection, id: i64) -> Option<Category> {
pub async fn create(conn: &Connection, c: Create) -> Option<i64> {
let query = r#"INSERT INTO categories(name, color) VALUES (:name, :color)"#;
- let res = conn
+ let res: Result<_, tokio_rusqlite::Error<rusqlite::Error>> = conn
.call(move |conn| {
conn.execute(
query,
@@ -107,10 +104,10 @@ pub async fn update(conn: &Connection, id: i64, c: Update) -> bool {
let res = conn
.call(move |conn| {
- Ok(conn.execute(
+ conn.execute(
query,
named_params![":name": c.name, ":color": c.color, ":id": id],
- )?)
+ )
})
.await;
@@ -126,7 +123,7 @@ pub async fn update(conn: &Connection, id: i64, c: Update) -> bool {
pub async fn delete(conn: &Connection, id: i64) -> bool {
let res = conn
.call(move |conn| {
- Ok(conn.execute(
+ conn.execute(
r#"
UPDATE
categories
@@ -136,7 +133,7 @@ pub async fn delete(conn: &Connection, id: i64) -> bool {
id = :id
"#,
named_params![":id": id],
- )?)
+ )
})
.await;