1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
|
use sqlx::sqlite::SqlitePool;
use crate::{task::Task, Result};
struct Db {
pool: SqlitePool,
}
impl Db {
pub async fn create_task(&self, task: Task) -> Result<Task> {
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();
for category in task.categories.clone() {
let category_id = sqlx::query!(
"insert or ignore into categories ( name ) values ( ?1 )",
category
)
.execute(&self.pool)
.await?
.last_insert_rowid();
sqlx::query!(
"insert into tasks_categories ( task_id, category_id ) values ( ?1, ?2 )",
id,
category_id
)
.execute(&self.pool)
.await?;
}
Ok(task.add_id(id))
}
pub async fn read_tasks(&self, select: Vec<TaskSelect>) -> Result<Vec<Task>> {
Ok(sqlx::query!("select * from tasks")
.fetch_all(&self.pool)
.await?)
}
pub async fn update_tasks(&self, select: Vec<TaskSelect>) -> Result<()> {
todo!()
}
pub async fn delete_tasks(&self, select: Vec<TaskSelect>) -> Result<()> {
todo!()
}
}
pub enum TaskSelect {
Name(String),
Archived(bool),
Category(String),
}
|
