Method add_manpage

explainshell/store.py:474–554

add `m` into the store, if it exists first remove it and its mappings each man page may have aliases besides the name determined by its basename

(self, m: ParsedManpage, raw: RawManpage)

        )

    def add_manpage(self, m: ParsedManpage, raw: RawManpage) -> ParsedManpage:
        """add `m` into the store, if it exists first remove it and its mappings

        each man page may have aliases besides the name determined by its
        basename"""
        validate_source_path(m.source)
        existing = self._conn.execute(
            "SELECT source FROM parsed_manpages WHERE source = ?", (m.source,)
        ).fetchone()
        if existing:
            logger.debug("removing old manpage %s", m.source)
            # Non-alias mappings (e.g. symlink-derived) will be lost to the
            # CASCADE delete, but are recreated automatically by the
            # symlink/dedup mapping phase at the end of the run.
            alias_srcs = {a for a, _ in m.aliases}
            lost = [
                row["src"]
                for row in self._conn.execute(
                    "SELECT src FROM mappings WHERE dst = ?", (m.source,)
                ).fetchall()
                if row["src"] not in alias_srcs
            ]
            if lost:
                logger.debug(
                    "re-importing %s will temporarily drop non-alias mappings: %s",
                    m.source,
                    ", ".join(sorted(lost)),
                )
            # ON DELETE CASCADE removes all mappings rows for this manpage.
            self._conn.execute(
                "DELETE FROM parsed_manpages WHERE source = ?", (m.source,)
            )
            self._conn.commit()
            logger.debug("removed manpage and its mappings for %s", m.source)
        else:
            # Check for duplicate: same distro/release + name + section but different source
            distro, release = config.parse_distro_release(m.source)
            section = m.section
            prefix = f"{distro}/{release}/"
            conflict = self._conn.execute(
                "SELECT source FROM parsed_manpages WHERE source LIKE ? AND source != ? AND name = ?",
                (prefix + "%", m.source, m.name),
            ).fetchone()
            if conflict:
                conflict_source = conflict["source"]
                _, conflict_section = util.name_section(
                    os.path.basename(conflict_source)[:-3]
                )
                if conflict_section == section:
                    raise errors.DuplicateManpage(
                        f"manpage {m.name}({section}) already exists with source "
                        f"{conflict_source!r}, refusing to add duplicate from {m.source!r}"
                    )

        self._upsert_raw_manpage(m.source, raw)

        self._conn.execute(
            """INSERT INTO parsed_manpages(source, name, synopsis, options, aliases,