]> 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:06:48 +0000 (12:06 -0500)
commitf521577f6e1ebc8029b4395a3bff6783522ae8b8
tree44cfd3e1e3e73f30d57dffe5fd90285fa76625cc
parentc2432d9d190bdc67f274b8da9296ff9ed044bef1
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
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