FEAT: BCP WRAPPER C CODE #63
Closed
Add this suggestion to a batch that can be applied as a single commit.
This suggestion is invalid because no changes were made to the code.
Suggestions cannot be applied while the pull request is closed.
Suggestions cannot be applied while viewing a subset of changes.
Only one suggestion per line can be applied in a batch.
Add this suggestion to a batch that can be applied as a single commit.
Applying suggestions on deleted lines is not supported.
You must change the existing code in this line in order to create a valid suggestion.
Outdated suggestions cannot be applied.
This suggestion has been applied or marked resolved.
Suggestions cannot be applied from pending reviews.
Suggestions cannot be applied on multi-line comments.
Suggestions cannot be applied while the pull request is queued to merge.
Suggestion cannot be applied right now. Please check back later.
This pull request introduces significant updates to the
mssql_python
package, focusing on enhancing functionality, improving type safety, and simplifying the codebase. Key changes include renaming methods for clarity, introducing new fields for column definitions, and refactoring connection and cursor management to leverage theddbc_bindings.Connection
abstraction.Bulk Copy Enhancements:
run_bcp
tosql_bulk_copy
for better clarity and updated associated logging messages. (mssql_python/bcp_main.py
)field_terminator
androw_terminator
in column definitions, allowing more flexible bulk copy operations. (mssql_python/bcp_main.py
)user_data_type
to theColumnFormat
class to support extended column metadata. (mssql_python/bcp_options.py
)Connection Refactoring:
henv
,hdbc
) withddbc_bindings.Connection
, simplifying initialization and lifecycle management. (mssql_python/connection.py
)ddbc_bindings.Connection
methods likeset_autocommit
,commit
, androllback
. (mssql_python/connection.py
)Cursor Refactoring:
alloc_statement_handle
method, streamlining resource management. (mssql_python/cursor.py
)These changes improve code readability, maintainability, and functionality, aligning the package with modern Python practices while enhancing its capabilities for database operations.