1.4.29

Released: December 22, 2021

orm

• [orm] [usecase] Added _orm.Session.get.execution_options parameter which was previously missing from the _orm.Session.get() method.

  References: #7410

• [orm] [bug] Fixed issue in new "loader criteria" method _orm.PropComparator.and_() where usage with a loader strategy like _orm.selectinload() against a column that was a member of the .c. collection of a subquery object, where the subquery would be dynamically added to the FROM clause of the statement, would be subject to stale parameter values within the subquery in the SQL statement cache, as the process used by the loader strategy to replace the parameters at execution time would fail to accommodate the subquery when received in this form.

  References: #7489

• [orm] [bug] Fixed recursion overflow which could occur within ORM statement compilation when using either the _orm.with_loader_criteria() feature or the the _orm.PropComparator.and_() method within a loader strategy in conjunction with a subquery which referred to the same entity being altered by the criteria option, or loaded by the loader strategy. A check for coming across the same loader criteria option in a recursive fashion has been added to accommodate for this scenario.

  References: #7491

• [orm] [bug] [mypy] Fixed issue where the __class_getitem__() method of the generated declarative base class by _orm.as_declarative() would lead to inaccessible class attributes such as __table__, for cases where a Generic[T] style typing declaration were used in the class hierarchy. This is in continuation from the basic addition of __class_getitem__() in #7368. Pull request courtesy Kai Mueller.

  References: #7368, #7462

• [orm] [bug] [regression] Fixed caching-related issue where the use of a loader option of the form lazyload(aliased(A).bs).joinedload(B.cs) would fail to result in the joinedload being invoked for runs subsequent to the query being cached, due to a mismatch for the options / object path applied to the objects loaded for a query with a lead entity that used aliased().

  References: #7447

engine

• [engine] [bug] Corrected the error message for the AttributeError that's raised when attempting to write to an attribute on the _result.Row class, which is immutable. The previous message claimed the column didn't exist which is misleading.

  References: #7432

• [engine] [bug] [regression] Fixed regression in the _engine.make_url() function used to parse URL strings where the query string parsing would go into a recursion overflow if a Python 2 u'' string were used.

  References: #7446

mypy

• [mypy] [bug] Fixed mypy regression where the release of mypy 0.930 added additional internal checks to the format of "named types", requiring that they be fully qualified and locatable. This broke the mypy plugin for SQLAlchemy, raising an assertion error, as there was use of symbols such as __builtins__ and other un-locatable or unqualified names that previously had not raised any assertions.

  References: #7496

asyncio

• [asyncio] [usecase] Added _asyncio.async_engine_config() function to create an async engine from a configuration dict. This otherwise behaves the same as _sa.engine_from_config().

  References: #7301

mariadb

• [mariadb] [bug] Corrected the error classes inspected for the "is_disconnect" check for the mariadbconnector dialect, which was failing for disconnects that occurred due to common MySQL/MariaDB error codes such as 2006; the DBAPI appears to currently use the mariadb.InterfaceError exception class for disconnect errors such as error code 2006, which has been added to the list of classes checked.

  References: #7457

tests

• [tests] [bug] [regression] Fixed a regression in the test suite where the test called CompareAndCopyTest::test_all_present would fail on some platforms due to additional testing artifacts being detected. Pull request courtesy Nils Philippsen.

  References: #7450