baserev update by copy to link target

• Files Changed
• Browse Source

- Update to 3.14.10:
  - Add shortcut for conditional insert using sub-select
  - Add convenience left_outer_join() method to query.
  - Add selected_columns property to Select queries.
  - Add name property to Alias instances.
  - Fix regression in tests introduced by change to DataSet in
    3.14.9.
  - Allow calling table_exists() with a model-class, refs
  - Improve is_connection_usable() method of MySQLDatabase class.
  - Better support for VIEWs with playhouse.dataset.DataSet and
    sqlite-web.
  - Support INSERT / ON CONFLICT in playhosue.kv for newer
    Sqlite.
  - Add ArrayField.contained_by() method, a corollary to
    contains() and the contains_any() methods.
  - Support cyclical foreign-key relationships in
    reflection/introspection, and also for sqlite-web.
  - Add magic methods for FTS5 field to optimize, rebuild and
    integrity check the full-text index.
  - Add fallbacks in setup.py in the event distutils is not
    available.

• Files Changed
• Browse Source

- 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 database

• Files Changed
• Browse Source

- Update to version 3.14.4
  * Bugfix release
- Update to version 3.14.3
  * This release contains a single fix for ensuring NULL values
    are inserted when issuing a bulk-insert of heterogeneous
    dictionaries which may be missing explicit NULL values.
- Update to version 3.14.2
  * Support for named Check and foreign-key constraints.
  * Better foreign-key introspection for CockroachDB (and Postgres)
  * Register UUID adapter for Postgres.
  * Add fn.array_agg() to blacklist for automatic value coercion.
- Update to version 3.14.1
  Changes
  * Properly delegate to a foreign-key field's db_value() function
    when converting model instances.
  * Strip quote marks and parentheses from column names returned
    by sqlite cursor when a function-call is projected without an
    alias.
  * Fix DataSet.create_index() method.
  * Fix column-to-model mapping in model-select from subquery
    with joins.
  * Improvements to foreign-key lazy-loading.
  * Preserve and handle CHECK() constraints in Sqlite migrator.
  * Add stddev aggregate function to collection of sqlite
    user-defined funcs.
- Update to version 3.14.0
  * Add an experimental helper,
    shortcuts.resolve_multimodel_query(),
    for resolving multiple models used in a compound select query.
  * Add a lateral() method to select query for use with lateral

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

submit

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

- switch to PyMSQL instead of mysql-connector-python, which is the 
  default since 3.12.x and doesn't have vulnerabilities (bsc#1122204)

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

- update to 3.13.1
  * This will be a notable release as it adds support for CockroachDB, 
    a distributed, horizontally-scalable SQL database.
  * Allow FOR UPDATE clause to specify one or more tables (FOR UPDATE OF...).
  * Support for Postgres LATERAL join.
  * Fix non-deterministic join ordering issue when using the filter() 
    API across several tables
  * Bulk insert (insert_many() and insert_from()) will now return 
    the row count instead of the last insert ID.
  * Migration extension now supports altering a column's data-type, 
    via the new alter_column_type() method.
  * Added BloomFilter.from_buffer() method for populating a bloom-filter 
    from the output of a previous call to the to_buffer() method.

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

- Pull in the full python for sqlite

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

- Update to 3.11.2
  * Implement hash interface for Alias instances, allowing them to be used in multi-source queries.
  * Workaround for MySQL prior to 8 and MariaDB handling of union queries inside of parenthesized expressions (like IN).
  * Be more permissive in letting invalid values be stored in a field whose type is INTEGER or REAL, since Sqlite allows this.
  * Fix for issue #1991 regarding setting intervening models to None. 
  * Fixes the Model._pk and get_id() interfaces so they no longer introduce the possibility of accidentally resolving the FK.

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

- Update to 3.10.0:
  * Many bugfixes to enumerate, see CHANGELOG.md

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

- 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.

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

- Update to 3.9.5:
  * Added small helper for setting timezone when using Postgres.
  * Improved SQL generation for VALUES clause.
  * Support passing resolution to TimestampField as a power-of-10.
  * Small improvements to INSERT queries when the primary-key is not
    an auto-incrementing integer, but is generated by the database server (eg uuid).
  * Cleanups to virtual table implementation and python-to-sqlite value conversions.
  * Fixed bug related to binding previously-unbound models to a database using a
    context manager, #1913.
