systemprompt-content 0.63.0

Markdown content management, sources, and event tracking for systemprompt.io AI governance dashboards. Governed publishing pipeline for the MCP governance platform.
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
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
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113

//! Content repository.
//!
//! [`ContentRepository`] is the data-access surface for the `markdown_content`
//! table, splitting read paths (queries) from write paths (mutations) and
//! routing each to the read or write pool accordingly.
//!
//! Copyright (c) systemprompt.io — Business Source License 1.1.
//! See <https://systemprompt.io> for licensing details.

mod mutations;
mod queries;
mod stats;

use crate::models::{Content, CreateContentParams, UpdateContentParams};
use sqlx::PgPool;
use std::sync::Arc;
use systemprompt_database::DbPool;
use systemprompt_identifiers::{CategoryId, ContentId, LocaleCode, SourceId};

#[derive(Debug, Clone)]
pub struct ContentRepository {
    pool: Arc<PgPool>,
    write_pool: Arc<PgPool>,
}

impl ContentRepository {
    pub fn new(db: &DbPool) -> Self {
        let pool = db.pool();
        let write_pool = db.write_pool();
        Self { pool, write_pool }
    }

    pub async fn create(&self, params: &CreateContentParams) -> Result<Content, sqlx::Error> {
        mutations::create(&self.write_pool, params).await
    }

    pub async fn find_by_id(&self, id: &ContentId) -> Result<Option<Content>, sqlx::Error> {
        queries::find_by_id(&self.pool, id).await
    }

    pub async fn find_by_slug(
        &self,
        slug: &str,
        locale: &LocaleCode,
    ) -> Result<Option<Content>, sqlx::Error> {
        queries::find_by_slug(&self.pool, slug, locale).await
    }

    pub async fn find_by_source_and_slug(
        &self,
        source_id: &SourceId,
        slug: &str,
        locale: &LocaleCode,
    ) -> Result<Option<Content>, sqlx::Error> {
        queries::find_by_source_and_slug(&self.pool, source_id, slug, locale).await
    }

    pub async fn list(&self, limit: i64, offset: i64) -> Result<Vec<Content>, sqlx::Error> {
        queries::list(&self.pool, limit, offset).await
    }

    pub async fn list_by_source(
        &self,
        source_id: &SourceId,
        locale: &LocaleCode,
    ) -> Result<Vec<Content>, sqlx::Error> {
        queries::list_by_source(&self.pool, source_id, locale).await
    }

    pub async fn list_by_source_limited(
        &self,
        source_id: &SourceId,
        locale: &LocaleCode,
        limit: i64,
    ) -> Result<Vec<Content>, sqlx::Error> {
        queries::list_by_source_limited(&self.pool, source_id, locale, limit).await
    }

    pub async fn list_sources_by_slug(
        &self,
        slug: &str,
        locale: &LocaleCode,
    ) -> Result<Vec<SourceId>, sqlx::Error> {
        queries::list_sources_by_slug(&self.pool, slug, locale).await
    }

    pub async fn list_slugs_with_locales_by_source(
        &self,
        source_id: &SourceId,
    ) -> Result<Vec<(String, LocaleCode)>, sqlx::Error> {
        queries::list_slugs_with_locales_by_source(&self.pool, source_id).await
    }

    pub async fn update(&self, params: &UpdateContentParams) -> Result<Content, sqlx::Error> {
        mutations::update(&self.write_pool, params).await
    }

    pub async fn category_exists(&self, category_id: &CategoryId) -> Result<bool, sqlx::Error> {
        queries::category_exists(&self.pool, category_id).await
    }

    pub async fn delete(&self, id: &ContentId) -> Result<(), sqlx::Error> {
        mutations::delete(&self.write_pool, id).await
    }

    pub async fn delete_by_source(&self, source_id: &SourceId) -> Result<u64, sqlx::Error> {
        mutations::delete_by_source(&self.write_pool, source_id).await
    }

    pub async fn list_all(&self, limit: i64, offset: i64) -> Result<Vec<Content>, sqlx::Error> {
        queries::list_all(&self.pool, limit, offset).await
    }
}