Method table_columns

mycli/sqlexecute.py:423–430

Yields (table name, column name) pairs for *schema* (default: current database).

(self, schema: str | None = None)

            yield from cur

    def table_columns(self, schema: str | None = None) -> Generator[tuple[str, str], None, None]:
        """Yields (table name, column name) pairs for *schema* (default: current database)."""
        target = schema if schema is not None else self.dbname
        assert isinstance(self.conn, Connection)
        with self.conn.cursor() as cur:
            _logger.debug("Columns Query. sql: %r schema: %r", self.table_columns_query, target)
            cur.execute(self.table_columns_query, (target,))
            yield from cur

    def enum_values(self, schema: str | None = None) -> Generator[tuple[str, str, list[str]], None, None]:
        """Yields (table name, column name, enum values) tuples for *schema*."""