pystratum_mssql.backend package

Submodules

pystratum_mssql.backend.MsSqlBackend module

class pystratum_mssql.backend.MsSqlBackend.MsSqlBackend[source]

Bases: pystratum_backend.Backend.Backend

PyStratum Backend for MS SQL Server.

create_constant_worker(config: configparser.ConfigParser, io: pystratum_backend.StratumStyle.StratumStyle) → Optional[pystratum_backend.ConstantWorker.ConstantWorker][source]

Creates the object that does the actual execution of the constant command for the backend.

Parameters:
  • config (ConfigParser) – The settings from the PyStratum configuration file.
  • io (StratumStyle) – The output object.
Return type:

ConstantWorker|None
create_routine_loader_worker(config: configparser.ConfigParser, io: pystratum_backend.StratumStyle.StratumStyle) → Optional[pystratum_backend.RoutineLoaderWorker.RoutineLoaderWorker][source]

Creates the object that does the actual execution of the routine loader command for the backend.

Parameters:
  • config (ConfigParser) – The settings from the PyStratum configuration file.
  • io (StratumStyle) – The output object.
Return type:

RoutineLoaderWorker|None
create_routine_wrapper_generator_worker(config: configparser.ConfigParser, io: pystratum_backend.StratumStyle.StratumStyle) → Optional[pystratum_backend.RoutineWrapperGeneratorWorker.RoutineWrapperGeneratorWorker][source]

Creates the object that does the actual execution of the routine wrapper generator command for the backend.

Parameters:
  • config (ConfigParser) – The settings from the PyStratum configuration file.
  • io (StratumStyle) – The output object.
Return type:

RoutineWrapperGeneratorWorker|None

pystratum_mssql.backend.MsSqlConstantWorker module

PyStratum

class pystratum_mssql.backend.MsSqlConstantWorker.MsSqlConstantWorker(io: pystratum_backend.StratumStyle.StratumStyle, config: configparser.ConfigParser)[source]

Bases: pystratum_mssql.backend.MsSqlWorker.MsSqlWorker, pystratum_common.backend.CommonConstantWorker.CommonConstantWorker

Class for creating constants based on column widths, and auto increment columns and labels for SQL Server databases.

static derive_field_length(column: Dict[str, Any]) → int[source]

Returns the width of a field based based on the data type of column.

Parameters:column (dict) – Info about the column.
Return type:int

pystratum_mssql.backend.MsSqlRoutineLoaderWorker module

class pystratum_mssql.backend.MsSqlRoutineLoaderWorker.MsSqlRoutineLoaderWorker(io: pystratum_backend.StratumStyle.StratumStyle, config: configparser.ConfigParser)[source]

Bases: pystratum_mssql.backend.MsSqlWorker.MsSqlWorker, pystratum_common.backend.CommonRoutineLoaderWorker.CommonRoutineLoaderWorker

Class for loading stored routines into a SQL Server instance from pseudo SQL files.

create_routine_loader_helper(routine_name: str, pystratum_old_metadata: Optional[Dict[KT, VT]], rdbms_old_metadata: Optional[Dict[KT, VT]]) → pystratum_mssql.helper.MsSqlRoutineLoaderHelper.MsSqlRoutineLoaderHelper[source]

Creates a Routine Loader Helper object.

Parameters:
  • routine_name (str) – The name of the routine.
  • pystratum_old_metadata (dict) – The old metadata of the stored routine from PyStratum.
  • rdbms_old_metadata (dict) – The old metadata of the stored routine from MS SQL Server.
Return type:

MsSqlRoutineLoaderHelper

pystratum_mssql.backend.MsSqlRoutineWrapperGeneratorWorker module

class pystratum_mssql.backend.MsSqlRoutineWrapperGeneratorWorker.MsSqlRoutineWrapperGeneratorWorker(io: pystratum_backend.StratumStyle.StratumStyle, config: configparser.ConfigParser)[source]

Bases: pystratum_mssql.backend.MsSqlWorker.MsSqlWorker, pystratum_common.backend.CommonRoutineWrapperGeneratorWorker.CommonRoutineWrapperGeneratorWorker

Class for generating a class with wrapper methods for calling stored routines in a SQL Server database.

pystratum_mssql.backend.MsSqlWorker module

class pystratum_mssql.backend.MsSqlWorker.MsSqlWorker(io: pystratum_backend.StratumStyle.StratumStyle, config: configparser.ConfigParser)[source]

Bases: object

connect() → None[source]

Connects to the database.

disconnect() → None[source]

Disconnects from the database.

Module contents