ADO Work Item Reference

AB#34946

Summary

This pull request introduces significant updates to themssql_python library, focusing on enhancing theBCPOptions andColumnFormat classes, improving error handling, and adding comprehensive unit tests. The changes include refactoring the code for better maintainability, adding logging for debugging, and introducing new features and validations for bulk copy operations.

Enhancements toBCPOptions andColumnFormat:

• Added new fields toBCPOptions (query,row_terminator,bulk_mode) andColumnFormat (user_data_type,terminator_len) to support additional BCP features. Updated default values for some fields.[1][2][3]
• Introduced stricter validation for fields in both classes, including checks for non-negative integers, valid enumerations, and mutually exclusive options (e.g.,columns vs.format_file). Logging has been added for detailed error messages.[1][2]

Refactoring and Code Simplification:

• Removed unused imports and fields (e.g.,row_terminator fromColumnFormat andwrite_format_file fromBCPOptions) to streamline the codebase.[1][2]
• Centralized allowed values fordirection andbulk_mode into constants for better maintainability.[1][2]

New Constants for BCP Options:

• Introduced a newBCPControlOptions enum inconstants.py to define string representations of BCP control options, improving clarity and consistency.

Unit Tests for Bulk Copy Operations:

• Added a new test suite (tests/test_007_bulkOptions.py) with unit tests forBCPOptions andColumnFormat. Tests cover valid instantiations, invalid values, and edge cases such as conflicts betweencolumns andformat_file.
• Introduced fixtures for setting up temporary database tables and files, enabling integration tests for BCP operations.