From c3fde18b74fa967a02b3a922a9a3554b80207b06 Mon Sep 17 00:00:00 2001
From: cel 🌸 <cel@blos.sm>
Date: Sun, 4 Aug 2024 18:26:38 +0100
Subject: WIP: db

---
 src/db.rs | 28 ++++++++++++++++++++++++++++
 1 file changed, 28 insertions(+)
 create mode 100644 src/db.rs

(limited to 'src/db.rs')

diff --git a/src/db.rs b/src/db.rs
new file mode 100644
index 0000000..dd35e4d
--- /dev/null
+++ b/src/db.rs
@@ -0,0 +1,28 @@
+use sqlx::sqlite::SqlitePool;
+
+use crate::{task::Task, Result};
+
+struct Db {
+    pool: SqlitePool,
+}
+
+impl Db {
+    pub async fn create_task(&self, task: Task) -> Result<i64> {
+        let id = sqlx::query!(
+            "insert into tasks ( name, cron, archived, description ) values ( ?1, ?2, ?3, ?4 )",
+            task.name,
+            task.cron,
+            task.archived,
+            task.description
+        )
+        .execute(&self.pool)
+        .await?
+        .last_insert_rowid();
+
+        Ok(id)
+    }
+
+    pub async fn read_tasks(&self) -> Result<Vec<Task>> {
+        todo!()
+    }
+}
-- 
cgit