]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
Add DATETIMEOFFSET support for mssql+pyodbc
authorGord Thompson <gord@gordthompson.com>
Tue, 26 Nov 2019 14:57:48 +0000 (09:57 -0500)
committerMike Bayer <mike_mp@zzzcomputing.com>
Fri, 29 Nov 2019 17:07:18 +0000 (12:07 -0500)
commit1987215d004f4e913d316b9b2e918cdd341c8fe6
tree845fb9b2405bad51939a7c9f6e4dbc51b737b726
parent80ecc638697c9c4f31c613acc3c2d956ee0de159
Add DATETIMEOFFSET support for mssql+pyodbc

Repaired support for the :class:`.mssql.DATETIMEOFFSET` datatype on PyODBC,
by adding PyODBC-level result handlers as it does not include native
support for this datatype.  This includes usage of the Python 3 "timezone"
tzinfo subclass in order to set up a timezone, which on Python 2 makes
use of a minimal backport of "timezone" in sqlalchemy.util.

Fixes: #4983
Closes: #4986
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/4986
Pull-request-sha: e3a5a8dda01c7580dc93271092c4f9beaac4be11

Change-Id: Ia4c7c0d1971c6c0492515bd5fa0b1799f07fee1c
(cherry picked from commit f521577f6e1ebc8029b4395a3bff6783522ae8b8)
doc/build/changelog/unreleased_13/4983.rst [new file with mode: 0644]
lib/sqlalchemy/dialects/mssql/pyodbc.py
lib/sqlalchemy/util/__init__.py
lib/sqlalchemy/util/compat.py
test/base/test_utils.py
test/dialect/mssql/test_types.py