FEAT: Adding setinputsizes by jahnvi480 · Pull Request #192 · microsoft/mssql-python
### Work Item / Issue Reference <!-- IMPORTANT: Please follow the PR template guidelines below. For mssql-python maintainers: Insert your ADO Work Item ID below (e.g. AB#37452) For external contributors: Insert Github Issue number below (e.g. #149) Only one reference is required - either GitHub issue OR ADO Work Item. --> <!-- mssql-python maintainers: ADO Work Item --> > [AB#34934](https://sqlclientdrivers.visualstudio.com/c6d89619-62de-46a0-8b46-70b92a84d85e/_workitems/edit/34934) ------------------------------------------------------------------- ### Summary This pull request adds support for retrieving ODBC data type information via a new `getTypeInfo` method on the `cursor` object, exposing the underlying `SQLGetTypeInfo` API. It includes the necessary C++/Python bindings, error handling, and comprehensive test coverage to ensure correct behavior for different data types and usage scenarios. ### Feature: Data type information retrieval * Added a new `getTypeInfo` method to the `cursor` class in `mssql_python/cursor.py`, allowing users to retrieve metadata about supported SQL data types via the ODBC `SQLGetTypeInfo` API. The method supports querying all types or a specific type and returns results as a list of `Row` objects with a well-defined column map. ### Bindings and driver integration * Introduced a new function pointer type for `SQLGetTypeInfo` (`SQLGetTypeInfoFunc`) and integrated it into the driver loading and verification process in `mssql_python/pybind/ddbc_bindings.h` and `mssql_python/pybind/ddbc_bindings.cpp`. This ensures the function pointer is loaded and checked along with other ODBC APIs. * Added a wrapper function and Python binding for `SQLGetTypeInfo`, exposing it as `DDBCSQLGetTypeInfo` in the Python module. ### Testing * Added a comprehensive suite of tests in `tests/test_004_cursor.py` to validate the new `getTypeInfo` method. Tests cover retrieving all types, specific types, result structure, numeric and datetime types, binary types, multiple successive calls, and repeated identical queries for consistency and efficiency. --------- Co-authored-by: Jahnvi Thakkar <jathakkar@microsoft.com>