Method catalog_items

misc/python/materialize/mzexplore/sql.py:80–95

(
        self,
        database: str | None = None,
        schema: str | None = None,
        name: str | None = None,
        system: bool = False,
    )

            cursor.execute(statement)

    def catalog_items(
        self,
        database: str | None = None,
        schema: str | None = None,
        name: str | None = None,
        system: bool = False,
    ) -> DictGenerator:
        p = resource_path("catalog/s_items.sql" if system else "catalog/u_items.sql")
        q = parse_query(p)
        yield from self.query_all(
            q.format(
                database="'%'" if database is None else literal(database),
                schema="'%'" if schema is None else literal(schema),
                name="'%'" if name is None else literal(name),
            )
        )

    def object_clusters(
        self,