sqlite-extras 0.1.1

Sqlite database insights
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

use sqlx::{sqlite::SqliteRow, Row};

use super::shared::Query;

#[derive(Debug, Clone)]
pub struct SequenceNumber {
    pub table_name: String,
    pub seq: u64,
}

impl Query for SequenceNumber {
    fn new(row: &SqliteRow) -> Self {
        Self {
            table_name: row.get(0),
            seq: row.get(1),
        }
    }

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

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

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