sqlmeta.objects.module

Module SQL model class (DB2-specific).

Classes

Module(name, definition[, schema, dialect])

Represents a DB2 Module - a collection of SQL procedures, functions, and types.

class sqlmeta.objects.module.Module(name: str, definition: str, schema: str | None = None, dialect: str | None = None)

Represents a DB2 Module - a collection of SQL procedures, functions, and types.

DB2 Modules are similar to Oracle Packages - they group related SQL routines and user-defined types together. Modules support SQL routine encapsulation and can contain both published (public) and internal (private) routines.

__init__(name: str, definition: str, schema: str | None = None, dialect: str | None = None)

Initialize a DB2 module.

Parameters:

• name – Module name

• definition – Complete module definition (CREATE MODULE … END MODULE)

• schema – Schema name (typically the module owner)

• dialect – SQL dialect (typically ‘db2’)

property create_statement: str

Generate CREATE MODULE statement.

Returns:

DB2 CREATE MODULE statement

property drop_statement: str

Generate DROP MODULE statement.

Returns:

DB2 DROP MODULE statement

__str__() → str

Return string representation of the module.

__eq__(other: Any) → bool

Check if two modules are equal.

Note: Case-sensitive in DB2 for delimited identifiers.

__hash__() → int

Return hash of the module.