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!()
    }
}