Function show_stats

explainshell/manager.py:1158–1190

Print aggregate database statistics.

(ctx: click.Context)

@show.command("stats")
@click.pass_context
def show_stats(ctx: click.Context) -> None:
    """Print aggregate database statistics."""
    import sqlite3

    db_path = _require_db(ctx, must_exist=True)
    conn = sqlite3.connect(db_path)
    conn.row_factory = sqlite3.Row

    n_manpages = conn.execute("SELECT COUNT(*) AS c FROM manpages").fetchone()["c"]
    n_parsed = conn.execute("SELECT COUNT(*) AS c FROM parsed_manpages").fetchone()["c"]
    n_mappings = conn.execute("SELECT COUNT(*) AS c FROM mappings").fetchone()["c"]
    click.echo(f"manpages (raw):    {n_manpages}")
    click.echo(f"parsed_manpages:   {n_parsed}")
    click.echo(f"mappings:          {n_mappings}")

    # Per-distro breakdown.
    rows = conn.execute("""
        SELECT
            SUBSTR(source, 1, INSTR(source, '/') - 1) as distro,
            SUBSTR(source, INSTR(source, '/') + 1,
                   INSTR(SUBSTR(source, INSTR(source, '/') + 1), '/') - 1) as release,
            COUNT(*) as cnt
        FROM parsed_manpages
        GROUP BY distro, release
        ORDER BY distro, release
    """).fetchall()
    if rows:
        click.echo("")
        click.echo("per distro/release:")
        for row in rows:
            click.echo(f"  {row['distro']}/{row['release']}: {row['cnt']}")

    conn.close()


@show.command("events")