pystratum_pgsql.helper package

Submodules

pystratum_pgsql.helper.PgSqlDataTypeHelper module

class pystratum_pgsql.helper.PgSqlDataTypeHelper.PgSqlDataTypeHelper[source]

Bases: pystratum_common.helper.DataTypeHelper.DataTypeHelper

Utility class for deriving information based on a PostgreSQL data type.

column_type_to_python_type(data_type_info: Dict[str, Any]) → str[source]

Returns the corresponding Python data type of a PostgreSQL data type.

Parameters:data_type_info (dict) – The PostgreSQL data type metadata.
Return type:str
column_type_to_python_type_hint(data_type_info: Dict[str, Any]) → str[source]

Returns the corresponding Python data type hinting of a PostgreSQL data type.

Parameters:data_type_info (dict) – The PostgreSQL data type metadata.
Return type:str

pystratum_pgsql.helper.PgSqlRoutineLoaderHelper module

class pystratum_pgsql.helper.PgSqlRoutineLoaderHelper.PgSqlRoutineLoaderHelper(io: pystratum_backend.StratumStyle.StratumStyle, dl: pystratum_pgsql.PgSqlMetadataDataLayer.PgSqlMetadataDataLayer, routine_filename: str, routine_file_encoding: str, pystratum_old_metadata: Dict[KT, VT], replace_pairs: Dict[str, str], rdbms_old_metadata: Dict[KT, VT])[source]

Bases: pystratum_common.helper.RoutineLoaderHelper.RoutineLoaderHelper

Class for loading a single stored routine into a PostgreSQL instance from a (pseudo) SQL file.

get_bulk_insert_table_columns_info() → None[source]

Gets the column names and column types of the current table for bulk insert.

Module contents