]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
use .fromisoformat() for sqlite datetime, date, time parsing
authorMike Bayer <mike_mp@zzzcomputing.com>
Sun, 3 Apr 2022 17:44:57 +0000 (13:44 -0400)
committerMike Bayer <mike_mp@zzzcomputing.com>
Sun, 3 Apr 2022 18:47:52 +0000 (14:47 -0400)
commitccadbec82555c53eefa889160510f5af1e224709
tree959b4309fcc26191ef791034bda76e6fda0d1bdb
parent1dffb7cedeb009ca6c532db558bd0588dd846957
use .fromisoformat() for sqlite datetime, date, time parsing

SQLite datetime, date, and time datatypes now use Python standard lib
``fromisoformat()`` methods in order to parse incoming datetime, date, and
time string values. This improves performance vs. the previous regular
expression-based approach, and also automatically accommodates for datetime
and time formats that contain either a six-digit "microseconds" format or a
three-digit "milliseconds" format.

Fixes: #7029
Change-Id: I67aab4fe5ee3055e5996050cf4564981413cc221
doc/build/changelog/unreleased_20/7029.rst [new file with mode: 0644]
lib/sqlalchemy/cyextension/processors.pyx
lib/sqlalchemy/dialects/sqlite/base.py
lib/sqlalchemy/engine/_py_processors.py
lib/sqlalchemy/testing/suite/test_types.py
test/dialect/test_sqlite.py
test/engine/test_processors.py