sqlmeta.objects.database_link

Database Link SQL model class (Oracle-specific).

Classes

DatabaseLink(name[, host, username, ...])

Represents a database link (Oracle-specific).

class sqlmeta.objects.database_link.DatabaseLink(name: str, host: str | None = None, username: str | None = None, connect_string: str | None = None, public: bool = False, schema: str | None = None, dialect: str | None = None)

Represents a database link (Oracle-specific).

Database links are named connections from one Oracle database to another, allowing distributed queries across multiple databases. They are essential for enterprise applications with multi-database architectures.

__init__(name: str, host: str | None = None, username: str | None = None, connect_string: str | None = None, public: bool = False, schema: str | None = None, dialect: str | None = None)

Initialize a database link.

Parameters:

• name – Database link name

• host – Remote host name or TNS name (optional)

• username – Username for remote connection (optional)

• connect_string – Complete connection string/TNS name (optional)

• public – Whether this is a public database link

• schema – Schema owner (for private links)

• dialect – SQL dialect (typically ‘oracle’)

property create_statement: str

Generate CREATE DATABASE LINK statement.

Note: For security reasons, passwords are not stored or generated. The CREATE statement will need to be completed with credentials.

Returns:

Oracle CREATE DATABASE LINK statement (without password)

property drop_statement: str

Generate DROP DATABASE LINK statement.

Returns:

Oracle DROP DATABASE LINK statement

__str__() → str

Return string representation of the database link.

__eq__(other: Any) → bool

Check if two database links are equal.

Note: We compare connection parameters but not passwords for security.

__hash__() → int

Return hash of the database link.