sqlmeta.objects.package

Oracle Package SQL Model.

Classes

Package(name[, schema, spec, body, dialect])

Represents an Oracle package (specification and body).

class sqlmeta.objects.package.Package(name: str, schema: str | None = None, spec: str | None = None, body: str | None = None, dialect: str | None = 'oracle')

Represents an Oracle package (specification and body).

__init__(name: str, schema: str | None = None, spec: str | None = None, body: str | None = None, dialect: str | None = 'oracle')

Initialize an Oracle package.

Parameters:

• name – Package name

• schema – Schema name (optional)

• spec – Package specification (header/interface)

• body – Package body (implementation)

• dialect – SQL dialect (defaults to oracle)

property create_statement: str

Generate CREATE PACKAGE statements.

Returns both spec and body if available.

Returns:

CREATE PACKAGE and CREATE PACKAGE BODY statements

__str__() → str

Return string representation of the package.

__eq__(other: Any) → bool

Check if two packages are equal.

classmethod from_dict(data: Dict[str, Any]) → Package

Create package from dictionary representation.

Parameters:

data – Dictionary with package attributes

Returns:

Package object

to_dict() → Dict[str, Any]

Convert package to dictionary representation.

Returns:

Dictionary with package attributes