BigAutoField to support 64-bit auto-incrementing primary keys.DataSet. Previously the JSON export used ISO-8601 by default. See #1536.Database.batch_commit helper to wrap iterators in chunked
transactions. See #1539 for discussion.ForeignKeyField did not add it to the model's
"dirty" fields list. #1530.prefetch() with ManyToManyField. Thanks
to @iBelieve for the patch. #1531.JSON data-type for SQLite JSONField instances.json_contains function for use with SQLite json1 extension.0οΈβ£ Investigating #1522, it occurred to me that INSERT queries with non-default RETURNING clauses (postgres-only feature) should always return a cursor object. Previously, if executing a single-row INSERT query, the last-inserted row ID would be returned, regardless of what was specified by the RETURNING clause.
0οΈβ£ This change only affects INSERT queries with non-default RETURNING clauses and will cause a cursor to be returned, as opposed to the last-inserted row ID.
Model.alias() when the model defined a particular
database schema.SchemaManager.create_foreign_key API to simplify adding constraints
when dealing with circular foreign-key relationships. Updated docs
accordingly.Migrator.add_foreign_key_constraint so that it
can be used with Postgresql (in addition to MySQL).PickleField to the playhouse.fields module. Docs.CompressedField when using Python 3.KeyValue API in playhouse.kv module. Docs.Database.bind() has been renamed to Database.bind_ctx(), to more closely
match the semantics of the corresponding model methods, Model.bind() and
Model.bind_ctx(). The new Database.bind() method is a one-time operation
π that binds the given models to the database. See documentation:
schema (if specified) when checking for table-existence.filter() API.insert_many(), refs #1495.tuples() on a ModelRaw query. This was reported
originally as a bug with sqlite-web CSV export. See coleifer/sqlite-web#38.schema inheritance regression, #1485.