Method enum_values

mycli/sqlexecute.py:432–442

Yields (table name, column name, enum values) tuples for *schema*.

(self, schema: str | None = None)

            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*."""
        target = schema if schema is not None else self.dbname
        assert isinstance(self.conn, Connection)
        with self.conn.cursor() as cur:
            _logger.debug("Enum Values Query. sql: %r schema: %r", self.enum_values_query, target)
            cur.execute(self.enum_values_query, (target,))
            for table_name, column_name, column_type in cur:
                values = self._parse_enum_values(column_type)
                if values:
                    yield (table_name, column_name, values)

    def foreign_keys(self, schema: str | None = None) -> Generator[tuple[str, str, str, str], None, None]:
        """Yields (table_name, column_name, referenced_table_name, referenced_column_name) tuples for *schema*."""