Method list_sections

explainshell/store.py:634–648

Return distinct section directories for a distro/release. Extracts the third path component from source keys matching ``distro/release/...`` using a range scan on the primary key.

(self, distro: str, release: str)

        return SubcommandMappingResult(mappings_to_add, parents)

    def list_sections(self, distro: str, release: str) -> list[str]:
        """Return distinct section directories for a distro/release.

        Extracts the third path component from source keys matching
        ``distro/release/...`` using a range scan on the primary key.
        """
        prefix = f"{distro}/{release}/"
        offset = len(prefix)
        rows = self._conn.execute(
            "SELECT DISTINCT SUBSTR(source, ?, INSTR(SUBSTR(source, ?), '/') - 1) AS section "
            "FROM manpages WHERE source >= ? AND source < ? "
            "ORDER BY section",
            (offset + 1, offset + 1, prefix, prefix[:-1] + chr(ord(prefix[-1]) + 1)),
        ).fetchall()
        return [row["section"] for row in rows]

    def list_manpages(self, prefix: str) -> list[str]:
        """List source paths that start with *prefix*.