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 axum::async_trait;
use sqlx::SqlitePool;
use crate::error::AppError;
use crate::db::product::Product;
use super::ProductDatabaseHandler;
#[derive(Debug, serde::Serialize, sqlx::FromRow)]
pub struct Story {
pub id: i64,
pub language: String,
pub pdf: Vec<u8>,
pub epub: Vec<u8>,
pub pid: i64,
}
#[async_trait]
impl ProductDatabaseHandler for Story {
async fn get_all(pool: SqlitePool) -> Result<Vec<Self>, AppError>
where
Self: Sized,
{
Ok(sqlx::query_as!(Story, "SELECT * FROM story")
.fetch_all(&pool)
.await?)
}
async fn post(&self, pool: &SqlitePool, name: String, description: String) -> Result<Self, AppError>
where
Self: Sized,
{
let time = std::time::SystemTime::now();
let uploaddate = time.duration_since(std::time::UNIX_EPOCH)?.as_millis() as i64;
let mut tx = pool.begin().await?;
let product = sqlx::query_as!(
Product,
"INSERT INTO product (name, description, uploaddate, updatedate) VALUES ($1, $2, $3, $4) RETURNING id, name, description, uploaddate, updatedate",
name,
description,
uploaddate,
uploaddate)
.fetch_one(&mut *tx)
.await?;
let story = sqlx::query_as!(
Story,
"INSERT INTO story (language, pdf, epub, pid) VALUES ($1, $2, $3, $4) RETURNING id, language, pdf, epub, pid",
self.language,
self.pdf,
self.epub,
product.id)
.fetch_one(&mut *tx)
.await?;
tx.commit().await?;
Ok(story)
}
}
|
