Method tables

mycli/sqlexecute.py:414–421

Yields table names

(self)

        return SQLResult(preamble=preamble, header=header, rows=cursor, status=status)

    def tables(self) -> Generator[tuple[str], None, None]:
        """Yields table names"""

        assert isinstance(self.conn, Connection)
        with self.conn.cursor() as cur:
            _logger.debug("Tables Query. sql: %r", self.tables_query)
            cur.execute(self.tables_query)
            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)."""