3.8.2
Backwards-incompatible changes
- The default row-type for
INSERT
queries executed with a non-defaultRETURNING
clause has changed fromtuple
toModel
instances. This makesINSERT
behavior consistent withUPDATE
andDELETE
queries that specify aRETURNING
clause. To revert back to the old behavior, just append a call to.tuples()
to yourINSERT ... RETURNING
query. - Removing support for the
table_alias
modelMeta
option. Previously, this attribute could be used to specify a "vanity" alias for a model class in the generated SQL. As a result of some changes to support more robust UPDATE and DELETE queries, supporting this feature will require some re-working. As of the 3.8.0 release, it was broken and resulted in incorrect SQL for UPDATE queries, so now it is removed.
New features
- Added
playhouse.shortcuts.ReconnectMixin
, which can be used to implement automatic reconnect under certain error conditions (notably the MySQL error 2006 - server has gone away).
Bugfixes
- Fix SQL generation bug when using an inline window function in the
ORDER BY
clause of a query. - Fix possible zero-division in user-defined implementation of BM25 ranking algorithm for SQLite full-text search.