- Change in 3.9.4:
  * Add Model.bulk_update() method for bulk-updating fields across multiple
    model instances. Docs.
  * Add lazy_load parameter to ForeignKeyField. When initialized with lazy_load=False,
    the foreign-key will not use an additional query to resolve the related model instance.
  * Added Model.truncate_table() method.
  * The reflection and pwiz extensions now attempt to be smarter about converting
    database table and column names into snake-case.
  * Bulk insert via insert_many() no longer require specification of the fields
    argument when the inserted rows are lists/tuples. In that case, the fields
    will be inferred to be all model fields except any auto-increment id.
  * Add DatabaseProxy, which implements several of the Database class context managers.
  * Add support for window function frame exclusion and added built-in support for the GROUPS frame type.
  * Add support for chaining window functions by extending a previously-declared window function.
  * Playhouse Postgresql extension TSVectorField.match() method supports an additional argument plain,
    which can be used to control the parsing of the TS query.
  * Added very minimal JSONField to the playhouse MySQL extension.
- Update to 3.9.3:
  * Added cross-database support for NULLS FIRST/LAST when specifying
    the ordering for a query. Previously this was only supported for
    Postgres.
  * Added EXCLUDED helper for referring to the EXCLUDED namespace
    used with INSERT...ON CONFLICT queries, when referencing values in
    the conflicting row data.
  * Added helper method to the model Metadata class for setting the
    table name at run-time. Setting the Model._meta.table_name directly
    may have appeared to work in some situations, but could lead to
    subtle bugs. The new API is Model._meta.set_table_name().
  * Enhanced helpers for working with Peewee interactively, see doc.
  * Fix cache invalidation bug in DataSet that was originally reported
    on the sqlite-web project.
  * New example script implementing a hexastore.
- Update to 3.8.2:
  * The default row-type for INSERT queries executed with a non-default
    RETURNING clause has changed from tuple to Model instances. This
    makes INSERT behavior consistent with UPDATE and DELETE queries
    that specify a RETURNING clause.
  * Removing support for the table_alias model Meta option.
  * Added playhouse.shortcuts.ReconnectMixin, which can be used to
    implement automatic reconnect under certain error conditions.
  * 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.
- Update to 3.7.1:
  * Added table_settings model Meta option, which should be a list
    of strings specifying additional options for CREATE TABLE, which
    are placed after the closing parentheses.
  * Allow specification of on_update and on_delete behavior for
    many-to-many relationships when using ManyToManyField.
  * Fixed incorrect SQL generation for Postgresql ON CONFLICT clause
    when the conflict_target is a named constraint (rather than an
    index expression). This introduces a new keyword-argument to the
    on_conflict() method: conflict_constraint, which is currently only
    supported by Postgresql. Refs issue #1737.
  * Fixed incorrect SQL for sub-selects used on the right side of IN
    expressions. Previously the query would be assigned an alias, even
    though an alias was not needed.
  * Fixed incorrect SQL generation for Model indexes which contain SQL
    functions as indexed columns.
  * Fixed bug in the generation of special queries used to perform
    operations on SQLite FTS5 virtual tables.
  * Allow frozenset to be correctly parameterized as a list of values.
  * Allow multi-value INSERT queries to specify columns as a list of
    strings.
  * Support CROSS JOIN for model select queries.
- Add missing "that".
- 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.
- Fixes tests
- Update to 3.5.2:
  * New guide to using window functions in Peewee.
  * New and improved table name auto-generation.
  * Allow passing single fields/columns to window function
    order_by and partition_by arguments.
  * Support for FILTER (WHERE...) clauses with window functions
    and aggregates.
  * Added IdentityField class suitable for use with Postgres 10's
    new identity column type.
  * Fixed bug creating indexes on tables that are in attached
    databases (SQLite).
  * Fixed obscure bug when using prefetch() and ModelAlias to
    populate a back-reference related model.
- Change in 3.5.1:
  * New documentation for working with relationships in Peewee.
  * Improved tests and documentation for MySQL upsert functionality.
  * Allow database parameter to be specified with ModelSelect.get()
    method. For discussion, see #1620.
  * Add QualifiedNames helper to peewee module exports.
  * Add temporary= meta option to support temporary tables.
  * Allow a Database object to be passed to constructor of
    DataSet helper.
- Update to 3.5.0:
  * see: /usr/share/package/python-peewee/CHANGELOG.md
- Build with dependencies: sqlite3, cython
- Build with python3 and python2 (singlespec)
- Drop the noarch package (arch-independent-package-contains-binary-or-object)
- Spec file cleanup
- update version 2.6.3
  * read https://github.com/coleifer/peewee/releases
- update version 2.2.3
  * New migrations module
  * Added a return value to Model.save() indicating number of rows
    affected.
  * Added a date_trunc() method that works for Sqlite.
  * Added a Model.sqlall() class-method to return all the SQL to
    generate the model/indices.
  * bugfixes
- initial version 2.2.2
  * see https://github.com/coleifer/peewee/commits/master for details

• Files Changed
• Browse Source