Skip to main content

pg_extras/queries/
db_settings.rs

1use crate::{queries::shared::Query, PgStatsVersion};
2use sqlx::{postgres::PgRow, Row};
3
4#[derive(Debug, Clone, serde::Serialize)]
5pub struct DbSettings {
6    pub name: String,
7    pub setting: String,
8    pub unit: String,
9    pub short_desc: String,
10}
11
12impl Query for DbSettings {
13    fn new(row: &PgRow) -> Self {
14        Self {
15            name: row.try_get("name").unwrap_or_default(),
16            setting: row.try_get("setting").unwrap_or_default(),
17            unit: row.try_get("unit").unwrap_or_default(),
18            short_desc: row.try_get("short_desc").unwrap_or_default(),
19        }
20    }
21
22    fn to_row(&self) -> prettytable::Row {
23        row![self.name, self.setting, self.unit, self.short_desc]
24    }
25
26    fn headers() -> prettytable::Row {
27        row!["name", "setting", "unit", "short_desc"]
28    }
29
30    fn read_file(_pg_statement_version: Option<PgStatsVersion>) -> String {
31        include_str!("../sql/db_settings.sql").to_string()
32    }
33}