kitx 0.0.18

A lightweight wrapper for database operations based on sqlx, enabling fast CRUD operations.
Documentation 
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

use field_access::FieldAccess;
use serde::{Deserialize, Serialize};
use sqlx::FromRow;
use std::fmt::Debug;

// Article
#[derive(Debug, Serialize, Deserialize, Default, FromRow, FieldAccess, Clone, PartialEq, Hash)]
//#[serde(rename_all = "camelCase")]
pub struct Article {
    pub id: i32,
    pub tenant_id: i32,
    pub title: String,
    #[serde(skip_serializing_if = "Option::is_none")]
    pub content: Option<String>,
    #[serde(default)]
    pub views: i32,
    #[serde(default)]
    pub deleted: bool,
    pub created_at: Option<chrono::NaiveDateTime>,
}

impl Article {
    pub fn new(
        tenant_id: i32,
        title: &str,
        content: Option<String>,
    ) -> Self {
        Article {
            tenant_id,
            title: title.to_string(),
            content,
            created_at: Some(chrono::Local::now().naive_local()),
            ..Default::default()
        }
    }
}

#[derive(Debug, Serialize, Deserialize, Default, FromRow, FieldAccess, Clone, PartialEq, Hash)]
//#[serde(rename_all = "camelCase")]
pub struct ArticleTag {
    pub article_id: i32,
    pub share_seq: i32,
    pub tag: String,
    pub created_at: Option<chrono::NaiveDateTime>,
}

#[cfg(any(feature = "mysql", feature = "sqlite", feature = "postgres"))]
impl ArticleTag {
    pub fn new(
        tag: &str,
    ) -> Self {
        ArticleTag {
            tag: tag.to_string(),
            ..Default::default()
        }
    }
}