pystratum_mssql.wrapper package

Submodules

pystratum_mssql.wrapper.MsSqlFunctionsWrapper module

class pystratum_mssql.wrapper.MsSqlFunctionsWrapper.MsSqlFunctionsWrapper(routine: Dict[str, Any], lob_as_string_flag: bool)

Bases: pystratum_mssql.wrapper.MsSqlWrapper.MsSqlWrapper, pystratum_common.wrapper.FunctionsWrapper.FunctionsWrapper

Wrapper method generator for stored functions.

pystratum_mssql.wrapper.MsSqlLogWrapper module

class pystratum_mssql.wrapper.MsSqlLogWrapper.MsSqlLogWrapper(routine: Dict[str, Any], lob_as_string_flag: bool)

Bases: pystratum_mssql.wrapper.MsSqlWrapper.MsSqlWrapper, pystratum_common.wrapper.LogWrapper.LogWrapper

Wrapper method generator for stored procedures with designation type log.

pystratum_mssql.wrapper.MsSqlNoneWrapper module

class pystratum_mssql.wrapper.MsSqlNoneWrapper.MsSqlNoneWrapper(routine: Dict[str, Any], lob_as_string_flag: bool)

Bases: pystratum_mssql.wrapper.MsSqlWrapper.MsSqlWrapper, pystratum_common.wrapper.NoneWrapper.NoneWrapper

Wrapper method generator for stored procedures without any result set.

pystratum_mssql.wrapper.MsSqlRow0Wrapper module

class pystratum_mssql.wrapper.MsSqlRow0Wrapper.MsSqlRow0Wrapper(routine: Dict[str, Any], lob_as_string_flag: bool)

Bases: pystratum_mssql.wrapper.MsSqlWrapper.MsSqlWrapper, pystratum_common.wrapper.Row0Wrapper.Row0Wrapper

Wrapper method generator for stored procedures that are selecting 0 or 1 row.

pystratum_mssql.wrapper.MsSqlRow1Wrapper module

class pystratum_mssql.wrapper.MsSqlRow1Wrapper.MsSqlRow1Wrapper(routine: Dict[str, Any], lob_as_string_flag: bool)

Bases: pystratum_mssql.wrapper.MsSqlWrapper.MsSqlWrapper, pystratum_common.wrapper.Row1Wrapper.Row1Wrapper

Wrapper method generator for stored procedures that are selecting 1 row.

pystratum_mssql.wrapper.MsSqlRowsWithIndexWrapper module

class pystratum_mssql.wrapper.MsSqlRowsWithIndexWrapper.MsSqlRowsWithIndexWrapper(routine: Dict[str, Any], lob_as_string_flag: bool)

Bases: pystratum_common.wrapper.RowsWithIndexWrapper.RowsWithIndexWrapper, pystratum_mssql.wrapper.MsSqlWrapper.MsSqlWrapper

Wrapper method generator for stored procedures whose result set must be returned using tree structure using a combination of non-unique columns.

pystratum_mssql.wrapper.MsSqlRowsWithKeyWrapper module

class pystratum_mssql.wrapper.MsSqlRowsWithKeyWrapper.MsSqlRowsWithKeyWrapper(routine: Dict[str, Any], lob_as_string_flag: bool)

Bases: pystratum_common.wrapper.RowsWithKeyWrapper.RowsWithKeyWrapper, pystratum_mssql.wrapper.MsSqlWrapper.MsSqlWrapper

Wrapper method generator for stored procedures whose result set must be returned using tree structure using a combination of unique columns.

pystratum_mssql.wrapper.MsSqlRowsWrapper module

class pystratum_mssql.wrapper.MsSqlRowsWrapper.MsSqlRowsWrapper(routine: Dict[str, Any], lob_as_string_flag: bool)

Bases: pystratum_mssql.wrapper.MsSqlWrapper.MsSqlWrapper, pystratum_common.wrapper.RowsWrapper.RowsWrapper

Wrapper method generator for stored procedures that are selecting 0, 1, or more rows.

pystratum_mssql.wrapper.MsSqlSingleton0Wrapper module

class pystratum_mssql.wrapper.MsSqlSingleton0Wrapper.MsSqlSingleton0Wrapper(routine: Dict[str, Any], lob_as_string_flag: bool)

Bases: pystratum_mssql.wrapper.MsSqlWrapper.MsSqlWrapper, pystratum_common.wrapper.Singleton0Wrapper.Singleton0Wrapper

Wrapper method generator for stored procedures that are selecting 0 or 1 row with one column only.

pystratum_mssql.wrapper.MsSqlSingleton1Wrapper module

class pystratum_mssql.wrapper.MsSqlSingleton1Wrapper.MsSqlSingleton1Wrapper(routine: Dict[str, Any], lob_as_string_flag: bool)

Bases: pystratum_mssql.wrapper.MsSqlWrapper.MsSqlWrapper, pystratum_common.wrapper.Singleton1Wrapper.Singleton1Wrapper

Wrapper method generator for stored procedures that are selecting 1 row with one column only.

pystratum_mssql.wrapper.MsSqlTableWrapper module

class pystratum_mssql.wrapper.MsSqlTableWrapper.MsSqlTableWrapper(routine: Dict[str, Any], lob_as_string_flag: bool)

Bases: pystratum_mssql.wrapper.MsSqlWrapper.MsSqlWrapper, pystratum_common.wrapper.TableWrapper.TableWrapper

Wrapper method generator for printing the result set of stored procedures in a table format.

pystratum_mssql.wrapper.MsSqlWrapper module

class pystratum_mssql.wrapper.MsSqlWrapper.MsSqlWrapper(routine: Dict[str, Any], lob_as_string_flag: bool)

Bases: pystratum_common.wrapper.Wrapper.Wrapper, abc.ABC

Parent class for wrapper method generators for stored procedures and functions.

is_lob_parameter(parameters: List[Dict[str, Any]]) → bool

Returns True of one of the parameters is a BLOB or CLOB. Otherwise, returns False.

Parameters:parameters – The parameters of a stored routine. Return type:bool:

Module contents

pystratum_mssql.wrapper.create_routine_wrapper(routine, lob_as_string_flag)

A factory for creating the appropriate object for generating a wrapper method for a stored routine.

Parameters:

• routine (dict[str,str]) – The metadata of the sored routine.
• lob_as_string_flag (bool) – If True BLOBs and CLOBs must be treated as strings.

Return type:

pystratum.mssql.wrapper.MsSqlWrapper.MsSqlWrapper