Work Item / Issue Reference

AB#<WORK_ITEM_ID>

GitHub Issue: #182

Summary

This pull request makes improvements to the cursor resource management and error handling in the mssql_python/cursor.py module. The main changes include making the cursor close operation idempotent, refining exception types, and improving logging during cleanup. These updates help ensure more robust and predictable behavior when working with cursors.

Error handling improvements:

• Changed the exception raised when attempting to close an already closed cursor from a generic Exception to a more specific ProgrammingError, providing clearer feedback to users.
• Updated the import statement to use ProgrammingError instead of InterfaceError, aligning with the new error handling approach.

Resource cleanup and logging:

• Improved the destructor (__del__) to check for the correct closed attribute and made sure no exception is raised if the cursor is already closed, enhancing reliability during garbage collection.
• Changed the logging level in the destructor from 'error' to 'debug' for exceptions during cleanup, reducing unnecessary noise in error logs.