nbsp 0.0.1

non-breaking space: a thoughtful community forum platform
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

//! Logic for the `nbsp_config` table

use sqlx::PgPool;

/// A select set of data from the `nbsp_config`, to be used in axum's global state
#[derive(Clone)]
pub struct NbspConfig {
    /// The canonical base URL for the running nbsp instance
    ///
    /// This should start with `https://` and be the "main" URL of the website
    ///
    /// Defaults to `https://nbsp.example.com` in the `20260816_000_initialize.up.sql` file
    pub nbsp_base_url: String,

    /// A notice to put at the top of the homepage in a yellow box
    ///
    /// If set to `NULL`/`None` no notice will be shown
    pub nbsp_homepage_notice: Option<String>,
}

impl NbspConfig {
    /// Load the [`NbspConfig`]
    pub async fn load(pool: &PgPool) -> sqlx::Result<Self> {
        let query = "SELECT key, value FROM nbsp_config;";
        let rows = sqlx::query_as::<_, (String, Option<String>)>(query)
            .fetch_all(pool)
            .await?;

        let mut config = Self {
            nbsp_base_url: String::new(),
            nbsp_homepage_notice: None,
        };

        for (key, value) in rows {
            if key == "nbsp_base_url"
                && let Some(value) = value.as_ref()
            {
                config.nbsp_base_url = value.to_string();
            }

            if key == "nbsp_homepage_notice" {
                config.nbsp_homepage_notice = value;
            }
        }

        assert!(
            !config.nbsp_base_url.is_empty(),
            "nbsp_base_url from nbsp_config is empty"
        );

        Ok(config)
    }
}