Method foreign_keys

mycli/sqlexecute.py:444–454

Yields (table_name, column_name, referenced_table_name, referenced_column_name) tuples for *schema*.

(self, schema: str | None = None)

                    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*."""
        target = schema if schema is not None else self.dbname
        assert isinstance(self.conn, Connection)
        with self.conn.cursor() as cur:
            _logger.debug("Foreign Keys Query. sql: %r schema: %r", self.foreign_keys_query, target)
            try:
                cur.execute(self.foreign_keys_query, (target,))
                yield from cur
            except Exception as e:
                _logger.error('No foreign key completions due to %r', e)

    def databases(self) -> list[str]:
        assert isinstance(self.conn, Connection)