SQLAlchemy 1.2.7 已发布,引入了一系列针对 Core 和 ORM 的修复:
[orm] [bug] Fixed regression in 1.2 within sharded query feature where the new “identity_token” element was not being correctly considered within the scope of a lazy load operation, when searching the identity map for a related many-to-one element.
[orm] [bug] Fixed issue in single-inheritance loading where the use of an aliased entity against a single-inheritance subclass in conjunction with the
Query.select_from()
method would cause the SQL to be rendered with the unaliased table mixed in to the query, causing a cartesian product.[sql] [bug] Fixed issue where the compilation of an INSERT statement with the “literal_binds” option that also uses an explicit sequence and “inline” generation, as on Postgresql and Oracle, would fail to accommodate the extra keyword argument within the sequence processing routine.
[postgresql] [feature] Added new PG type
postgresql.REGCLASS
which assists in casting table names to OID values. Pull request courtesy Sebastian Bank.[postgresql] [bug] Fixed bug where the special “not equals” operator for the Postgresql “range” datatypes such as DATERANGE would fail to render “IS NOT NULL” when compared to the Python
None
value.[mssql] [bug] Fixed 1.2 regression caused by #4060 where the query used to reflect SQL Server cross-schema foreign keys was limiting the criteria incorrectly.
[oracle] [bug] The Oracle NUMBER datatype is reflected as INTEGER if the precision is NULL and the scale is zero, as this is how INTEGER values come back when reflected from Oracle’s tables. Pull request courtesy Kent Bower.
下载地址:https://www.sqlalchemy.org/download.html
SQLAlchemy 是一个 Python 的 SQL 工具包以及数据库对象映射框架。它包含整套企业级持久化模式,专门用于高效和高性能的数据库访问。
暂无更多评论