Sourced from peewee's releases.

3.17.3

• Better fix for #2871 (extraneous queries when coercing query to list), and new fix in #2872 for regression in truthiness of cursor.

View commits

3.17.2

• Full support for psycopg3.
• Basic support for Sqlite jsonb.
• Fix bug where calling list(query) resulted in extra queries, #2871

View commits

3.17.1

• Add bitwise and other helper methods to BigBitField, #2802.
• Add add_column_default and drop_column_default migrator methods for specifying a server-side default value, #2803.
• The new star attribute was causing issues for users who had a field named star on their models. This attribute is now renamed to __star__. #2796.
• Fix compatibility issues with 3.12 related to utcnow() deprecation.
• Add stricter locking on connection pool to prevent race conditions.
• Add adapters and converters to Sqlite to replace ones deprecated in 3.12.
• Fix bug in model_to_dict() when only aliases are present.
• Fix version check for Sqlite native drop column support.
• Do not specify a reconnect= argument to ping() if using MySQL 8.x.

View commits

3.17.0

• Only roll-back in the outermost @db.transaction decorator/ctx manager if an unhandled exception occurs. Previously, an unhandled exception that occurred in a nested transaction context would trigger a rollback. The use of nested transaction has long been discouraged in the documentation: the recommendation is to always use db.atomic, which will use savepoints to properly handle nested blocks. However, the new behavior should make it easier to reason about transaction boundaries - see #2767 for discussion.
• Cover transaction BEGIN in the reconnect-mixin. Given that no transaction has been started, reconnecting when beginning a new transaction ensures that a reconnect will occur if it is safe to do so.
• Add support for setting isolation_level in db.atomic() and db.transaction() when using Postgres and MySQL/MariaDB, which will apply to the wrapped transaction. Note: Sqlite has supported a similar lock_type parameter for some time.
• Add support for the Sqlite SQLITE_DETERMINISTIC function flag. This allows user-defined Sqlite functions to be used in indexes and may be used by the query planner.
• Fix unreported bug in dataset import when inferred field name differs from column name.

View commits

Sourced from peewee's changelog.

3.17.3

• Better fix for #2871 (extraneous queries when coercing query to list), and new fix in #2872 for regression in truthiness of cursor.

View commits

3.17.2

• Full support for psycopg3.
• Basic support for Sqlite jsonb.
• Fix bug where calling list(query) resulted in extra queries, #2871

View commits

3.17.1

• Add bitwise and other helper methods to BigBitField, #2802.
• Add add_column_default and drop_column_default migrator methods for specifying a server-side default value, #2803.
• The new star attribute was causing issues for users who had a field named star on their models. This attribute is now renamed to __star__. #2796.
• Fix compatibility issues with 3.12 related to utcnow() deprecation.
• Add stricter locking on connection pool to prevent race conditions.
• Add adapters and converters to Sqlite to replace ones deprecated in 3.12.
• Fix bug in model_to_dict() when only aliases are present.
• Fix version check for Sqlite native drop column support.
• Do not specify a reconnect= argument to ping() if using MySQL 8.x.

View commits

3.17.0

• Only roll-back in the outermost @db.transaction decorator/ctx manager if an unhandled exception occurs. Previously, an unhandled exception that occurred in a nested transaction context would trigger a rollback. The use of nested transaction has long been discouraged in the documentation: the recommendation is to always use db.atomic, which will use savepoints to properly handle nested blocks. However, the new behavior should make it easier to reason about transaction boundaries - see #2767 for discussion.
• Cover transaction BEGIN in the reconnect-mixin. Given that no transaction has been started, reconnecting when beginning a new transaction ensures that a reconnect will occur if it is safe to do so.
• Add support for setting isolation_level in db.atomic() and db.transaction() when using Postgres and MySQL/MariaDB, which will apply to the wrapped transaction. Note: Sqlite has supported a similar lock_type parameter for some time.
• Add support for the Sqlite SQLITE_DETERMINISTIC function flag. This allows user-defined Sqlite functions to be used in indexes and may be used by the query planner.

... (truncated)

• 9dae730 3.17.3
• ec87d30 Better fix for #2871, fixes #2872.
• b0404ee 3.17.2
• 148f1b7 Avoid unnecessary queries when coercing query to list.
• 4451b97 Fix pg3 errors name error.
• 717e2fb Additional test coverage and fix psycopg3 failure.
• e896704 Better inter-op when psycopg2 is also present.
• 0e25328 All tests passing, removed check for psycopg2+Json in field initializer.
• 0c81533 Add pool implementation and test fixes for psycopg3.
• 4c1a9c6 Fix failing SQL tests w/change to IS/IS NOT NULL
• Additional commits viewable in compare view

You can trigger Dependabot actions by commenting on this PR:

• @dependabot rebase will rebase this PR
• @dependabot recreate will recreate this PR, overwriting any edits that have been made to it
• @dependabot merge will merge this PR after your CI passes on it
• @dependabot squash and merge will squash and merge this PR after your CI passes on it
• @dependabot cancel merge will cancel a previously requested merge and block automerging
• @dependabot reopen will reopen this PR if it is closed
• @dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
• @dependabot show <dependency name> ignore conditions will show all of the ignore conditions of the specified dependency
• @dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)