sqlite-extras 0.1.1

Sqlite database insights
Documentation
use sqlx::{sqlite::SqliteRow, Row};

use super::shared::Query;

#[derive(Debug, Clone)]
pub struct Pragma {
    pub name: String,
    pub value: bool,
}

impl Query for Pragma {
    fn new(row: &SqliteRow) -> Self {
        Self {
            name: row.get(0),
            value: row.get(1),
        }
    }

    fn to_row(&self) -> prettytable::Row {
        row![self.name, self.value]
    }

    fn headers() -> prettytable::Row {
        row!["name", "value"]
    }

    fn read_file() -> String {
        include_str!("../sql/pragma.sql").to_string()
    }
}