Method distros

explainshell/store.py:403–412

Return distinct (distro, release) pairs from manpages.

(self)

        ]

    def distros(self) -> list[tuple[str, str]]:
        """Return distinct (distro, release) pairs from manpages."""
        rows = self._conn.execute("""
            SELECT DISTINCT
                SUBSTR(source, 1, INSTR(source, '/') - 1) as distro,
                SUBSTR(source, INSTR(source, '/') + 1,
                       INSTR(SUBSTR(source, INSTR(source, '/') + 1), '/') - 1) as release
            FROM parsed_manpages
        """).fetchall()
        return [(row["distro"], row["release"]) for row in rows]

    def distros_for_name(self, name: str) -> list[tuple[str, str]]:
        """Return (distro, release) pairs that have a manpage matching *name*."""