0c5dfa34b4Accepting request 1274716 from devel:languages:pythonAna Guerrero2025-05-06 14:41:36 +00:00
df425d9a5c- update to 3.18.1: * The behavior of postgresql_ext.BinaryJSONField.contains() has changed. Previously, passing a string to this method would perform a JSON key exists check (? operator) instead of JSON contains (@> operator). As of 3.18.0, this special-case has been **removed** and the contains() method always uses the JSONB contains operator (@>). For the **old** behavior of checking whether a key exists, use the BinaryJSONField.has_key() * Add options to URL-unquote user and password when using the db_url helpers * Support using postgresql:// URLs when connecting to psycopg3.Dirk Mueller2025-05-05 21:03:21 +00:00
12a9b8f335Accepting request 1247409 from devel:languages:pythonAna Guerrero2025-02-20 16:39:47 +00:00
bdc0365267Accepting request 1247372 from home:glaubitz:branches:devel:languages:pythonMatej Cepl2025-02-20 13:20:05 +00:00
0e5a8cc724Accepting request 1223791 from devel:languages:pythonAna Guerrero2024-11-14 15:08:00 +00:00
ea06628a5dAccepting request 1223773 from home:mnhaukeMatej Cepl2024-11-12 21:03:38 +00:00
50a8aee853Accepting request 1222054 from devel:languages:pythonAna Guerrero2024-11-07 15:28:14 +00:00
84719a9de1- update to 3.17.7: * Add db_url support for psycopg3 via psycopg3://. * Ensure double-quotes are escaped properly when introspecting constraints. * A few documentation-related fixes.Dirk Mueller2024-11-07 09:08:24 +00:00
61113e0502- update to 3.17.6: * Fix bug in recursive model.delete_instance() when a table contains foreign-keys at multiple depths of the graph * Fix regression in pool behavior on systems where time.time() returns identical values for two connections. This adds a no-op comparable sentinel to the heap to prevent any recurrence of this problem. * Ensure that subqueries inside CASE statements generate correct SQL. * Fix regression that broke server-side cursors with Postgres * Fix to ensure compatibility with psycopg3 - the libpq TransactionStatus constants are no longer available on the Connection instance. * Fix quoting issue in pwiz that could generate invalid python code for double-quoted string literals used as column defaults.Dirk Mueller2024-08-31 12:14:03 +00:00
d1a2dd014bAccepting request 1179078 from devel:languages:pythonAna Guerrero2024-06-07 13:04:23 +00:00
52b49642cc- update to 3.17.5: * Fixes package installation issue on 3.12 and newer introduced in the last version. - update to 3.17.4: * Fix bug that could occur when using CASE inside a function, and one or more of the CASE clauses consisted of a subquery. Refs #2873. new fix in #2872 for regression in truthiness of cursor. * Fix bug in the conversion of TIMESTAMP type in Sqlite on Python 3.12+. * Fix for hybrid properties on subclasses when aliased (#2888). * Many fixes for SqliteQueueDatabase (#2874, #2876, #2877).Dirk Mueller2024-06-06 20:18:03 +00:00
f29b6a492aAccepting request 1171418 from devel:languages:pythonAna Guerrero2024-05-02 21:48:42 +00:00
c62428be81- update to 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. * Full support for psycopg3. * Basic support for Sqlite jsonb. * Fix bug where calling list(query) resulted in extra queries, #2871Dirk Mueller2024-05-02 16:34:06 +00:00
ffb30b8137Accepting request 1146064 from devel:languages:pythonAna Guerrero2024-02-12 17:52:48 +00:00
b9964ae9ea- Update to 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.Steve Kowalik2024-02-12 02:58:31 +00:00
3749f6a5e8Accepting request 1137846 from devel:languages:pythonAna Guerrero2024-01-10 20:52:26 +00:00
8872b80be8Accepting request 1137767 from home:alarrosa:branches:devel:languages:pythonMatej Cepl2024-01-09 23:36:02 +00:00
a42c4d7567Accepting request 1124001 from devel:languages:pythonAna Guerrero2023-11-07 20:28:37 +00:00
06bfc1fd07- update to 3.17.0: * Only roll-back in the outermost @db.transaction decorator/ctx manager if an unhandled exception occurs. * 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. * 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. - disable apsw from tests for sle15 - can't be build anymore - unbind to cython < 3 - bind to cython < 3 - Update to 3.15.4 Fix bug in test_utils.count_queres() which could erroneously include pool events such as connect/disconnect, etc. set to None. - switch to PyMSQL instead of mysql-connector-python, which is the * This will be a notable release as it adds support for CockroachDB, * Fix non-deterministic join ordering issue when using the filter() * Bulk insert (insert_many() and insert_from()) will now return * Migration extension now supports altering a column's data-type, * Added BloomFilter.from_buffer() method for populating a bloom-filter * Fix for issue #1991 regarding setting intervening models to None.Dirk Mueller2023-11-07 14:24:25 +00:00
d8bf2111adAccepting request 1105035 from devel:languages:pythonAna Guerrero2023-08-22 06:56:17 +00:00
0eb80ce9c2- update to 3.16.2: * Fixes a longstanding issue with thread-safety of various decorators, including atomic(), transaction(), savepoint(). The context-managers are unaffected. * Add changes required for building against Cython 3.0 and set Cython language-level to 3. * Ensure indexes aren't added to unindexed fields during introspection, #2691. * Ensure we don't redundantly select same PK in prefetch when using PREFETCH_TYPE.JOIN. * In Sqlite migrator, use Sqlite's builtin DROP and RENAME column facilities when possible. This can be overridden by passing legacy=True flag. * This release contains backwards-incompatible changes in the way Peewee initializes connections to the underlying database driver. Previously, peewee implemented autocommit semantics *on-top* of the existing DB-API transactional workflow. Going forward, Peewee instead places the DB-API driver into autocommit mode directly.Dirk Mueller2023-06-01 20:07:14 +00:00
dfee961662- update to 3.14.8: * Returning clause can still be specified for Sqlite, however it just needs to be done so manually rather than having it applied automatically. * Fix bug in APSW extension with Sqlite 3.35 and newer, due to handling of last insert rowid with RETURNING. Refs #2479. * Fix pesky bug in new last_insert_id() on the SqliteExtDatabase. * Only raise DoesNotExist when lazy_load is enabled on ForeignKeyField * Add missing convenience method ModelSelect.get_or_none() * Allow ForeignKeyField to specify a custom BackrefAccessorClass * Ensure foreign-key-specific conversions are applied on INSERT and UPDATE * Add handling of MySQL error 4031 (inactivity timeout) to the ReconnectMixin helper class. * Support specification of conflict target for ON CONFLICT/DO NOTHING. * Add encoding parameter to the DataSet freeze() and thaw() methods * Fix bug which prevented DeferredForeignKey from being used as a model's primary key * Ensure foreign key's related object cache is cleared when the foreign-key is set to None. * Allow specification of (schema, table) to be used with CREATE TABLE AS... * Allow reusing open connections with DataSet * Add highlight() and snippet() helpers to Sqlite SearchField, for use with full-text search extension. * Preserve user-provided aliases in column names. * Add support for Sqlite 3.37 strict tables. * Ensure database is inherited when using ThreadSafeDatabaseMetadata, and also adds an implementation in playhouse.shortcuts along with basic unit tests. * Better handling of Model's dirty fields when saving, fixes#2466. * Add basic support for MariaDB connector driver in playhouse.mysql_ext * Begin a basic implementation for a psycopg3-compatible pg databaseDirk Mueller2021-11-13 20:32:37 +00:00
381cbd977b- switch to PyMSQL instead of mysql-connector-python, which is the default since 3.12.x and doesn't have vulnerabilities (bsc#1122204)Dirk Mueller2020-03-18 16:03:04 +00:00
ff4bdf5c8e- Update to 3.9.6: * Support nesting the Database instance as a context-manager. The outermost block will handle opening and closing the connection along with wrapping everything in a transaction. Nested blocks will use savepoints. * Add new session_start(), session_commit() and session_rollback() interfaces to the Database object to support using transactional controls in situations where a context-manager or decorator is awkward. * Fix error that would arise when attempting to do an empty bulk-insert. * Set isolation_level=None in SQLite connection constructor rather than afterwards using the setter. * Add create_table() method to Select query to implement CREATE TABLE AS. * Cleanup some declarations in the Sqlite C extension. * Add new example showing how to implement Reddit's ranking algorithm in SQL.
Tomáš Chvátal
2019-07-23 13:06:44 +00:00
11aaeb9880Accepting request 625960 from home:jengelh:branches:devel:languages:python
Tomáš Chvátal
2018-07-28 18:27:38 +00:00
36c9b77a64- Update to 3.6.4: - bugfixes - works with python 3.7.0 - Support for specifying ROWS or RANGE window frame types. - Add APIs for user-defined window functions if using pysqlite3 and sqlite 3.25.0 or newer. - TimestampField now uses 64-bit integer data-type for storage. - Added support to pwiz and playhouse.reflection to enable generating models from VIEWs. - Added lower-level database API for introspecting VIEWs. - Revamped continuous integration setup for better coverage, including 3.7 and 3.8-dev. - Allow building C extensions even if Cython is not installed, by distributing pre-generated C source files.Matej Cepl2018-07-20 15:21:32 +00:00