This release contains a number of bugfixes, enhancements and a rewrite of much of the documentation.
Changes in 2.3.0
- New and improved documentation
- Added aggregate_rows() method for mitigating N+1 queries.
- Query compiler performance improvements and rewrite of table alias internals (51d82fc and d8d55df).
- Added context-managers and decorators for counting queries and asserting query counts.
- Allow
UPDATE
queries to contain subqueries for values (example). - Support for
INSERT INTO / SELECT FROM
queries (docs). - Allow
SqliteDatabase
to set the database's journal mode. - Added method for concatenation (docs).
- Moved
UUIDField
out of the playhouse and into peewee - Added pskel script.
- Documentation for BerkeleyDB.
Bugs fixed
- #340, allow inner query values to be used in outer query joins.
- #380, fixed foreign key handling in SQLite migrations.
- #389, mark foreign keys as dirty on assignment.
- #391, added an
orwhere()
method. - #392, fixed
order_by
meta option inheritance bug. - #394, fixed UUID and conversion of foreign key values (thanks @alexlatchford).
- #395, allow selecting all columns using
SQL('*')
. - #396, fixed query compiler bug that was adding unnecessary parentheses around expressions.
- #405, fixed behavior of
count()
when query has a limit or offset.