headless_lms_models/
partner_block.rs

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
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
use crate::prelude::*;

#[derive(Debug, Serialize, Deserialize, PartialEq, Clone)]
#[cfg_attr(feature = "ts_rs", derive(TS))]
pub struct PartnersBlock {
    pub id: Uuid,
    pub created_at: DateTime<Utc>,
    pub updated_at: DateTime<Utc>,
    pub deleted_at: Option<DateTime<Utc>>,
    pub content: serde_json::Value,
    pub course_id: Uuid,
}

#[derive(Debug, Serialize, Deserialize, PartialEq, Clone)]
#[cfg_attr(feature = "ts_rs", derive(TS))]
pub struct PartnerBlockNew {
    pub course_id: Uuid,
    pub content: Option<serde_json::Value>,
}

pub async fn upsert_partner_block(
    conn: &mut PgConnection,
    course_id: Uuid,
    content: Option<serde_json::Value>,
) -> ModelResult<PartnersBlock> {
    let res = sqlx::query_as!(
        PartnersBlock,
        r#"
INSERT INTO partners_blocks (course_id, content)
VALUES ($1, $2)
ON CONFLICT (course_id)
DO UPDATE
SET content = EXCLUDED.content
RETURNING *
"#,
        course_id,
        content,
    )
    .fetch_one(conn)
    .await?;
    Ok(res)
}

pub async fn get_partner_block(
    conn: &mut PgConnection,
    course_id: Uuid,
) -> ModelResult<PartnersBlock> {
    let res = sqlx::query_as!(
        PartnersBlock,
        "SELECT *
FROM partners_blocks
WHERE course_id = $1
  AND deleted_at IS NULL",
        course_id
    )
    .fetch_one(conn)
    .await?;
    Ok(res)
}

pub async fn delete_partner_block(
    conn: &mut PgConnection,
    course_id: Uuid,
) -> ModelResult<PartnersBlock> {
    let deleted = sqlx::query_as!(
        PartnersBlock,
        r#"
UPDATE partners_blocks
SET deleted_at = now()
WHERE course_id = $1
RETURNING *
  "#,
        course_id
    )
    .fetch_one(conn)
    .await?;
    Ok(deleted)
}

pub async fn check_if_course_exists(
    conn: &mut PgConnection,
    course_id: Uuid,
) -> Result<bool, sqlx::Error> {
    let exists = sqlx::query!(
        r#"
        SELECT 1 AS exists
        FROM partners_blocks
        WHERE course_id = $1
        LIMIT 1
        "#,
        course_id
    )
    .fetch_optional(conn)
    .await?;
    Ok(exists.is_some())
}