pg_extras/queries/
db_settings.rs1use 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}