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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76

use clap::{Parser, Subcommand};
use sqlite_extras::{
    compile_options, index_size, integrity_check, pragma, render_table, sequence_number,
    table_size, total_size, CompileOptions, IndexSize, IntegrityCheck, Pragma, Query,
    SQExtrasError, SequenceNumber, TableSize, TotalSize,
};

#[derive(Parser, Debug)]
#[command(
    version,
    about,
    long_about = "sqlite-extras: Sqlite database performance insights. Locks, index usage, buffer cache hit ratios, vacuum stats and more.

https://github.com/pawurb/sqlite-extras-rs"
)]
pub struct SQExtrasArgs {
    #[command(subcommand)]
    pub cmd: SQSubcommand,
}

#[derive(Subcommand, Debug)]
pub enum SQSubcommand {
    #[command(about = extract_desc(&TableSize::description()))]
    TableSize,
    #[command(about = extract_desc(&IndexSize::description()))]
    IndexSize,
    #[command(about = extract_desc(&IntegrityCheck::description()))]
    IntegrityCheck,
    #[command(about = extract_desc(&Pragma::description()))]
    Pragma,
    #[command(about = extract_desc(&TotalSize::description()))]
    TotalSize,
    #[command(about = extract_desc(&CompileOptions::description()))]
    CompileOptions,
    #[command(about = extract_desc(&SequenceNumber::description()))]
    SequenceNumber,
}

#[tokio::main]
async fn main() {
    match execute().await {
        Ok(_) => {}
        Err(e) => {
            eprintln!("Error: {}", e);
            std::process::exit(1);
        }
    }
}

async fn execute() -> Result<(), SQExtrasError> {
    let args = SQExtrasArgs::parse();
    match args.cmd {
        SQSubcommand::TableSize => render_table(table_size().await?),
        SQSubcommand::IndexSize => render_table(index_size().await?),
        SQSubcommand::IntegrityCheck => render_table(integrity_check().await?),
        SQSubcommand::Pragma => render_table(pragma().await?),
        SQSubcommand::TotalSize => render_table(total_size().await?),
        SQSubcommand::CompileOptions => render_table(compile_options().await?),
        SQSubcommand::SequenceNumber => render_table(sequence_number().await?),
    }

    Ok(())
}

fn extract_desc(desc: &str) -> String {
    if let (Some(start), Some(end)) = (desc.find("/*"), desc.find("*/")) {
        let extracted = &desc[start + 2..end];
        let mut trimmed = extracted.trim().to_string();
        if trimmed.ends_with('.') {
            trimmed.pop();
        }
        trimmed
    } else {
        desc.to_string()
    }
}