]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
implement iso date literals for all backends
authorMike Bayer <mike_mp@zzzcomputing.com>
Mon, 28 Mar 2022 17:29:23 +0000 (13:29 -0400)
committerMike Bayer <mike_mp@zzzcomputing.com>
Fri, 8 Apr 2022 18:13:51 +0000 (14:13 -0400)
commit952383f9ee04649282519b3287241c1336502fe5
treedaaab9c0bcd75631dcdcc30b1e388af454e92eff
parent4acf50c8e86b6b047853b2bc96ccaa494811085f
implement iso date literals for all backends

Added modified ISO-8601 rendering (i.e. ISO-8601 with the T converted to a
space) when using ``literal_binds`` with the SQL compilers provided by the
PostgreSQL, MySQL, MariaDB, MSSQL, Oracle dialects. For Oracle, the ISO
format is wrapped inside of an appropriate TO_DATE() function call.
Previously this rendering was not implemented for dialect-specific
compilation.

Fixes: #5052
Change-Id: I7af15a51fedf5c5a8e76e645f7c3be997ece35f0
13 files changed:
doc/build/changelog/unreleased_20/5052.rst [new file with mode: 0644]
lib/sqlalchemy/dialects/mssql/base.py
lib/sqlalchemy/dialects/mssql/pyodbc.py
lib/sqlalchemy/dialects/mysql/base.py
lib/sqlalchemy/dialects/mysql/types.py
lib/sqlalchemy/dialects/oracle/base.py
lib/sqlalchemy/dialects/oracle/cx_oracle.py
lib/sqlalchemy/dialects/postgresql/pg8000.py
lib/sqlalchemy/dialects/postgresql/psycopg.py
lib/sqlalchemy/engine/default.py
lib/sqlalchemy/sql/sqltypes.py
test/dialect/oracle/test_types.py
test/requirements.py