rel_2_0_35
版本发布时间: 2024-09-17 04:30:15
sqlalchemy/sqlalchemy最新发布版本:rel_2_0_36(2024-10-16 03:41:54)
2.0.35
Released: September 16, 2024
orm
-
[orm] [bug] [typing] Fixed issue where it was not possible to use
typing.Literal
withMapped[]
on Python 3.8 and 3.9. Pull request courtesy Frazer McLean.References: #11820
-
[orm] [bug] Fixed issue in ORM evaluator where two datatypes being evaluated with the SQL concatenator operator would not be checked for
UnevaluatableError
based on their datatype; this missed the case of_postgresql.JSONB
values being used in a concatenate operation which is supported by PostgreSQL as well as how SQLAlchemy renders the SQL for this operation, but does not work at the Python level. By implementingUnevaluatableError
for this combination, ORM update statements will now fall back to "expire" when a concatenated JSON value used in a SET clause is to be synchronized to a Python object.References: #11849
-
[orm] [bug] An warning is emitted if
_orm.joinedload()
or_orm.subqueryload()
are used as a top level option against a statement that is not a SELECT statement, such as with aninsert().returning()
. There are no JOINs in INSERT statements nor is there a "subquery" that can be repurposed for subquery eager loading, and for UPDATE/DELETE joinedload does not support these either, so it is never appropriate for this use to pass silently.References: #11853
-
[orm] [bug] Fixed issue where using loader options such as
_orm.selectinload()
with additional criteria in combination with ORM DML such as_sql.insert()
with RETURNING would not correctly set up internal contexts required for caching to work correctly, leading to incorrect results.References: #11855
mysql
-
[mysql] [bug] Fixed issue in mariadbconnector dialect where query string arguments that weren't checked integer or boolean arguments would be ignored, such as string arguments like
unix_socket
, etc. As part of this change, the argument parsing for particular elements such asclient_flags
,compress
,local_infile
has been made more consistent across all MySQL / MariaDB dialect which accept each argument. Pull request courtesy Tobias Alex-Petersen.References: #11870
sqlite
-
[sqlite] [bug] [regression] The changes made for SQLite CHECK constraint reflection in versions 2.0.33 and 2.0.34 , #11832 and #11677, have now been fully reverted, as users continued to identify existing use cases that stopped working after this change. For the moment, because SQLite does not provide any consistent way of delivering information about CHECK constraints, SQLAlchemy is limited in what CHECK constraint syntaxes can be reflected, including that a CHECK constraint must be stated all on a single, independent line (or inline on a column definition) without newlines, tabs in the constraint definition or unusual characters in the constraint name. Overall, reflection for SQLite is tailored towards being able to reflect CREATE TABLE statements that were originally created by SQLAlchemy DDL constructs. Long term work on a DDL parser that does not rely upon regular expressions may eventually improve upon this situation. A wide range of additional cross-dialect CHECK constraint reflection tests have been added as it was also a bug that these changes did not trip any existing tests.
References: #11840
1、 SQLAlchemy-2.0.35-cp310-cp310-macosx_10_9_x86_64.whl 1.99MB
2、 SQLAlchemy-2.0.35-cp310-cp310-macosx_11_0_arm64.whl 1.98MB
3、 SQLAlchemy-2.0.35-cp310-cp310-manylinux_2_17_aarch64.manylinux2014_aarch64.whl 2.92MB
4、 SQLAlchemy-2.0.35-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl 2.93MB
5、 SQLAlchemy-2.0.35-cp310-cp310-musllinux_1_2_aarch64.whl 2.89MB
6、 SQLAlchemy-2.0.35-cp310-cp310-musllinux_1_2_x86_64.whl 2.91MB
7、 SQLAlchemy-2.0.35-cp310-cp310-win32.whl 1.97MB
8、 SQLAlchemy-2.0.35-cp310-cp310-win_amd64.whl 1.99MB
9、 SQLAlchemy-2.0.35-cp311-cp311-macosx_10_9_x86_64.whl 1.99MB
10、 SQLAlchemy-2.0.35-cp311-cp311-macosx_11_0_arm64.whl 1.99MB
11、 SQLAlchemy-2.0.35-cp311-cp311-manylinux_2_17_aarch64.manylinux2014_aarch64.whl 3.05MB
12、 SQLAlchemy-2.0.35-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl 3.05MB
13、 SQLAlchemy-2.0.35-cp311-cp311-musllinux_1_2_aarch64.whl 2.99MB
14、 SQLAlchemy-2.0.35-cp311-cp311-musllinux_1_2_x86_64.whl 3.01MB
15、 SQLAlchemy-2.0.35-cp311-cp311-win32.whl 1.97MB
16、 SQLAlchemy-2.0.35-cp311-cp311-win_amd64.whl 1.99MB
17、 SQLAlchemy-2.0.35-cp312-cp312-macosx_10_9_x86_64.whl 1.99MB
18、 SQLAlchemy-2.0.35-cp312-cp312-macosx_11_0_arm64.whl 1.98MB
19、 SQLAlchemy-2.0.35-cp312-cp312-manylinux_2_17_aarch64.manylinux2014_aarch64.whl 3.08MB
20、 SQLAlchemy-2.0.35-cp312-cp312-manylinux_2_17_x86_64.manylinux2014_x86_64.whl 3.09MB
21、 SQLAlchemy-2.0.35-cp312-cp312-musllinux_1_2_aarch64.whl 3.03MB
22、 SQLAlchemy-2.0.35-cp312-cp312-musllinux_1_2_x86_64.whl 3.05MB
23、 SQLAlchemy-2.0.35-cp312-cp312-win32.whl 1.96MB
24、 SQLAlchemy-2.0.35-cp312-cp312-win_amd64.whl 1.99MB
25、 SQLAlchemy-2.0.35-cp37-cp37m-macosx_10_9_x86_64.whl 2MB
26、 SQLAlchemy-2.0.35-cp37-cp37m-manylinux_2_17_aarch64.manylinux2014_aarch64.whl 2.84MB
27、 SQLAlchemy-2.0.35-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl 2.85MB
28、 SQLAlchemy-2.0.35-cp37-cp37m-musllinux_1_2_aarch64.whl 2.8MB
29、 SQLAlchemy-2.0.35-cp37-cp37m-musllinux_1_2_x86_64.whl 2.82MB
30、 SQLAlchemy-2.0.35-cp37-cp37m-win32.whl 1.97MB
31、 SQLAlchemy-2.0.35-cp37-cp37m-win_amd64.whl 1.99MB
32、 SQLAlchemy-2.0.35-cp38-cp38-macosx_10_9_x86_64.whl 2MB
33、 SQLAlchemy-2.0.35-cp38-cp38-macosx_11_0_arm64.whl 1.99MB
34、 SQLAlchemy-2.0.35-cp38-cp38-manylinux_2_17_aarch64.manylinux2014_aarch64.whl 2.95MB
35、 SQLAlchemy-2.0.35-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl 2.95MB
36、 SQLAlchemy-2.0.35-cp38-cp38-musllinux_1_2_aarch64.whl 2.9MB
37、 SQLAlchemy-2.0.35-cp38-cp38-musllinux_1_2_x86_64.whl 2.92MB
38、 SQLAlchemy-2.0.35-cp38-cp38-win32.whl 1.97MB
39、 SQLAlchemy-2.0.35-cp38-cp38-win_amd64.whl 1.99MB
40、 SQLAlchemy-2.0.35-cp39-cp39-macosx_10_9_x86_64.whl 2MB
41、 SQLAlchemy-2.0.35-cp39-cp39-macosx_11_0_arm64.whl 1.99MB
42、 SQLAlchemy-2.0.35-cp39-cp39-manylinux_2_17_aarch64.manylinux2014_aarch64.whl 2.94MB
43、 SQLAlchemy-2.0.35-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl 2.94MB
44、 SQLAlchemy-2.0.35-cp39-cp39-musllinux_1_2_aarch64.whl 2.9MB
45、 SQLAlchemy-2.0.35-cp39-cp39-musllinux_1_2_x86_64.whl 2.93MB
46、 SQLAlchemy-2.0.35-cp39-cp39-win32.whl 1.97MB
47、 SQLAlchemy-2.0.35-cp39-cp39-win_amd64.whl 1.99MB
48、 SQLAlchemy-2.0.35-py3-none-any.whl 1.79MB