The NetBSD Project

CVS log for pkgsrc/databases/py-peewee/Makefile

[BACK] Up to [cvs.NetBSD.org] / pkgsrc / databases / py-peewee

Request diff between arbitrary revisions


Keyword substitution: kv
Default branch: MAIN


Revision 1.114: download - view: text, markup, annotated - select for diffs
Thu Nov 14 22:19:11 2024 UTC (3 weeks, 5 days ago) by wiz
Branches: MAIN
CVS tags: HEAD
Diff to: previous 1.113: preferred, colored
Changes since revision 1.113: +2 -1 lines
*: recursive bump for icu 76 shlib major version bump

Revision 1.113: download - view: text, markup, annotated - select for diffs
Wed Nov 13 10:52:27 2024 UTC (4 weeks ago) by adam
Branches: MAIN
Diff to: previous 1.112: preferred, colored
Changes since revision 1.112: +2 -3 lines
py-peewee: updated to 3.17.8

3.17.8

* Fix regression in behavior of `delete_instance()` when traversing nullable
  foreign-keys
* Fix bug where joins not cloned when going from join-less -> joined query

Revision 1.112: download - view: text, markup, annotated - select for diffs
Mon Nov 11 07:27:57 2024 UTC (4 weeks, 2 days ago) by wiz
Branches: MAIN
Diff to: previous 1.111: preferred, colored
Changes since revision 1.111: +1 -2 lines
py-*: remove unused tool dependency

py-setuptools includes the py-wheel functionality nowadays

Revision 1.111: download - view: text, markup, annotated - select for diffs
Fri Nov 1 12:51:56 2024 UTC (5 weeks, 4 days ago) by wiz
Branches: MAIN
Diff to: previous 1.110: preferred, colored
Changes since revision 1.110: +2 -2 lines
*: revbump for icu downgrade

Revision 1.110: download - view: text, markup, annotated - select for diffs
Fri Nov 1 00:51:09 2024 UTC (5 weeks, 5 days ago) by wiz
Branches: MAIN
Diff to: previous 1.109: preferred, colored
Changes since revision 1.109: +2 -1 lines
*: recursive bump for icu 76.1 shlib bump

Revision 1.109: download - view: text, markup, annotated - select for diffs
Tue Oct 15 16:09:05 2024 UTC (8 weeks ago) by adam
Branches: MAIN
Diff to: previous 1.108: preferred, colored
Changes since revision 1.108: +2 -2 lines
py-peewee: updated to 3.17.7

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.

Revision 1.108: download - view: text, markup, annotated - select for diffs
Mon Oct 14 06:45:34 2024 UTC (8 weeks, 2 days ago) by wiz
Branches: MAIN
Diff to: previous 1.107: preferred, colored
Changes since revision 1.107: +2 -2 lines
*: clean-up after python38 removal

Revision 1.107: download - view: text, markup, annotated - select for diffs
Sat Aug 10 06:52:57 2024 UTC (4 months ago) by adam
Branches: MAIN
CVS tags: pkgsrc-2024Q3-base, pkgsrc-2024Q3
Diff to: previous 1.106: preferred, colored
Changes since revision 1.106: +2 -2 lines
py-peewee: not for Python 3.9

Revision 1.106: download - view: text, markup, annotated - select for diffs
Tue Jul 16 03:46:24 2024 UTC (4 months, 3 weeks ago) by adam
Branches: MAIN
Diff to: previous 1.105: preferred, colored
Changes since revision 1.105: +2 -3 lines
py-peewee: updated to 3.17.6

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 (introduced in 3.16.0).
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.

Revision 1.105: download - view: text, markup, annotated - select for diffs
Wed May 29 16:31:52 2024 UTC (6 months, 1 week ago) by adam
Branches: MAIN
CVS tags: pkgsrc-2024Q2-base, pkgsrc-2024Q2
Diff to: previous 1.104: preferred, colored
Changes since revision 1.104: +2 -1 lines
revbump after icu and protobuf updates

Revision 1.104: download - view: text, markup, annotated - select for diffs
Sat May 11 05:04:56 2024 UTC (7 months ago) by adam
Branches: MAIN
Diff to: previous 1.103: preferred, colored
Changes since revision 1.103: +2 -2 lines
py-peewee: updated to 3.17.5

3.17.5

This release fixes a build system problem in Python 3.12.


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.
Fix bug in the conversion of TIMESTAMP type in Sqlite on Python 3.12+.
Fix for hybrid properties on subclasses when aliased.
Many fixes for SqliteQueueDatabase

Revision 1.103: download - view: text, markup, annotated - select for diffs
Thu Apr 18 04:33:57 2024 UTC (7 months, 3 weeks ago) by adam
Branches: MAIN
Diff to: previous 1.102: preferred, colored
Changes since revision 1.102: +2 -2 lines
py-peewee: updated to 3.17.3

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.

Revision 1.102: download - view: text, markup, annotated - select for diffs
Wed Apr 17 13:23:40 2024 UTC (7 months, 3 weeks ago) by adam
Branches: MAIN
Diff to: previous 1.101: preferred, colored
Changes since revision 1.101: +2 -2 lines
py-peewee: updated to 3.17.2

3.17.2

* Full support for `psycopg3`.
* Basic support for Sqlite `jsonb`.
* Fix bug where calling `list(query)` resulted in extra queries.

Revision 1.101: download - view: text, markup, annotated - select for diffs
Mon Feb 5 21:15:50 2024 UTC (10 months ago) by adam
Branches: MAIN
CVS tags: pkgsrc-2024Q1-base, pkgsrc-2024Q1
Diff to: previous 1.100: preferred, colored
Changes since revision 1.100: +6 -5 lines
py-peewee: updated to 3.17.1

3.17.1

* Add bitwise and other helper methods to `BigBitField`.
* Add `add_column_default` and `drop_column_default` migrator methods for
  specifying a server-side default value.
* 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__`.
* 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.

Revision 1.100: download - view: text, markup, annotated - select for diffs
Wed Nov 8 13:18:35 2023 UTC (13 months ago) by wiz
Branches: MAIN
CVS tags: pkgsrc-2023Q4-base, pkgsrc-2023Q4
Diff to: previous 1.99: preferred, colored
Changes since revision 1.99: +2 -2 lines
*: recursive bump for icu 74.1

Revision 1.99: download - view: text, markup, annotated - select for diffs
Tue Nov 7 22:37:57 2023 UTC (13 months ago) by wiz
Branches: MAIN
Diff to: previous 1.98: preferred, colored
Changes since revision 1.98: +2 -2 lines
*: latest py-sphinx only support Python 3.9+

Revision 1.98: download - view: text, markup, annotated - select for diffs
Mon Oct 23 06:37:37 2023 UTC (13 months, 2 weeks ago) by wiz
Branches: MAIN
Diff to: previous 1.97: preferred, colored
Changes since revision 1.97: +3 -2 lines
*: update for Python base package change

Instead of depending on one of the removed packages (that are now included
in the base Python packages), include batteries-included.mk to require
a Python version that supplies them.

Remove now included packages.

Bump PKGREVISION.

Revision 1.97: download - view: text, markup, annotated - select for diffs
Mon Oct 16 13:05:30 2023 UTC (13 months, 3 weeks ago) by adam
Branches: MAIN
Diff to: previous 1.96: preferred, colored
Changes since revision 1.96: +3 -2 lines
py-peewee: updated to 3.17.0

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

Revision 1.96: download - view: text, markup, annotated - select for diffs
Fri Aug 25 15:21:43 2023 UTC (15 months, 2 weeks ago) by adam
Branches: MAIN
CVS tags: pkgsrc-2023Q3-base, pkgsrc-2023Q3
Diff to: previous 1.95: preferred, colored
Changes since revision 1.95: +2 -2 lines
py-peewee: updated to 3.16.3

3.16.3

Support for Cython 3.0.
Add flag to ManyToManyField to prevent setting/getting values on unsaved instances. This is worthwhile, since reading or writing a many-to-many has no meaning when the instance is unsaved.
Adds a star() helper to Source base-class for selecting all columns.
Fix missing binary types for mysql-connector and mariadb-connector.
Add extract() method to MySQL JSONField for extracting a jsonpath.

Revision 1.95: download - view: text, markup, annotated - select for diffs
Tue Jun 6 12:40:33 2023 UTC (18 months ago) by riastradh
Branches: MAIN
CVS tags: pkgsrc-2023Q2-base, pkgsrc-2023Q2
Diff to: previous 1.94: preferred, colored
Changes since revision 1.94: +2 -2 lines
Mass-change BUILD_DEPENDS to TOOL_DEPENDS outside mk/.

Almost all uses, if not all of them, are wrong, according to the
semantics of BUILD_DEPENDS (packages built for target available for
use _by_ tools at build-time) and TOOL_DEPEPNDS (packages built for
host available for use _as_ tools at build-time).

No change to BUILD_DEPENDS as used correctly inside buildlink3.

As proposed on tech-pkg:
https://mail-index.netbsd.org/tech-pkg/2023/06/03/msg027632.html

Revision 1.94: download - view: text, markup, annotated - select for diffs
Sun Apr 23 10:47:27 2023 UTC (19 months, 2 weeks ago) by adam
Branches: MAIN
Diff to: previous 1.93: preferred, colored
Changes since revision 1.93: +2 -3 lines
py-peewee: updated to 3.16.2

3.16.2

Fixes a longstanding issue with thread-safety of various decorators, including
`atomic()`, `transaction()`, `savepoint()`. The context-managers are
unaffected.

Revision 1.93: download - view: text, markup, annotated - select for diffs
Wed Apr 19 08:09:33 2023 UTC (19 months, 3 weeks ago) by adam
Branches: MAIN
Diff to: previous 1.92: preferred, colored
Changes since revision 1.92: +2 -1 lines
revbump after textproc/icu update

Revision 1.92: download - view: text, markup, annotated - select for diffs
Wed Apr 19 05:02:59 2023 UTC (19 months, 3 weeks ago) by adam
Branches: MAIN
Diff to: previous 1.91: preferred, colored
Changes since revision 1.91: +2 -2 lines
py-peewee: updated to 3.16.1

3.16.1

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

Revision 1.91: download - view: text, markup, annotated - select for diffs
Wed Mar 8 12:16:07 2023 UTC (21 months ago) by adam
Branches: MAIN
CVS tags: pkgsrc-2023Q1-base, pkgsrc-2023Q1
Diff to: previous 1.90: preferred, colored
Changes since revision 1.90: +2 -3 lines
py-peewee: updated to 3.16.0

3.16.0

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.

Why this change?

Previously, Peewee emulated autocommit behavior for top-level queries issued
outside of a transaction. This necessitated a number of checks which had to be
performed each time a query was executed, so as to ensure that we didn't end up
with uncommitted writes or, conversely, idle read transactions. By running the
underlying driver in autocommit mode, we can eliminate all these checks, since
we are already managing transactions ourselves.

Behaviorally, there should be no change -- Peewee will still treat top-level
queries outside of transactions as being autocommitted, while queries inside of
atomic() / with db: blocks are implicitly committed at the end of the
block, or rolled-back if an exception occurs.

How might this affect me?

If you are using the underlying database connection or cursors, e.g. via Database.connection() or Database.cursor(), your queries will now be executed in autocommit mode.
The commit= argument is deprecated for the cursor(), execute() and execute_sql() methods.
If you have a custom Database implementation (whether for a database that is not officially supported, or for the purpose of overriding default behaviors), you will want to ensure that your connections are opened in autocommit mode.

Other changes:

Some fixes to help with packaging in Python 3.11.
MySQL get_columns() implementation now returns columns in their declared order.

Revision 1.90: download - view: text, markup, annotated - select for diffs
Wed Nov 23 16:19:43 2022 UTC (2 years ago) by adam
Branches: MAIN
CVS tags: pkgsrc-2022Q4-base, pkgsrc-2022Q4
Diff to: previous 1.89: preferred, colored
Changes since revision 1.89: +2 -1 lines
massive revision bump after textproc/icu update

Revision 1.89: download - view: text, markup, annotated - select for diffs
Sat Nov 12 11:00:34 2022 UTC (2 years ago) by adam
Branches: MAIN
Diff to: previous 1.88: preferred, colored
Changes since revision 1.88: +2 -2 lines
py-peewee: updated to 3.15.4

3.15.4

* Raise an exception in `ReconnectMixin` if connection is lost while inside a
  transaction (if the transaction was interrupted presumably some changes were
  lost and explicit intervention is needed).
* Add `db.Model` property to reduce boilerplate.
* Add support for running `prefetch()` queries with joins instead of subqueries
  (this helps overcome a MySQL limitation about applying LIMITs to a subquery).
* Add SQL `AVG` to whitelist to avoid coercing by default.
* Allow arbitrary keywords in metaclass constructor.
* Add a `pyproject.toml` to silence warnings from newer pips when `wheel`
  package is not available.

Revision 1.88: download - view: text, markup, annotated - select for diffs
Mon Sep 26 13:24:14 2022 UTC (2 years, 2 months ago) by adam
Branches: MAIN
Diff to: previous 1.87: preferred, colored
Changes since revision 1.87: +2 -2 lines
py-peewee: updated to 3.15.3

3.15.3

* Add `scalars()` query method (complements `scalar()`), roughly equivalent to
  writing `[t[0] for t in query.tuples()]`.
* Small doc improvements
* Fix and remove some flaky test assertions with Sqlite INSERT + RETURNING.
* Fix innocuous failing Sqlite test on big-endian machines.

Revision 1.87: download - view: text, markup, annotated - select for diffs
Mon Sep 12 08:25:05 2022 UTC (2 years, 2 months ago) by adam
Branches: MAIN
CVS tags: pkgsrc-2022Q3-base, pkgsrc-2022Q3
Diff to: previous 1.86: preferred, colored
Changes since revision 1.86: +2 -2 lines
py-peewee: updated to 3.15.2

3.15.2

Fix bug where field-specific conversions were being applied to the pattern used for LIKE / ILIKE operations.
Fix possible infinite loop when accidentally invoking the __iter__ method on certain Column subclasses.
Add new helper for specifying which Model a particular selected column-like should be bound to, in queries with joins that select from multiple sources.

Revision 1.86: download - view: text, markup, annotated - select for diffs
Fri Jul 15 06:19:36 2022 UTC (2 years, 4 months ago) by adam
Branches: MAIN
Diff to: previous 1.85: preferred, colored
Changes since revision 1.85: +2 -2 lines
py-peewee: updated to 3.15.1

3.15.1
Fix issue introduced in Sqlite 3.39.0 regarding the propagation of column subtypes in subqueries. Affected sqlite changelog extension when used with JSON columns.
Fix bug where cockroachdb server version was not set when beginning a transaction on an unopened database.

Revision 1.85: download - view: text, markup, annotated - select for diffs
Fri Jun 17 17:35:22 2022 UTC (2 years, 5 months ago) by adam
Branches: MAIN
CVS tags: pkgsrc-2022Q2-base, pkgsrc-2022Q2
Diff to: previous 1.84: preferred, colored
Changes since revision 1.84: +2 -3 lines
py-peewee: updated to 3.15.0

3.15.0

Rollback behavior change in commit ab43376697. Peewee will no longer automatically return the cursor rowcount for certain bulk-inserts. This should only affect users of MySQL and Sqlite who relied on a bulk INSERT returning the rowcount (as opposed to the cursor's lastrowid). The rowcount behavior is still available chaining the as_rowcount() method:

# NOTE: this change only affects MySQL or Sqlite.
db = MySQLDatabase(...)

# Previously, bulk inserts of the following forms would return the rowcount.
query = User.insert_many(...)  # Bulk insert.
query = User.insert_from(...)  # Bulk insert (INSERT INTO .. SELECT FROM).

# Previous behavior (peewee 3.12 - 3.14.10):
# rows_inserted = query.execute()

# New behavior:
last_id = query.execute()

# To get the old behavior back:
rows_inserted = query.as_rowcount().execute()
This release contains a fix for a long-standing request to allow data-modifying queries to support CTEs. CTEs are now supported for use with INSERT, DELETE and UPDATE queries.

Additionally, this release adds better support for using the new RETURNING syntax with Sqlite automatically. Specify returing_clause=True when initializing your SqliteDatabase and all bulk inserts will automatically specify a RETURNING clause, returning the newly-inserted primary keys. This functionality requires Sqlite 3.35 or newer.

Smaller changes:

Add shortcuts.insert_where() helper for generating conditional INSERT with a bit less boilerplate.
Fix bug in test_utils.count_queres() which could erroneously include pool events such as connect/disconnect, etc.

Revision 1.84: download - view: text, markup, annotated - select for diffs
Mon Apr 18 19:10:44 2022 UTC (2 years, 7 months ago) by adam
Branches: MAIN
Diff to: previous 1.83: preferred, colored
Changes since revision 1.83: +2 -1 lines
revbump for textproc/icu update

Revision 1.83: download - view: text, markup, annotated - select for diffs
Mon Mar 7 18:33:15 2022 UTC (2 years, 9 months ago) by adam
Branches: MAIN
CVS tags: pkgsrc-2022Q1-base, pkgsrc-2022Q1
Diff to: previous 1.82: preferred, colored
Changes since revision 1.82: +2 -2 lines
py-peewee: updated to 3.14.10

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.

Revision 1.82: download - view: text, markup, annotated - select for diffs
Wed Feb 16 08:53:54 2022 UTC (2 years, 9 months ago) by adam
Branches: MAIN
Diff to: previous 1.81: preferred, colored
Changes since revision 1.81: +2 -3 lines
py-peewee: updated to 3.14.9

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.

Revision 1.81: download - view: text, markup, annotated - select for diffs
Tue Jan 4 20:52:43 2022 UTC (2 years, 11 months ago) by wiz
Branches: MAIN
Diff to: previous 1.80: preferred, colored
Changes since revision 1.80: +2 -2 lines
*: bump PKGREVISION for egg.mk users

They now have a tool dependency on py-setuptools instead of a DEPENDS

Revision 1.80: download - view: text, markup, annotated - select for diffs
Thu Dec 16 12:59:44 2021 UTC (2 years, 11 months ago) by wiz
Branches: MAIN
CVS tags: pkgsrc-2021Q4-base, pkgsrc-2021Q4
Diff to: previous 1.79: preferred, colored
Changes since revision 1.79: +3 -3 lines
py-peewee: mark as not for python 2.7

Uses sphinx features that last version compatible with python 2.7 does
not provide.

Revision 1.79: download - view: text, markup, annotated - select for diffs
Wed Dec 8 16:03:48 2021 UTC (3 years ago) by adam
Branches: MAIN
Diff to: previous 1.78: preferred, colored
Changes since revision 1.78: +2 -1 lines
revbump for icu and libffi

Revision 1.78: download - view: text, markup, annotated - select for diffs
Fri Oct 29 16:17:23 2021 UTC (3 years, 1 month ago) by adam
Branches: MAIN
Diff to: previous 1.77: preferred, colored
Changes since revision 1.77: +2 -2 lines
py-peewee: updated to 3.14.8

3.14.8

Back-out all changes to automatically use RETURNING for `SqliteExtDatabase`,
`CSqliteExtDatabase` and `APSWDatabase`. The issue I found is that when a
RETURNING cursor is not fully-consumed, any parent SAVEPOINT (and possibly
transaction) would not be able to be released. Since this is a
backwards-incompatible change, I am going to back it out for now.

Returning clause can still be specified for Sqlite, however it just needs to be
done so manually rather than having it applied automatically.

Revision 1.77: download - view: text, markup, annotated - select for diffs
Wed Oct 27 15:25:37 2021 UTC (3 years, 1 month ago) by adam
Branches: MAIN
Diff to: previous 1.76: preferred, colored
Changes since revision 1.76: +2 -3 lines
py-peewee: updated to 3.14.7

3.14.7

Fix bug in APSW extension with Sqlite 3.35 and newer, due to handling of last
insert rowid with RETURNING.


3.14.6

Fix pesky bug in new `last_insert_id()` on the `SqliteExtDatabase`.


3.14.5

This release contains a number of bug-fixes and small improvements.

* 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.
* Add basic support for MariaDB connector driver in `playhouse.mysql_ext`.
* Begin a basic implementation for a psycopg3-compatible pg database.
* Add provisional support for RETURNING when using the appropriate versions of
  Sqlite or MariaDB.

Revision 1.76: download - view: text, markup, annotated - select for diffs
Wed Apr 21 11:41:19 2021 UTC (3 years, 7 months ago) by adam
Branches: MAIN
CVS tags: pkgsrc-2021Q3-base, pkgsrc-2021Q3, pkgsrc-2021Q2-base, pkgsrc-2021Q2
Diff to: previous 1.75: preferred, colored
Changes since revision 1.75: +2 -1 lines
revbump for textproc/icu

Revision 1.75: download - view: text, markup, annotated - select for diffs
Sat Mar 20 06:59:28 2021 UTC (3 years, 8 months ago) by adam
Branches: MAIN
CVS tags: pkgsrc-2021Q1-base, pkgsrc-2021Q1
Diff to: previous 1.74: preferred, colored
Changes since revision 1.74: +2 -2 lines
py-peewee: updated to 3.14.4

3.14.4

This release contains an important fix for a regression introduced by commit
ebe3ad5, which affected the way model instances are converted to parameters for
use in expressions within a query. The bug could manifest when code uses model
instances as parameters in expressions against fields that are not
foreign-keys.

Revision 1.74: download - view: text, markup, annotated - select for diffs
Fri Mar 12 12:54:56 2021 UTC (3 years, 9 months ago) by adam
Branches: MAIN
Diff to: previous 1.73: preferred, colored
Changes since revision 1.73: +2 -2 lines
py-peewee: updated to 3.14.3

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.

Revision 1.73: download - view: text, markup, annotated - select for diffs
Fri Mar 5 07:54:16 2021 UTC (3 years, 9 months ago) by adam
Branches: MAIN
Diff to: previous 1.72: preferred, colored
Changes since revision 1.72: +2 -2 lines
py-peewee: updated to 3.14.2

3.14.2

This is a small release mainly to get some fixes out.

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

Revision 1.72: download - view: text, markup, annotated - select for diffs
Mon Feb 8 06:17:13 2021 UTC (3 years, 10 months ago) by adam
Branches: MAIN
Diff to: previous 1.71: preferred, colored
Changes since revision 1.71: +2 -2 lines
py-peewee: updated to 3.14.1

3.14.1

This release contains primarily bugfixes.

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.

Revision 1.71: download - view: text, markup, annotated - select for diffs
Wed Dec 23 08:07:59 2020 UTC (3 years, 11 months ago) by adam
Branches: MAIN
CVS tags: pkgsrc-2020Q4-base, pkgsrc-2020Q4
Diff to: previous 1.70: preferred, colored
Changes since revision 1.70: +5 -1 lines
py-peewee: fix building with Python 3.9

Revision 1.70: download - view: text, markup, annotated - select for diffs
Mon Nov 9 09:29:12 2020 UTC (4 years, 1 month ago) by adam
Branches: MAIN
Diff to: previous 1.69: preferred, colored
Changes since revision 1.69: +2 -3 lines
py-peewee: updated to 3.14.0

3.14.0

This release has been a bit overdue and there are numerous small improvements
and bug-fixes. The bugfix that prompted this release is 2293, which is a
regression in the Django-inspired .filter() APIs that could cause some
filter expressions to be discarded from the generated SQL. Many thanks for the
excellent bug report, Jakub.

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 joins.
Added support for nested transactions (savepoints) in cockroach-db (requires 20.1 or newer).
Automatically escape wildcards passed to string-matching methods.
Allow index-type to be specified on MySQL.
Added a new API, converter() to be used for specifying a function to use to convert a row-value pulled off the cursor.
Add set() and clear() method to the bitfield flag descriptor.
Add support for range types with IN and other expressions.
Support CTEs bound to compound select queries.

Bug-fixes

Fix to return related object id when accessing via the object-id descriptor, when the related object is not populated.
Fix to ensure we do not insert a NULL value for a primary key.
Fix to conditionally set the field/column on an added column in a migration.
Apply field conversion logic to model-class values.
Clone node before modifying it to be flat in an enclosed nodelist expr.
Fix an invalid item assignment in nodelist.
Fix an incorrect truthiness check used with save() and only=.
Fix regression in filter() where using both *args and **kwargs caused the expressions passed as args to be discarded.

Revision 1.69: download - view: text, markup, annotated - select for diffs
Thu Nov 5 09:07:48 2020 UTC (4 years, 1 month ago) by ryoon
Branches: MAIN
Diff to: previous 1.68: preferred, colored
Changes since revision 1.68: +2 -2 lines
*: Recursive revbump from textproc/icu-68.1

Revision 1.68: download - view: text, markup, annotated - select for diffs
Tue Jun 2 08:23:31 2020 UTC (4 years, 6 months ago) by adam
Branches: MAIN
CVS tags: pkgsrc-2020Q3-base, pkgsrc-2020Q3, pkgsrc-2020Q2-base, pkgsrc-2020Q2
Diff to: previous 1.67: preferred, colored
Changes since revision 1.67: +2 -1 lines
Revbump for icu

Revision 1.67: download - view: text, markup, annotated - select for diffs
Wed May 27 19:37:38 2020 UTC (4 years, 6 months ago) by wiz
Branches: MAIN
Diff to: previous 1.66: preferred, colored
Changes since revision 1.66: +2 -2 lines
*: reset MAINTAINER for fhajny on his request

Revision 1.66: download - view: text, markup, annotated - select for diffs
Fri Apr 24 08:26:56 2020 UTC (4 years, 7 months ago) by adam
Branches: MAIN
Diff to: previous 1.65: preferred, colored
Changes since revision 1.65: +3 -4 lines
py-peewee: updated to 3.13.3

3.13.3
Allow arbitrary keyword arguments to be passed to DataSet constructor, which are then passed to the instrospector.
Allow scalar subqueries to be compared using numeric operands.
Fix bulk_create() when model being inserted uses FK identifiers.
Fix bulk_update() so that PK values are properly coerced to the right data-type (e.g. UUIDs to strings for Sqlite).
Allow array indices to be used as dict keys, e.g. for the purposes of updating a single array index value.

Revision 1.65: download - view: text, markup, annotated - select for diffs
Sun Apr 12 08:28:26 2020 UTC (4 years, 8 months ago) by adam
Branches: MAIN
Diff to: previous 1.64: preferred, colored
Changes since revision 1.64: +2 -1 lines
Recursive revision bump after textproc/icu update

Revision 1.64: download - view: text, markup, annotated - select for diffs
Mon Mar 30 13:08:24 2020 UTC (4 years, 8 months ago) by adam
Branches: MAIN
Diff to: previous 1.63: preferred, colored
Changes since revision 1.63: +2 -2 lines
py-peewee: updated to 3.13.2

3.13.2

* Allow aggregate functions to support an `ORDER BY` clause, via the addition
  of an `order_by()` method to the function (`fn`) instance.
* Fix `prefetch()` bug, where related "backref" instances were marked as dirty,
  even though they had no changes.
* Support `LIMIT 0`. Previously a limit of 0 would be translated into
  effectively an unlimited query on MySQL.
* Support indexing into arrays using expressions with Postgres array fields.
* Ensure postgres introspection methods return the columns for multi-column
  indexes in the correct order.
* Add support for arrays of UUIDs to postgres introspection.
* Fix introspection of columns w/capitalized table names in postgres.
* Fix to ensure correct exception is raised in SqliteQueueDatabase when
  iterating over cursor/result-set.
* Fix bug comparing subquery against a scalar value.
* Fix issue resolving composite primary-keys that include foreign-keys when
  building the model-graph.
* Allow model-classes to be passed as arguments, e.g., to a table function.
* Ensure postgres `JSONField.concat()` accepts expressions as arguments.

Revision 1.63: download - view: text, markup, annotated - select for diffs
Sun Dec 8 21:46:35 2019 UTC (5 years ago) by adam
Branches: MAIN
CVS tags: pkgsrc-2020Q1-base, pkgsrc-2020Q1, pkgsrc-2019Q4-base, pkgsrc-2019Q4
Diff to: previous 1.62: preferred, colored
Changes since revision 1.62: +2 -2 lines
py-peewee: updated to 3.13.1

3.13.1
Fix a regression when specifying keyword arguments to the atomic() or
transaction() helper methods. Note: this only occurs if you were using Sqlite
and were explicitly setting the lock_type= parameter.


3.13.0
CockroachDB support added

This will be a notable release as it adds support for
CockroachDB, a distributed, horizontally-scalable
SQL database.

CockroachDB usage overview
CockroachDB API documentation
Other features and fixes

Allow FOR UPDATE clause to specify one or more tables (FOR UPDATE OF...).
Support for Postgres LATERAL join.
Properly wrap exceptions raised during explicit commit/rollback in the appropriate peewee-specific exception class.
Capture original exception object and expose it as exc.orig on the wrapped exception.
Properly introspect SMALLINT columns in Postgres schema reflection.
More flexible handling of passing database-specific arguments to atomic() and transaction() context-manager/decorator.
Fix non-deterministic join ordering issue when using the filter() API across several tables

Revision 1.62: download - view: text, markup, annotated - select for diffs
Mon Nov 25 10:42:13 2019 UTC (5 years ago) by adam
Branches: MAIN
Diff to: previous 1.61: preferred, colored
Changes since revision 1.61: +2 -2 lines
py-peewee: updated to 3.12.0

3.12.0
* Bulk insert (`insert_many()` and `insert_from()`) will now return the row
  count instead of the last insert ID. If you are using Postgres, peewee will
  continue to return a cursor that provides an iterator over the newly-inserted
  primary-key values by default. This behavior is being retained by default for
  compatibility. Postgres users can simply specify an empty `returning()` call
  to disable the cursor and retrieve the rowcount instead.
* Migration extension now supports altering a column's data-type, via the new
  `alter_column_type()` method.
* Added `Database.is_connection_usabe()` method, which attempts to look at the
  status of the underlying DB-API connection to determine whether the
  connection is usable.
* Common table expressions include a `materialized` parameter, which can be
  used to control Postgres' optimization fencing around CTEs.
* Added `BloomFilter.from_buffer()` method for populating a bloom-filter from
  the output of a previous call to the `to_buffer()` method.
* Fixed APSW extension's `commit()` and `rollback()` methods to no-op if the
  database is in auto-commit mode.
* Added `generate_always=` option to the `IdentityField` (defaults to False).

Revision 1.61: download - view: text, markup, annotated - select for diffs
Mon Oct 21 21:19:35 2019 UTC (5 years, 1 month ago) by adam
Branches: MAIN
Diff to: previous 1.60: preferred, colored
Changes since revision 1.60: +5 -3 lines
Switch sphinx to versioned deps.

Revision 1.60: download - view: text, markup, annotated - select for diffs
Wed Oct 2 07:45:42 2019 UTC (5 years, 2 months ago) by adam
Branches: MAIN
Diff to: previous 1.59: preferred, colored
Changes since revision 1.59: +2 -2 lines
py-peewee: updated to 3.11.2

3.11.2
* Implement `hash` interface for `Alias` instances, allowing them to be used in
  multi-source queries.

3.11.1
* Fix bug in new `_pk` / `get_id()` implementation for models that explicitly
  have disabled a primary-key.

3.11.0
* Fixes 1991. This particular issue involves joining 3 models together in a
  chain, where the outer two models are empty. Previously peewee would make the
  middle model an empty model instance (since a link might be needed from the
  source model to the outermost model). But since both were empty, it is more
  correct to make the intervening model a NULL value on the foreign-key field
  rather than an empty instance.
* An unrelated fix came out of the work on 1991 where hashing a model whose
  primary-key happened to be a foreign-key could trigger the FK resolution
  query. This patch fixes the `Model._pk` and `get_id()` interfaces so they
  no longer introduce the possibility of accidentally resolving the FK.
* Allow `Field.contains()`, `startswith()` and `endswith()` to compare against
  another column-like object or expression.
* 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.
* `TimestampField` resolution cleanup. Now values 0 *and* 1 will resolve to a
  timestamp resolution of 1 second. Values 2-6 specify the number of decimal
  places (hundredths to microsecond), or alternatively the resolution can still
  be provided as a power of 10, e.g. 10, 1000 (millisecond), 1e6 (microsecond).
* When self-referential foreign-keys are inherited, the foreign-key on the
  subclass will also be self-referential (rather than pointing to the parent
  model).
* Add TSV import/export option to the `dataset` extension.
* Add item interface to the `dataset.Table` class for doing primary-key lookup,
  assignment, or deletion.
* Extend the mysql `ReconnectMixin` helper to work with mysql-connector.
* Fix mapping of double-precision float in postgres schema reflection.
  Previously it mapped to single-precision, now it correctly uses a double.
* Fix issue where `PostgresqlExtDatabase` and `MySQLConnectorDatabase` did not
  respect the `autoconnect` setting.

Revision 1.59: download - view: text, markup, annotated - select for diffs
Mon Aug 5 07:56:42 2019 UTC (5 years, 4 months ago) by adam
Branches: MAIN
CVS tags: pkgsrc-2019Q3-base, pkgsrc-2019Q3
Diff to: previous 1.58: preferred, colored
Changes since revision 1.58: +2 -2 lines
py-peewee: updated to 3.10.0

3.10.0

Add a helper to playhouse.mysql_ext for creating Match full-text search expressions.
Added date-part properties to TimestampField for accessing the year, month, day, etc., within a SQL expression.
Added to_timestamp() helper for DateField and DateTimeField that produces an expression returning a unix timestamp.
Add autoconnect parameter to Database classes. This parameter defaults to True and is compatible with previous versions of Peewee, in which executing a query on a closed database would open a connection automatically. To make it easier to catch inconsistent use of the database connection, this behavior can now be disabled by specifying autoconnect=False, making an explicit call to Database.connect() needed before executing a query.
Added database-agnostic interface for obtaining a random value.
Allow isolation_level to be specified when initializing a Postgres db.
Allow hybrid properties to be used on model aliases.
Support aggregates with FILTER predicates on the latest Sqlite.

Changes
-------
More aggressively slot row values into the appropriate field when building objects from the database cursor (rather than using whatever cursor.description tells us, which is buggy in older Sqlite).
Be more permissive in what we accept in the insert_many() and insert() methods.
When implicitly joining a model with multiple foreign-keys, choose the foreign-key whose name matches that of the related model. Previously, this would have raised a ValueError stating that multiple FKs existed.
Improved date truncation logic for Sqlite and MySQL to make more compatible with Postgres' date_trunc() behavior. Previously, truncating a datetime to month resolution would return '2019-08' for example. As of 3.10.0, the Sqlite and MySQL date_trunc implementation returns a full datetime, e.g. '2019-08-01 00:00:00'.
Apply slightly different logic for casting JSON values with Postgres. Previously, Peewee just wrapped the value in the psycopg2 Json() helper. In this version, Peewee now dumps the json to a string and applies an explicit cast to the underlying JSON data-type (e.g. json or jsonb).

Bug fixes
---------
Save hooks can now be called for models without a primary key.
Fixed bug in the conversion of Python values to JSON when using Postgres.
Fix for differentiating empty values from NULL values in model_to_dict.
Fixed a bug referencing primary-key values that required some kind of conversion (e.g., a UUID).
Add small jitter to the pool connection timestamp to avoid issues when multiple connections are checked-out at the same exact time.

Revision 1.58: download - view: text, markup, annotated - select for diffs
Mon Jun 10 07:36:14 2019 UTC (5 years, 6 months ago) by adam
Branches: MAIN
CVS tags: pkgsrc-2019Q2-base, pkgsrc-2019Q2
Diff to: previous 1.57: preferred, colored
Changes since revision 1.57: +2 -2 lines
py-peewee: updated to 3.9.6

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.

Revision 1.57: download - view: text, markup, annotated - select for diffs
Sat Apr 27 09:33:07 2019 UTC (5 years, 7 months ago) by adam
Branches: MAIN
Diff to: previous 1.56: preferred, colored
Changes since revision 1.56: +2 -3 lines
py-peewee: updated to 3.9.5

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.

Revision 1.56: download - view: text, markup, annotated - select for diffs
Mon Apr 15 07:03:50 2019 UTC (5 years, 7 months ago) by adam
Branches: MAIN
Diff to: previous 1.55: preferred, colored
Changes since revision 1.55: +2 -3 lines
py-peewee: updated to 3.9.4

3.9.4:

* Add Model.bulk_update() method for bulk-updating fields across multiple
  model instances.
* 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. Instead, if the related model instance is
  not available, the underlying FK column value is returned (behaving like the
  "_id" descriptor).
* 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. To disable this,
  you can set snake_case=False when calling the Introspector.introspect()
  method or use the -L (legacy naming) option with the pwiz script.
* 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. This allows you to reference some of the special features of the
  database object without directly needing to initialize the proxy first.
* 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.

Revision 1.55: download - view: text, markup, annotated - select for diffs
Wed Apr 3 00:32:31 2019 UTC (5 years, 8 months ago) by ryoon
Branches: MAIN
Diff to: previous 1.54: preferred, colored
Changes since revision 1.54: +2 -1 lines
Recursive revbump from textproc/icu

Revision 1.54: download - view: text, markup, annotated - select for diffs
Sun Mar 24 10:39:47 2019 UTC (5 years, 8 months ago) by adam
Branches: MAIN
CVS tags: pkgsrc-2019Q1-base, pkgsrc-2019Q1
Diff to: previous 1.53: preferred, colored
Changes since revision 1.53: +2 -2 lines
py-peewee: updated to 3.9.3

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. Peewee
  will now generate an equivalent CASE statement for Sqlite and MySQL.
* Added [EXCLUDED](http://docs.peewee-orm.com/en/latest/peewee/api.html#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](http://docs.peewee-orm.com/en/latest/peewee/interactive.html).
* Fix cache invalidation bug in DataSet that was originally reported on the
  sqlite-web project.
* New example script implementing a [hexastore]

Revision 1.53: download - view: text, markup, annotated - select for diffs
Wed Mar 6 18:36:13 2019 UTC (5 years, 9 months ago) by adam
Branches: MAIN
Diff to: previous 1.52: preferred, colored
Changes since revision 1.52: +2 -2 lines
py-peewee: updated to 3.9.2

3.9.2:
This release contains a fix for a test that was failing when 3.9.1 was tagged and released.

3.9.1:
Includes a bugfix for an AttributeError that occurs when using MySQL with the MySQLdb client.

Revision 1.52: download - view: text, markup, annotated - select for diffs
Wed Mar 6 08:37:57 2019 UTC (5 years, 9 months ago) by adam
Branches: MAIN
Diff to: previous 1.51: preferred, colored
Changes since revision 1.51: +2 -2 lines
py-peewee: updated to 3.9.0

3.9.0:
New and improved stuff
Added new document describing how to use peewee interactively.
Added convenience functions for generating model classes from a pre-existing database, printing model definitions and printing CREATE TABLE sql for a model. See the "use peewee interactively" section for details.
Added a __str__ implementation to all Query subclasses which converts the query to a string and interpolates the parameters.
Improvements to sqlite_ext.JSONField regarding the serialization of data, as well as the addition of options to override the JSON serialization and de-serialization functions.
Added index_type parameter to Field
Added DatabaseProxy, which allows one to use database-specific decorators with an uninitialized Proxy object.
Added support for INSERT ... ON CONFLICT when the conflict target is a partial index (e.g., contains a WHERE clause). The OnConflict and on_conflict() APIs now take an additional conflict_where parameter to represent the WHERE clause of the partial index in question.
Enhanced the playhouse.kv extension to use efficient upsert for all database engines. Previously upsert was only supported for sqlite and mysql.
Re-added the orwhere() query filtering method, which will append the given expressions using OR instead of AND.
Added some new examples to the examples/ directory
Added select_from() API for wrapping a query and selecting one or more columns from the wrapped subquery. Docs.
Added documentation on using row values.
Removed the (defunct) "speedups" C extension, which as of 3.8.2 only contained a barely-faster function for quoting entities.

Bugfixes
Fix bug in SQL generation when there was a subquery that used a common table expressions.
Enhanced prefetch() and fixed bug that could occur when mixing self-referential foreign-keys and model aliases.
MariaDB 10.3.3 introduces backwards-incompatible changes to the SQL used for upsert. Peewee now introspects the MySQL server version at connection time to ensure proper handling of version-specific features.
Fixed bug where TimestampField would treat zero values as None when reading from the database.

Revision 1.51: download - view: text, markup, annotated - select for diffs
Fri Jan 18 08:04:45 2019 UTC (5 years, 10 months ago) by adam
Branches: MAIN
Diff to: previous 1.50: preferred, colored
Changes since revision 1.50: +2 -2 lines
py-peewee: updated to 3.8.2

3.8.2

Backwards-incompatible changes
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. To revert back to the old behavior, just append a call to .tuples() to your INSERT ... RETURNING query.
Removing support for the table_alias model Meta option. Previously, this attribute could be used to specify a "vanity" alias for a model class in the generated SQL. As a result of some changes to support more robust UPDATE and DELETE queries, supporting this feature will require some re-working. As of the 3.8.0 release, it was broken and resulted in incorrect SQL for UPDATE queries, so now it is removed.

New features
Added playhouse.shortcuts.ReconnectMixin, which can be used to implement automatic reconnect under certain error conditions (notably the MySQL error 2006 - server has gone away).

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

Revision 1.50: download - view: text, markup, annotated - select for diffs
Tue Jan 8 08:37:59 2019 UTC (5 years, 11 months ago) by adam
Branches: MAIN
Diff to: previous 1.49: preferred, colored
Changes since revision 1.49: +4 -3 lines
py-peewee: updated to 3.8.1

3.8.1

New features
Sqlite SearchField now supports the match() operator, allowing full-text search to be performed on a single column (as opposed to the whole table).

Changes
Remove minimum passphrase restrictions in SQLCipher integration.

Bugfixes
Support inheritance of ManyToManyField instances.
Ensure operator overloads are invoked when generating filter expressions.
Fix incorrect scoring in Sqlite BM25, BM25f and Lucene ranking algorithms.
Support string field-names in data dictionary when performing an ON CONFLICT ... UPDATE query, which allows field-specific conversions to be applied.

Revision 1.49: download - view: text, markup, annotated - select for diffs
Tue Dec 18 11:48:33 2018 UTC (5 years, 11 months ago) by adam
Branches: MAIN
CVS tags: pkgsrc-2018Q4-base, pkgsrc-2018Q4
Diff to: previous 1.48: preferred, colored
Changes since revision 1.48: +4 -9 lines
py-peewee: updated to 3.8.0

3.8.0

**New features**

* Postgres BinaryJSONField now supports has_key(), concat() and
  remove() methods (though remove may require pg10+).
* Add python_value() method to the SQL-function helper fn, to allow
  specifying a custom function for mapping database values to Python values.

**Changes**

* Better support for UPDATE ... FROM queries, and more generally, more robust
  support for UPDATE and RETURNING clauses. This means that the
  QualifiedNames helper is no longer needed for certain types of queries.
* The SqlCipherDatabase no longer accepts a kdf_iter parameter. To
  configure the various SQLCipher encryption settings, specify the setting
  values as pragmas when initializing the database.
* Introspection will now, by default, only strip "_id" from introspected column
  names if those columns are foreign-keys.
* Allow UUIDField and BinaryUUIDField to accept hexadecimal UUID strings as
  well as raw binary UUID bytestrings (in addition to UUID instances, which
  are already supported).
* Allow ForeignKeyField to be created without an index.
* Allow multiple calls to cast() to be chained.
* Add logic to ensure foreign-key constraint names that exceed 64 characters
  are truncated using the same logic as is currently in place for long indexes.
* ManyToManyField supports foreign-keys to fields other than primary-keys.
* When linked against SQLite 3.26 or newer, support SQLITE_CONSTRAINT to
  designate invalid queries against virtual tables.
* SQL-generation changes to aid in supporting using queries within expressions
  following the SELECT statement.

**Bugfixes**

* Fixed bug in order_by_extend(), thanks @nhatHero.
* Fixed bug where the DataSet CSV import/export did not support non-ASCII
  characters in Python 3.x.
* Fixed bug where model_to_dict would attempt to traverse explicitly disabled
  foreign-key backrefs.
* Fixed bug when attempting to migrate SQLite tables that have a field whose
  column-name begins with "primary_".
* Fixed bug with inheriting deferred foreign-keys.

Revision 1.48: download - view: text, markup, annotated - select for diffs
Sat Dec 15 21:12:20 2018 UTC (5 years, 11 months ago) by wiz
Branches: MAIN
Diff to: previous 1.47: preferred, colored
Changes since revision 1.47: +2 -2 lines
*: update email for fhajny

Revision 1.47: download - view: text, markup, annotated - select for diffs
Sun Dec 9 18:52:20 2018 UTC (6 years ago) by adam
Branches: MAIN
Diff to: previous 1.46: preferred, colored
Changes since revision 1.46: +2 -1 lines
revbump after updating textproc/icu

Revision 1.46: download - view: text, markup, annotated - select for diffs
Fri Oct 26 11:57:01 2018 UTC (6 years, 1 month ago) by jperkin
Branches: MAIN
Diff to: previous 1.45: preferred, colored
Changes since revision 1.45: +6 -1 lines
py-peewee: Find libsqlite3 correctly.

Revision 1.45: download - view: text, markup, annotated - select for diffs
Sun Oct 7 08:42:24 2018 UTC (6 years, 2 months ago) by adam
Branches: MAIN
Diff to: previous 1.44: preferred, colored
Changes since revision 1.44: +2 -2 lines
py-peewee: updated to 3.7.1

3.7.1:

New features
* 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.

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

Revision 1.44: download - view: text, markup, annotated - select for diffs
Fri Sep 7 09:01:09 2018 UTC (6 years, 3 months ago) by adam
Branches: MAIN
CVS tags: pkgsrc-2018Q3-base, pkgsrc-2018Q3
Diff to: previous 1.43: preferred, colored
Changes since revision 1.43: +4 -5 lines
py-peewee: updated to 3.7.0

3.7.0:

Backwards-incompatible changes
* Pool database close_all() method renamed to close_idle() to better
  reflect the actual behavior.
* Databases will now raise InterfaceError when connect() or close() are
  called on an uninitialized, deferred database object.

New features
* Add methods to the migrations extension to support adding and dropping table
  constraints.
* Add Model.bulk_create() method for bulk-inserting unsaved model instances.
* Add close_stale() method to the connection pool to support closing stale
  connections.
* The FlaskDB class in playhouse.flask_utils now accepts a model_class
  parameter, which can be used to specify a custom base-class for models.

Bugfixes
* Parentheses were not added to subqueries used in function calls with more
  than one argument.
* Fixed bug when attempting to serialize many-to-many fields which were created
  initially with a DeferredThroughModel.
* Fixed bug when using the Postgres ArrayField with an array of BlobField.
* Allow Proxy databases to be used as a context-manager.
* Fixed bug where the APSW driver was referring to the SQLite version from the
  standard library sqlite3 driver, rather than from apsw.
* Reflection library attempts to wrap server-side column defaults in quotation
  marks if the column data-type is text/varchar.
* Missing import in migrations library, which would cause errors when
  attempting to add indexes whose name exceeded 64 chars.
* When using the Postgres connection pool, ensure any open/pending transactions
  are rolled-back when the connection is recycled.
* Even *more* changes to the setup.py script. In this case I've added a
  helper function which will reliably determine if the SQLite3 extensions can
  be built. This follows the approach taken by the Python YAML package.

Revision 1.43: download - view: text, markup, annotated - select for diffs
Fri Jul 20 09:38:49 2018 UTC (6 years, 4 months ago) by adam
Branches: MAIN
Diff to: previous 1.42: preferred, colored
Changes since revision 1.42: +7 -6 lines
py-peewee: updated to 3.6.4

3.6.4:
Take a whole new approach, following what simplejson does. Allow the
build_ext command class to fail, and retry without extensions in the event we
run into issues building extensions.

3.6.3:
Add check in setup.py to determine if a C compiler is available before
building C extensions.

3.6.2:
Use ctypes.util.find_library to determine if libsqlite3 is installed.
Should fix problems people are encountering installing when SQLite3 is not
available.

3.6.1:
Fixed issue with setup script.

3.6.0:
* Support for Python 3.7, including bugfixes related to new StopIteration
  handling inside of generators.
* Support for specifying ROWS or RANGE window frame types.
* Add APIs for user-defined window functions if using [pysqlite3](https://github.com/coleifer/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.
* Switch to using setuptools for packaging.

Revision 1.42: download - view: text, markup, annotated - select for diffs
Fri Jul 20 03:34:06 2018 UTC (6 years, 4 months ago) by ryoon
Branches: MAIN
Diff to: previous 1.41: preferred, colored
Changes since revision 1.41: +2 -1 lines
Recursive revbump from textproc/icu-62.1

Revision 1.41: download - view: text, markup, annotated - select for diffs
Wed Jul 4 03:56:46 2018 UTC (6 years, 5 months ago) by adam
Branches: MAIN
Diff to: previous 1.40: preferred, colored
Changes since revision 1.40: +4 -9 lines
py-peewee: updated to 3.5.2

3.5.2:

New guide to using window functions in Peewee.
New and improved table name auto-generation. This feature is not backwards compatible, so it is disabled by default. To enable, set legacy_table_names=False in your model's Meta options. For more details, see table names documentation.
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. It can be used anywhere AutoField or BigAutoField was being used previously.
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.


3.5.1:

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

Bug fixes
---------
Fixed edge-case where attempting to alias a field to it's underlying column-name (when different), Peewee would not respect the alias and use the field name instead.
Raise a ValueError when joining and aliasing the join to a foreign-key's object_id_name descriptor. Should prevent accidentally introducing O(n) queries or silently ignoring data from a joined-instance.
Fixed bug for MySQL when creating a foreign-key to a model which used the BigAutoField for it's primary-key.
Fixed bugs in the implementation of user-defined aggregates and extensions with the APSW SQLite driver.
Fixed regression introduced in 3.5.0 which ignored custom Model __repr__().
Fixed regression from 2.x in which inserting from a query using a SQL() was no longer working.

Revision 1.40: download - view: text, markup, annotated - select for diffs
Mon Jun 4 10:20:01 2018 UTC (6 years, 6 months ago) by fhajny
Branches: MAIN
CVS tags: pkgsrc-2018Q2-base, pkgsrc-2018Q2
Diff to: previous 1.39: preferred, colored
Changes since revision 1.39: +2 -2 lines
databases/py-peewee: Update to 3.5.0.

Backwards-incompatible changes
- Custom Model repr no longer use the convention of overriding
  __unicode__, and now use __str__.
- Redesigned the sqlite json1 integration and changed some of the APIs
  and semantics of various JSONField methods.

New features
- Better default repr for model classes and fields.
- ForeignKeyField() accepts a new initialization parameter,
  deferrable, for specifying when constraints should be enforced.
- BitField.flag() can be called without a value parameter for the
  common use-case of using flags that are powers-of-2.
- SqliteDatabase pragmas can be specified as a dict (previously
  required a list of 2-tuples).
- SQLite TableFunction (docs) will print Python exception tracebacks
  raised in the initialize and iterate callbacks, making debugging
  significantly easier.

Bug fixes
- Fixed bug in migrator.add_column() where, if the field being added
  declared a non-standard index type (e.g., binary json field with GIN
  index), this index type was not being respected.
- Fixed bug in database.table_exists() where the implementation did
  not match the documentation.
- Fixed bug in SQLite TableFunction implementation which raised errors
  if the return value of the iterate() method was not a tuple.

Revision 1.39: download - view: text, markup, annotated - select for diffs
Mon May 21 13:18:16 2018 UTC (6 years, 6 months ago) by fhajny
Branches: MAIN
Diff to: previous 1.38: preferred, colored
Changes since revision 1.38: +2 -2 lines
databases/py-peewee: Update to 3.4.0.

Backwards-incompatible changes

- The regexp() operation is now case-sensitive for MySQL and Postgres.
  To perform case-insensitive regexp operations, use iregexp().
- The SQLite BareField() field-type now supports all column
  constraints except specifying the data-type. Previously it silently
  ignored any column constraints.
- LIMIT and OFFSET parameters are now treated as parameterized values
  instead of literals.
- The schema parameter for SQLite database introspection methods is no
  longer ignored by default. The schema corresponds to the name given
  to an attached database.
- ArrayField now accepts a new parameter field_kwargs, which is used
  to pass information to the array field's field_class initializer.

New features and other changes

- SQLite backup interface supports specifying page-counts and a
  user-defined progress handler.
- GIL is released when doing backups or during SQLite busy timeouts
  (when using the peewee SQLite busy-handler).
- Add NATURAL join-type to the JOIN helper.
- Improved identifier quoting to allow specifying distinct
  open/close-quote characters. Enables adding support for MSSQL, for
  instance, which uses square brackets, e.g. [table].[column].
- Unify timeout interfaces for SQLite databases (use seconds
  everywhere rather than mixing seconds and milliseconds, which was
  confusing).
- Added attach() and detach() methods to SQLite database, making it
  possible to attach additional databases (e.g. an in-memory cache
  db).

Revision 1.38: download - view: text, markup, annotated - select for diffs
Mon May 14 10:54:19 2018 UTC (6 years, 7 months ago) by fhajny
Branches: MAIN
Diff to: previous 1.37: preferred, colored
Changes since revision 1.37: +2 -2 lines
databases/py-peewee: Update to 3.3.4.

3.3.4
- Added a BinaryUUIDField class for efficiently storing UUIDs in
  16-bytes.
- Fix dataset's update_cache() logic so that when updating a single
  table that was newly-added, we also ensure that all dependent tables
  are updated at the same time.

3.3.3
- More efficient implementation of model dependency-graph generation.
  Improves performance of recursively deleting related objects by
  omitting unnecessary subqueries.
- Added union(), union_all(), intersect() and except_() to the
  Model-specific query implementations. This was an oversight that
  should have been patched in 3.3.2, but is fixed in 3.3.3.
- Major cleanup to test runner and standardized test skipping logic to
  integrate with standard-library unittest conventions.

3.3.2
- Add methods for union(), union_all, intersect() and except_().
  Previously, these methods were only available as operator overloads.
- Removed some Python 2.6-specific support code, as 2.6 is no longer
  officially supported.
- Fixed model-graph resolution logic for deferred foreign-keys.
- Better support for UPDATE...FROM queries (Postgresql).

Revision 1.37: download - view: text, markup, annotated - select for diffs
Fri Apr 27 13:52:59 2018 UTC (6 years, 7 months ago) by fhajny
Branches: MAIN
Diff to: previous 1.36: preferred, colored
Changes since revision 1.36: +2 -2 lines
databases/py-peewee: Update to 3.3.1.

- Fixed long-standing bug in 3.x regarding using column aliases with
  queries that utilize the ModelCursorWrapper (typically queries with
  one or more joins).
- Fix typo in model metadata code, thanks @klen.
- Add examples of using recursive CTEs to docs.

Revision 1.36: download - view: text, markup, annotated - select for diffs
Wed Apr 25 12:12:43 2018 UTC (6 years, 7 months ago) by fhajny
Branches: MAIN
Diff to: previous 1.35: preferred, colored
Changes since revision 1.35: +4 -7 lines
databases/py-peewee: Update to 3.3.0. Clean up.

- Added support for SQLite's new ON CONFLICT clause, which is modelled
  on the syntax used by Postgresql and will be available in SQLite
  3.24.0 and onward.
- Added better support for using common table expressions and a
  cleaner way of implementing recursive CTEs, both of which are also
  tested with integration tests (as opposed to just checking the
  generated SQL).
- Modernized the CI environment to utilize the latest MariaDB
  features, so we can test window functions and CTEs with MySQL (when
  available).
- Reorganized and unified the feature-flags in the test suite.

Revision 1.35: download - view: text, markup, annotated - select for diffs
Mon Apr 23 15:28:54 2018 UTC (6 years, 7 months ago) by fhajny
Branches: MAIN
Diff to: previous 1.34: preferred, colored
Changes since revision 1.34: +2 -2 lines
databases/py-peewee: Update to 3.2.5.

- Added ValuesList for representing values lists.
- DateTimeField, DateField and TimeField will parse formatted-string
  before sending to the database. Previously this only occurred when
  reading values from the database.

Revision 1.34: download - view: text, markup, annotated - select for diffs
Thu Apr 19 08:20:10 2018 UTC (6 years, 7 months ago) by fhajny
Branches: MAIN
Diff to: previous 1.33: preferred, colored
Changes since revision 1.33: +2 -2 lines
databases/py-peewee: Update to 3.2.4.

- Smarter handling of model-graph when dealing with compound queries
  (union, intersect, etc).
- If the same column-name is selected multiple times, first value
  wins.
- If ModelSelect.switch() is called without any arguments, default to
  the query's model.
- Fix issue where cloning a ModelSelect query did not result in the
  joins being cloned.

Revision 1.33: download - view: text, markup, annotated - select for diffs
Mon Apr 16 12:21:36 2018 UTC (6 years, 7 months ago) by fhajny
Branches: MAIN
Diff to: previous 1.32: preferred, colored
Changes since revision 1.32: +2 -3 lines
databases/py-peewee: Update to 3.2.3.

- pwiz tool will capture column defaults defined as part of the
  table schema.
- Fixed a misleading error message.
- Ensure reuse_if_open parameter has effect on pooled databases.
- Added support for on update/delete when migrating foreign-key.
- Fixed bug in SQL generation for subqueries in aliased functions.

Revision 1.32: download - view: text, markup, annotated - select for diffs
Sat Apr 14 07:34:14 2018 UTC (6 years, 7 months ago) by adam
Branches: MAIN
Diff to: previous 1.31: preferred, colored
Changes since revision 1.31: +2 -2 lines
revbump after icu update

Revision 1.31: download - view: text, markup, annotated - select for diffs
Fri Apr 13 08:07:34 2018 UTC (6 years, 8 months ago) by fhajny
Branches: MAIN
Diff to: previous 1.30: preferred, colored
Changes since revision 1.30: +3 -1 lines
databases/py-peewee: Requires sqlite3 lib actually. PKGREVISION++

Revision 1.30: download - view: text, markup, annotated - select for diffs
Wed Apr 4 12:31:19 2018 UTC (6 years, 8 months ago) by fhajny
Branches: MAIN
Diff to: previous 1.29: preferred, colored
Changes since revision 1.29: +3 -2 lines
databases/py-peewee: Update to 3.2.2.

3.2.2
- Added support for passing Model classes to the returning() method
  when you intend to return all columns for the given model.
- Fixed a bug when using user-defined sequences, and the underlying
  sequence already exists.
- Added drop_sequences parameter to drop_table() method which allows
  you to conditionally drop any user-defined sequences when dropping
  the table.

3.2.1
- If both mysql-python and pymysql libraries are installed, Peewee
  will use pymysql by default.
- Added new module playhouse.mysql_ext which includes
  MySQLConnectorDatabase, a database implementation that works with
  the mysql-connector driver.
- Added new field to ColumnMetadata class which captures a database
  column's default value. ColumnMetadata is returned by
  Database.get_columns().
- Added documentation on making Peewee async.

3.2.0
- Potentially backwards-incompatible change: Field.coerce renamed to
  Field.adapt.

3.1.6
- Added rekey() method to SqlCipher database for changing encryption
  key and documentation for set_passphrase() method.
- Added convert_values parameter to ArrayField constructor, which will
  cause the array values to be processed using the underlying
  data-type's conversion logic.
- Fixed unreported bug using TimestampField with sub-second
  resolutions.
- Fixed bug where options were not being processed when calling
  drop_table().
- Some fixes and improvements to signals extension.

Revision 1.29: download - view: text, markup, annotated - select for diffs
Fri Mar 16 12:06:03 2018 UTC (6 years, 8 months ago) by fhajny
Branches: MAIN
CVS tags: pkgsrc-2018Q1-base, pkgsrc-2018Q1
Diff to: previous 1.28: preferred, colored
Changes since revision 1.28: +2 -2 lines
databases/py-peewee: Update to 3.1.5.

## 3.1.5

- Fixed Python 2/3 incompatibility with `itertools.izip_longest()`.

## 3.1.4

- Added `BigAutoField` to support 64-bit auto-incrementing primary
  keys.
- Use Peewee-compatible datetime serialization when exporting JSON
  from a `DataSet`. Previously the JSON export used ISO-8601 by default.
- Added `Database.batch_commit` helper to wrap iterators in chunked
  transactions.

## 3.1.3

- Fixed issue where scope-specific settings were being updated
  in-place instead of copied.
- Fixed bug where setting a `ForeignKeyField` did not add it to the
  model's "dirty" fields list.
- Use pre-fetched data when using `prefetch()` with `ManyToManyField`.
- Use `JSON` data-type for SQLite `JSONField` instances.
- Add a `json_contains` function for use with SQLite `json1`  extension.
- Various documentation updates and additions.

Revision 1.28: download - view: text, markup, annotated - select for diffs
Tue Mar 13 10:16:37 2018 UTC (6 years, 9 months ago) by fhajny
Branches: MAIN
Diff to: previous 1.27: preferred, colored
Changes since revision 1.27: +2 -2 lines
databases/py-peewee: Update to 3.1.3.

- Fixed issue where scope-specific settings were being updated
  in-place instead of copied.
- Fixed bug where setting a ForeignKeyField did not add it to
  the model's "dirty" fields list.
- Use pre-fetched data when using prefetch() with ManyToManyField.
- Use JSON data-type for SQLite JSONField instances.
- Add a json_contains function for use with SQLite json1 extension.
- Various documentation updates and additions.

Revision 1.27: download - view: text, markup, annotated - select for diffs
Thu Mar 1 11:52:59 2018 UTC (6 years, 9 months ago) by fhajny
Branches: MAIN
Diff to: previous 1.26: preferred, colored
Changes since revision 1.26: +2 -2 lines
databases/py-peewee: Update to 3.1.1.

- Fixed bug when using Model.alias() when the model defined a
  particular database schema.
- Added SchemaManager.create_foreign_key API to simplify adding
  constraints when dealing with circular foreign-key relationships.
- Improved implementation of Migrator.add_foreign_key_constraint so
  that it can be used with Postgresql (in addition to MySQL).
- Added PickleField to the playhouse.fields module. Docs.
- Fixed bug in implementation of CompressedField when using Python 3.
- Added KeyValue API in playhouse.kv module. Docs.
- More test cases for joining on sub-selects or common table
  expressions.

Revision 1.26: download - view: text, markup, annotated - select for diffs
Tue Feb 27 10:49:49 2018 UTC (6 years, 9 months ago) by fhajny
Branches: MAIN
Diff to: previous 1.25: preferred, colored
Changes since revision 1.25: +2 -2 lines
Update databases/py-peewee to 3.1.0.

Backwards-incompatible changes
- 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:

Other changes
- Removed Python 2.6 support code from a few places.
- Fixed example analytics app code to ensure hstore extension is registered.
- Small efficiency improvement to bloom filter.
- Removed "attention!" from README.

Revision 1.25: download - view: text, markup, annotated - select for diffs
Fri Feb 23 11:39:51 2018 UTC (6 years, 9 months ago) by fhajny
Branches: MAIN
Diff to: previous 1.24: preferred, colored
Changes since revision 1.24: +2 -2 lines
databases/py-peewee: Update to 3.0.20.

3.0.20
- Include schema (if specified) when checking for table-existence.
- Correct placement of ORDER BY / LIMIT clauses in compound select
  queries.
- Fix bug in back-reference lookups when using filter() API.
- Fix bug in SQL generation for ON CONFLICT queries with Postgres

3.0.19
- Support for more types of mappings in insert_many()
- Lots of documentation improvements.
- Fix bug when calling tuples() on a ModelRaw query. This was reported
  originally as a bug with sqlite-web CSV export

Revision 1.24: download - view: text, markup, annotated - select for diffs
Mon Feb 19 13:08:52 2018 UTC (6 years, 9 months ago) by fhajny
Branches: MAIN
Diff to: previous 1.23: preferred, colored
Changes since revision 1.23: +2 -2 lines
databases/py-peewee: Update to 3.0.18.

- Improved error messages when attempting to use a database class
  for which the corresponding driver is not installed.
- Added tests showing the use of custom operator (a-la the docs).
- Fixed indentation issue in docs
- Fixed issue with the SQLite date_part issue

Revision 1.23: download - view: text, markup, annotated - select for diffs
Tue Feb 13 15:26:10 2018 UTC (6 years, 9 months ago) by fhajny
Branches: MAIN
Diff to: previous 1.22: preferred, colored
Changes since revision 1.22: +2 -3 lines
databases/py-peewee: Update to 3.0.17.

3.0.17
- Fix schema inheritance regression
- Add helper method to postgres migrator for setting search_path

3.0.16
- Improve model graph resolution when iterating results of a query
- Allow Model._meta.schema to be changed at run-time

Revision 1.22: download - view: text, markup, annotated - select for diffs
Thu Feb 8 12:56:10 2018 UTC (6 years, 10 months ago) by fhajny
Branches: MAIN
Diff to: previous 1.21: preferred, colored
Changes since revision 1.21: +2 -2 lines
databases/py-peewee: Update to 1.0.5.

1.0.5
- Use same schema used for reflection in generated models.
- Preserve pragmas set on deferred Sqlite database if database is
  re-initialized without re-specifying pragmas.

1.0.4
- Fix bug creating model instances on Postgres when model does not
  have a primary key column.
- Extend postgresql reflection to support array types.

Revision 1.21: download - view: text, markup, annotated - select for diffs
Wed Feb 7 16:12:08 2018 UTC (6 years, 10 months ago) by fhajny
Branches: MAIN
Diff to: previous 1.20: preferred, colored
Changes since revision 1.20: +2 -2 lines
Update databases/py-peewee to 3.0.13

3.0.13
- Fix bug where simple field aliases were being ignored.
- More strict about column type inference for postgres + pwiz.

3.0.12
- Fix queries of the form INSERT ... VALUES (SELECT...) so that
  sub-select is wrapped in parentheses.
- Improve model-graph resolution when selecting from multiple tables
  that are joined by foreign-keys, and an intermediate table is
  omitted from selection.
- Docs update to reflect deletion of post_init signal.

3.0.11
- Add note to changelog about cursor() method.
- Add hash method to postgres indexedfield subclasses.
- Add TableFunction to sqlite_ext module namespace.
- Fix bug regarding NOT IN queries where the right-hand-side is an
  empty set.
- Fallback implementations of bm25f and lucene search ranking
  algorithms.
- Fixed DecimalField issue.
- Fixed issue with BlobField when database is a Proxy object.

Revision 1.20: download - view: text, markup, annotated - select for diffs
Sun Feb 4 17:07:18 2018 UTC (6 years, 10 months ago) by fhajny
Branches: MAIN
Diff to: previous 1.19: preferred, colored
Changes since revision 1.19: +2 -2 lines
databases/py-peewee: Update to 3.0.10.

- Fix Database.drop_tables() signature to support cascade argument
- Fix querying documentation for custom functions
- Added len() method to ModelBase for convenient counting.
- Fix bug related to unsaved relation population (thanks @conqp)
- Fix count() on compound select
- Support coerce keyword argument with fn.XXX()
- Support updating existing model instance with dict_to_model-like API
- Fix equality tests with ArrayField

Revision 1.19: download - view: text, markup, annotated - select for diffs
Fri Feb 2 16:00:33 2018 UTC (6 years, 10 months ago) by fhajny
Branches: MAIN
Diff to: previous 1.18: preferred, colored
Changes since revision 1.18: +5 -4 lines
databases/py-peewee: Update to 3.0.9.

3.0.9
- Add deprecation notice if passing autocommit as keyword argument to
  the Database initializer.
- Add JSONPath and "J" helpers to sqlite extension.

3.0.8
- Add support for passing cascade=True when dropping tables.
- Fix issues with backrefs and inherited foreign-keys.

3.0.7
- Add select_extend() method to extend existing SELECT-ion.
- Accept set() as iterable value type
- Add test for model/field inheritance and fix bug relating to
  recursion error when inheriting foreign-key field.
- Fix regression where consecutive calls to ModelSelect.select() with
  no parameters resulted in an empty selection.

3.0.6
- Add constraints for ON UPDATE/ON DELETE to foreign-key constraint

3.0.5
- Adds Model.index(), a short-hand method for declaring ModelIndex
  instances.

3.0.4
- Re-add a shim for PrimaryKeyField (renamed to AutoField) and log a
  deprecation warning if you try to use it

3.0.3
- Includes fix for bug where column-name to field-name translation was
  not being done when running select queries on models whose field
  name differed from the underlying column name.

3.0.2
- Fixes missing pysqlite header files, which are needed to compile
  certain C extensions.

3.0.0
- Complete rewrite of SQL AST and code-generation.
- Inclusion of new, low-level query builder APIs.
- List of backwards-incompatible changes since 2.x:

  http://docs.peewee-orm.com/en/latest/peewee/changes.html

Revision 1.18: download - view: text, markup, annotated - select for diffs
Fri Oct 13 14:19:05 2017 UTC (7 years, 2 months ago) by fhajny
Branches: MAIN
CVS tags: pkgsrc-2017Q4-base, pkgsrc-2017Q4
Diff to: previous 1.17: preferred, colored
Changes since revision 1.17: +2 -2 lines
Update databases/py-peewee to 2.10.2

2.10.2
- Update travis-ci build scripts to use Postgres 9.6 and test against
  Python 3.6.
- Added support for returning namedtuple objects when iterating over a
  cursor.
- Added support for specifying the "object id" attribute used when
  declaring a foreign key. By default, it is foreign-key-name_id, but
  it can now be customized.
- Fixed small bug in the calculation of search scores when using the
  SQLite C extension or the sqlite_ext module.
- Support literal column names with the dataset module.

2.10.1
- Removed AESEncryptedField.

Revision 1.17: download - view: text, markup, annotated - select for diffs
Wed May 10 18:24:05 2017 UTC (7 years, 7 months ago) by fhajny
Branches: MAIN
CVS tags: pkgsrc-2017Q3-base, pkgsrc-2017Q3, pkgsrc-2017Q2-base, pkgsrc-2017Q2
Diff to: previous 1.16: preferred, colored
Changes since revision 1.16: +2 -2 lines
Update databases/py-peewee to 2.10.0.

- Remove the playhouse.fields.AESEncryptedField over security concerns
  described in ticket #1264.
- Correctly resolve explicit table dependencies when creating tables, refs
- Implement not equals comparison for CompositeKey.

Revision 1.16: download - view: text, markup, annotated - select for diffs
Wed Apr 26 14:10:48 2017 UTC (7 years, 7 months ago) by fhajny
Branches: MAIN
Diff to: previous 1.15: preferred, colored
Changes since revision 1.15: +3 -1 lines
Fix sphinx-build lookup

Revision 1.15: download - view: text, markup, annotated - select for diffs
Fri Apr 21 09:14:01 2017 UTC (7 years, 7 months ago) by fhajny
Branches: MAIN
Diff to: previous 1.14: preferred, colored
Changes since revision 1.14: +18 -2 lines
Update databases/py-peewee to 2.9.2.

## 2.9.2

- Fixed significant bug in the `savepoint` commit/rollback implementation.
- Added support for postgresql `INTERVAL` columns.
- Fixed bug where missing `sqlite3` library was causing other, unrelated
  libraries to throw errors when attempting to import.
- Added a `case_sensitive` parameter to the SQLite `REGEXP` function
  implementation. The default is `False`, to preserve backwards-compatibility.
- Fixed bug that caused tables not to be created when using the `dataset`
  extension.
- Modified `drop_table` to raise an exception if the user attempts to drop
  tables with `CASCADE` when the database backend does not support it.
- Fixed Python3 issue in the `AESEncryptedField`.
- Modified the behavior of string-typed fields to treat the addition operator
  as concatenation


## 2.9.1

- Fixed #1218, where the use of `playhouse.flask_utils` was requiring the
  `sqlite3` module to be installed.
- Fixed #1219 regarding the SQL generation for composite key sub-selects,
  joins, etc.


## 2.9.0

In this release there are two notable changes:

- The ``Model.create_or_get()`` method was removed.
- The SQLite closure table extension gained support for many-to-many
  relationships thanks to a nice PR by @necoro.


## 2.8.8

This release contains a single important bugfix for a regression in specifying
the type of lock to use when opening a SQLite transaction.


## 2.8.7

This release contains numerous cleanups.

### Bugs fixed

- #1087 - Fixed a misuse of the iteration protocol in the `sqliteq` extension.
- #1096 - Fix representation of recursive foreign key relations when using the
  `model_to_dict` helper.
- #1126 - Allow `pskel` to be installed into `bin` directory.
- #1105 - Added a `Tuple()` type to Peewee to enable expressing arbitrary
  tuple expressions in SQL.
- #1133 - Fixed bug in the conversion of objects to `Decimal` instances in the
  `DecimalField`.
- Fixed an issue renaming a unique foreign key in MySQL.
- Remove the join predicate from CROSS JOINs.
- #1148 - Ensure indexes are created when a column is added using a schema
  migration.
- #1165 - Fix bug where the primary key was being overwritten in queries using
  the closure-table extension.

### New stuff

- Added properties to the `SqliteExtDatabase` to expose common `PRAGMA`
  settings.
- Clarified documentation on calling `commit()` or `rollback()` from within the
  scope of an atomic block.
- Allow table creation dependencies to be specified using new `depends_on` meta
  option.
- Allow specification of the lock type used in SQLite transactions.
- Added support for `CROSS JOIN` expressions in select queries.
- Docs on how to implement optimistic locking
- Documented optional dependencies.
- Generic support for specifying select queries as locking the selected rows
  `FOR X`, e.g. `FOR UPDATE` or `FOR SHARE`.
- Support for specifying the frame-of-reference in window queries, e.g.
  specifying `UNBOUNDED PRECEDING`, etc.

### Backwards-incompatible changes

- As of 9e76c99, an `OperationalError` is raised if the user calls `connect()`
  on an already-open Database object. Previously, the existing connection would
  remain open and a new connection would overwrite it, making it impossible to
  close the previous connection. If you find this is causing breakage in your
  application, you can switch the `connect()` call to `get_conn()` which will
  only open a connection if necessary. The error **is** indicative of a real
  issue, though, so audit your code for places where you may be opening a
  connection without closing it (module-scope operations, e.g.).

Revision 1.14: download - view: text, markup, annotated - select for diffs
Wed Oct 26 14:28:16 2016 UTC (8 years, 1 month ago) by fhajny
Branches: MAIN
CVS tags: pkgsrc-2017Q1-base, pkgsrc-2017Q1, pkgsrc-2016Q4-base, pkgsrc-2016Q4
Diff to: previous 1.13: preferred, colored
Changes since revision 1.13: +2 -2 lines
Update databases/py-peewee to 2.8.5.

2.8.5

- Starting docs on sqliteq
- Use parentheses for compound select with MySQL.
- Remove "clean_prefetch_subquery" as I'm not sure why it exists in the
  first place.

2.8.4

- New playhouse extension module for working with SQLite in
  multi-threaded / concurrent environments. The new module is called
  playhouse.sqliteq and it works by serializing queries using a dedicated
  worker thread (or greenlet). The performance is quite good, hopefully
  this proves useful to someone besides myself! You can learn more by
  reading the sqliteq documentation.
- #1061 - @akrs patched a bug in TimestampField which affected the
  accuracy of sub-second timestamps (for resolution > 1).
- #1071, small python 3 fix.
- #1072, allow DeferredRelation to be used multiple times if there are
  multiple references to a given deferred model.
- #1073, fixed regression in the speedups module that caused SQL
  functions to always coerce return values, regardless of the coerce
  flag.
- #1083, another Python 3 issue - this time regarding the use of
  exc.message.

Revision 1.13: download - view: text, markup, annotated - select for diffs
Sat Sep 10 20:58:45 2016 UTC (8 years, 3 months ago) by fhajny
Branches: MAIN
CVS tags: pkgsrc-2016Q3-base, pkgsrc-2016Q3
Diff to: previous 1.12: preferred, colored
Changes since revision 1.12: +2 -2 lines
Update databases/py-peewee to 2.8.3.

Bugs fixed and general changes

- #1028 - allow the ensure_join method to accept on and join_type
  parameters. Thanks @paulbooth.
- #1032 - fix bug related to coercing model instances to database
  parameters when the model's primary key is a foreign key.
- #1035 - fix bug introduced in 2.8.2, where I had added some
  logic to try and restrict the base Model class from being
  treated as a "real" Model.
- #1039 - update documentation to clarify that lists or tuples are
  acceptable values when specifying SQLite PRAGMA statements.
- #1041 - PyPy user was unable to install Peewee. (Who in their
  right mind would ever use PyPy?!) Bug was fixed by removing the
  pre-generated C files from the distribution.
- #1043 - fix bug where the speedups C extension was not calling
  the correct model initialization method, resulting in model
  instances returned as results of a query having their dirty flag
  incorrectly set.
- #1048 - similar to #1043, add logic to ensure that fields with
  default values are considered dirty when instantiating the
  model.
- #1049 - update URL to APSW.
- Fixed unreported bug regarding TimestampField with zero values
  reporting the incorrect datetime.

New stuff

- djpeewee extension module now works with Django 1.9.
- TimestampField is now an officially documented field.
- #1050 - use the db_column of a ForeignKeyField for the name of
  the ObjectIdDescriptor, except when the db_column and field name
  are the same, in which case the ID descriptor will be named
  <field_name>_id.

Revision 1.12: download - view: text, markup, annotated - select for diffs
Tue Aug 9 12:10:31 2016 UTC (8 years, 4 months ago) by fhajny
Branches: MAIN
Diff to: previous 1.11: preferred, colored
Changes since revision 1.11: +2 -2 lines
Update databases/py-peewee to 2.8.2.

Bugs fixed and general cleanups
- fixed some bugs related to the Cython extension build process.
- allow blanks and perform type conversion when using the db_url
  extension
- added the ability to query using the <foreign_key>_id attribute.
- ensure that peewee.OperationalError is raised consistently when
  using the RetryOperationalError mixin.
- ensure that pwiz will import the appropriate extensions when
  vendor-specific fields are used.
- ensure that pwiz-generated models containing UnknownField
  placeholders do not blow up when you instantiate them.
- correctly limit the length of automatically-generated index
  names.
- fixed bug where BlobField could not be used if it's parent model
  pointed to an uninitialized database Proxy.
- greater consistency with the conversion to Python data-types
  when performing aggregations, annotations, or calling scalar().
- ensure the correct data-types are used when initializing a
  connection pool.
- fix bug where Signal subclasses were not returning rows affected
  on save.
- added documentation about SQLite limits and how they affect
  insert_many.
- better warnings regarding C extension compilation, thanks
  @dhaase-de.
- fix bug where table names starting with numbers generated
  invalid table names when using pwiz.
- fix bug where parameter was not being used. Thanks @jberkel.
- fixed the way SqliteExtDatabase handles the automatic rowid (and
  docid) columns. Thanks for alerting me to the issue and
  providing a failing test case @jberkel.
- fix obscure bug relating to cloning foreign key fields twice.
- allow set instances to be used on the right-hand side of IN
  exprs.
- fix behavior where the default id primary key was inherited
  regardless. When users would inadvertently include it in their
  queries, it would use the table alias of it's parent class.
- add support for db_column in djpeewee
- fix the behavior of truncate_date with Postgresql. Thanks
  @Zverik.
- allow DATABASE_URL as a recognized parameter to the Flask
  config.
- correctly handle bytes wrapper used by PasswordField to bytes.
- when selecting and joining on multiple models, do not create
  model instances when the foreign key is NULL.
- do not coerce the return value of function calls to COUNT or
  SUM, since the python driver will already give us the right
  Python value.
- use global state to resolve DeferredRelations, allowing for a
  nicer API. Thanks @brenguyen711.
- attempt to avoid creating invalid Python when using pwiz with
  MySQL database columns containing spaces. Yes, fucking spaces.
- fix bug in SQLite migrator which had a naive approach to fixing
  indexes.
- explicitly check for None when determining if the database has
  been set on ModelOptions. Thanks @joeyespo.

New stuff
- Added TimestampField for storing datetimes using integers.
  Greater than second delay is possible through exponentiation.
- Added Database.drop_index() method.
- Added a max_depth parameter to the model_to_dict function in the
  playhouse.shortcuts extension module.
- SelectQuery.first() function accepts a parameter n which applies
  a limit to the query and returns the first row.
- group_by(), order_by(), window() now accept a keyward argument
  extend, which, when set to True, will append to the existing
  values rather than overwriting them.
- Query results support negative indexing.
- C sources are included now as part of the package. I think they
  should be able to compile for python 2 or 3, on linux or
  windows...but not positive.

Revision 1.11: download - view: text, markup, annotated - select for diffs
Fri May 6 09:45:09 2016 UTC (8 years, 7 months ago) by fhajny
Branches: MAIN
CVS tags: pkgsrc-2016Q2-base, pkgsrc-2016Q2
Diff to: previous 1.10: preferred, colored
Changes since revision 1.10: +2 -2 lines
Update databases/py-peewee to 2.8.1.

Bugs fixed
- #821 - issue warning if Cython is old
- #822 - better handling of MySQL connections point for advanced
  use-cases.
- #313 - support equality/inequality with generic foreign key
  queries, and ensure get_or_create works with GFKs.
- #834 - fixed Python3 incompatibilities in the PasswordField,
  thanks @mosquito.
- #836 - fix handling of last_insert_id() when using APSWDatabase.
- #845 - add connection hooks to APSWDatabase.
- #852 - check SQLite library version to avoid calls to missing
  APIs.
- #857 - allow database definition to be deferred when using the
  connection pool.
- #878 - formerly .limit(0) had no effect. Now adds LIMIT 0.
- #879 - implement a __hash__ method for Model
- #886 - fix count() for compound select queries.
- #895 - allow writing to the foreign_key_id descriptor to set the
  foreign key value.
- #893 - fix boolean logic bug in model_to_dict().
- #904 - fix side-effect in clean_prefetch_query, thanks to
  @p.kamayev
- #907 - package includes pskel now.
- #852 - fix sqlite version check in BerkeleyDB backend.
- #919 - add runtime check for sqlite3 library to match MySQL and
  Postgres. Thanks @M157q

New features
- Added a number of SQLite user-defined functions and aggregates.
- Use the DB-API2 Binary type for BlobField.
- Implemented the lucene scoring algorithm in the sqlite_ext
  Cython library.
- #825 - allow a custom base class for ModelOptions, providing an
  extension
- #830 - added SmallIntegerField type.
- #838 - allow using a custom descriptor class with
  ManyToManyField.
- #855 - merged change from @lez which included docs on using
  peewee with Pyramid.
- #858 - allow arguments to be passed on query-string when using
  the db_url module. Thanks @RealSalmon
- #862 - add support for truncate table, thanks @dev-zero for the
  sample code.
- Allow the related_name model Meta option to be a callable that
  accepts the foreign key field instance.

Revision 1.10: download - view: text, markup, annotated - select for diffs
Mon Jan 18 15:53:14 2016 UTC (8 years, 10 months ago) by fhajny
Branches: MAIN
CVS tags: pkgsrc-2016Q1-base, pkgsrc-2016Q1
Diff to: previous 1.9: preferred, colored
Changes since revision 1.9: +2 -2 lines
Update databases/py-peewee to 2.8.0.

This release includes a couple new field types and greatly improved
C extension support for both speedups and SQLite enhancements. Also
includes some work, suggested by @foxx, to remove some places where
Proxy was used in favor of more obvious APIs.

New features

- C extension speedups now enabled by default, includes faster
  implementations for dict and tuple QueryResultWrapper classes,
  faster date formatting, and a faster field and model sorting.
- C implementations of SQLite functions is now enabled by default.
  SQLite extension is now compatible with APSW and can be used in
  standalone form directly from Python.
- SQLite C extension now supports murmurhash2.
- UUIDField is now supported for SQLite and MySQL, using text and
  varchar respectively, thanks @foxx!
- Added BinaryField, thanks again, @foxx!
- Added PickledField to playhouse.fields.
- ManyToManyField now accepts a list of primary keys when adding or
  removing values from the through relationship.
- Added support for SQLite table-valued functions using the
  sqlite-vtfunc library.
- Significantly simplified the build process for compiling the
  C extensions.

Backwards-incompatible changes

- Instead of using a Proxy for defining circular foreign key
  relationships, you now need to use DeferredRelation.
- Instead of using a Proxy for defining many-to-many through tables,
  you now need to use DeferredThroughModel.
- SQLite Virtual Models must now use Meta.extension_module and
  Meta.extension_options to declare extension and any options.
- MySQL database will now issue COMMIT statements for SELECT queries.

Bugs fixed

- #766, fixed bug with PasswordField and Python3. Fuck Python 3.
- #768, fixed SortedFieldList and remove_field(). Thanks @klen!
- #771, clarified docs for APSW.
- #773, added docs for request hooks in Pyramid
- #774, prefetch() only loads first ForeignKeyField
  for a given relation.
- #782, fixed typo in docs.
- #791, foreign keys were not correctly handling coercing to
  the appropriate python value.
- #792, cleaned up some CSV utils code.
- #798, cleaned up iteration protocol in QueryResultWrappers.
- #806, not really a bug, but MySQL users were clowning around
  and needed help.

2.7.4

This is another small release which adds code to automatically build
the SQLite C extension if libsqlite is available. The release also
includes:

- Support for UUIDField with SQLite.
- Support for registering additional database classes with the db_url
  module via register_database.
- prefetch() supports fetching multiple foreign-keys to the same model
  class.
- Added method to validate FTS5 search queries.

Revision 1.9: download - view: text, markup, annotated - select for diffs
Mon Nov 23 21:15:32 2015 UTC (9 years ago) by fhajny
Branches: MAIN
CVS tags: pkgsrc-2015Q4-base, pkgsrc-2015Q4
Diff to: previous 1.8: preferred, colored
Changes since revision 1.8: +5 -3 lines
Update databases/py-peewee to 2.7.3.

2.7.3
Small release which includes some changes to the BM25 sorting
algorithm and the addition of a JSONField for use with the new
JSON1 extension.

2.7.2
Small release with bugfixes to the setup script.

I've also cleaned up some missing APIs in the FTS5Model to
support more flexible use of either FTSModel or FTS5Model.

2.7.1
Small release which includes fixes to the setup script.
Particularly, if you did not have Cython installed, the
installation would completely fail. This was fixed.

2.7.0
New APIs, features, and performance improvements.

Notable changes and new features
- PasswordField that uses the bcrypt module.
- Added new Model Meta.only_save_dirty flag to, by default,
  only save fields that have been modified.
- Added support for upsert() on MySQL (in addition to SQLite).
- Implemented SQLite ranking functions (rank and bm25) in Cython,
  and changed both the Cython and Python APIs to accept weight
  values for every column in the search index. This more closely
  aligns with the APIs provided by FTS5. In fact, made the APIs
  for FTS4 and FTS5 result ranking compatible.
- Major changes to the :ref:sqlite_ext module. Function callbacks
  implemented in Python were implemented in Cython (e.g. date
  manipulation and regex processing) and will be used if Cython
  is available when Peewee is installed.
- Support for the experimental new FTS5 SQLite search extension.
- Added :py:class:SearchField for use with the SQLite FTS
  extensions.
- Added :py:class:RowIDField for working with the special rowid
  column in SQLite.
- Added a model class validation hook to allow model subclasses
  to perform any validation after class construction. This is
  currently used to ensure that FTS5Model subclasses do not
  violate any rules required by the FTS5 virtual table.

Bugs fixed
- #751, fixed some very broken behavior in the MySQL migrator
  code. Added more tests.
- #718, added a RetryOperationalError mixin that will try
  automatically reconnecting after a failed query. There was
  a bug in the previous error handler implementation that
  made this impossible, which is also fixed.

Revision 1.8: download - view: text, markup, annotated - select for diffs
Mon Oct 12 10:00:57 2015 UTC (9 years, 2 months ago) by fhajny
Branches: MAIN
Diff to: previous 1.7: preferred, colored
Changes since revision 1.7: +2 -1 lines
Add missing py-cython bl3, fixes PLIST phase

Revision 1.7: download - view: text, markup, annotated - select for diffs
Thu Oct 8 12:59:13 2015 UTC (9 years, 2 months ago) by fhajny
Branches: MAIN
Diff to: previous 1.6: preferred, colored
Changes since revision 1.6: +3 -3 lines
Update databases/py-peewee to 2.6.4.

Bugs fixed
- fixed a bug with the Cython speedups not being included
  in package.
- documented how to create models with no primary key.
- allow bare INSERT statements.
- regarding foreign key / one-to-one relationships.
- allow ArrayField to accept tuples in addition to lists.
- fix regarding unsaved relations.
- refactored QueryResultWrapper to allow multiple independent
  iterations over the same underlying result cache.
- fix bug with multiple joins to same table + eager loading.
- fix bug when connection fails while using an execution context.
- use correct column names with non-standard django foreign keys.
- return datetime.time instead of timedelta for MySQL time fields.
- fixed SQLite migrator regular expressions. Thanks @sroebert.

New features
- added support for RETURNING clauses. Update, Insert and Delete
  queries can now be called with RETURNING to retrieve the rows
  that were affected.
- added web request hook docs.
- allowed arbitrary model attributes and methods to be serialized
  by model_to_dict(). Docs.
- allow model_to_dict() to introspect query for which fields
  to serialize.
- Added backend-agnostic truncate_date() implementation.
- Added a FixedCharField which uses column type CHAR.
- Added support for arbitrary PRAGMA statements to be run on new
  SQLite connections. Docs.
- Removed berkeley_build.sh script. See instructions on my blog
  instead.

Revision 1.6: download - view: text, markup, annotated - select for diffs
Mon Aug 24 20:01:48 2015 UTC (9 years, 3 months ago) by fhajny
Branches: MAIN
CVS tags: pkgsrc-2015Q3-base, pkgsrc-2015Q3
Diff to: previous 1.5: preferred, colored
Changes since revision 1.5: +2 -2 lines
Update databases/py-peewee to 2.6.3

2.6.3
- New `fields` module.
- Fix runtests to not run dupes.
- Add `FixedCharField`, fixes #631

2.6.2
- #641, fixed bug with exception wrapping and Python 2.6
- #634, fixed bug where correct query result wrapper was not being used
  for certain composite queries.
- #625, cleaned up some example code.
- #614, fixed bug with aggregate_rows() when there are multiple joins
  to the same table.
- Added create_or_get() as a companion to get_or_create().
- Added support for ON CONFLICT clauses for UPDATE and INSERT queries. Docs.
- Added a JSONKeyStore to playhouse.kv.
- Added Cythonized version of strip_parens(), with plans to perhaps move
  more performance-critical code to Cython in the future.
- Added docs on specifying vendor-specific database parameters.
- Added docs on specifying field default values (both client and server-side).
- Added docs on foreign key field back-references.
- Added docs for models without a primary key.
- Cleaned up docs on prefetch() and aggregate_rows().

Revision 1.5: download - view: text, markup, annotated - select for diffs
Wed Jun 10 17:34:25 2015 UTC (9 years, 6 months ago) by fhajny
Branches: MAIN
CVS tags: pkgsrc-2015Q2-base, pkgsrc-2015Q2
Diff to: previous 1.4: preferred, colored
Changes since revision 1.4: +5 -3 lines
Update databases/py-peewee to 2.6.1.

2.6.1
- #606, support self-referential joins with prefetch and aggregate_rows()
  methods.
- #588, accomodate changes in SQLite's PRAGMA index_list() return value.
- #607, fixed bug where pwiz was not passing table names to introspector.
- #591, fixed bug with handling of named cursors in older psycopg2 version.
- Removed some cruft from the APSWDatabase implementation.
- Added CompressedField and AESEncryptedField
- #609, #610, added Django-style foreign key ID lookup.
- Added support for Hybrid Attributes (cool idea courtesy of SQLAlchemy).
- Added upsert keyword argument to the Model.save() function (SQLite only).
- #587, added support for ON CONFLICT SQLite clause for INSERT and UPDATE
  queries.
- #601, added hook for programmatically defining table names.
- #581, #611, support connection pools with playhouse.db_url.connect().
- Added Contributing section section to docs.

2.6.0
- get_or_create() now returns a 2-tuple consisting of the model instance
  and a boolean indicating whether the instance was created. The function
  now behaves just like the Django equivalent.
- #574, better support for setting the character encoding on Postgresql
  database connections. Thanks @klen!
- Improved implementation of get_or_create().

Revision 1.4: download - view: text, markup, annotated - select for diffs
Tue Apr 7 09:51:44 2015 UTC (9 years, 8 months ago) by fhajny
Branches: MAIN
Diff to: previous 1.3: preferred, colored
Changes since revision 1.3: +2 -2 lines
Update py-peewee to 2.5.1.

2.5.1
- #566, fixed a bug regarding parentheses around compound SELECT queries
  (i.e. UNION, INTERSECT, etc).
- Fixed unreported bug where table aliases were not generated correctly
  for compound SELECT queries.
- #559, add option to preserve original column order with pwiz. Thanks @elgow!
- Fixed unreported bug where selecting all columns from a ModelAlias
  does not use the appropriate FieldAlias objects.
- #561, added an option for bulk insert queries to return the list
  of auto-generated primary keys. See docs for InsertQuery.return_id_list.
- #569, added parse function to the playhouse.db_url module. Thanks @stt!
- Added hacks section to the docs. Please contribute your hacks!
- Calls to Node.in_() and Node.not_in() do not take *args anymore and
  instead take a single argument.

2.5.0
- #534, CSV utils was erroneously stripping the primary key from CSV data.
- #537, fix upserts when using insert_many.
- #541, respect autorollback with PostgresqlExtDatabase. Thanks @davidmcclure.
- #551, fix for QueryResultWrapper's implementation of the iterator protocol.
- #554, allow SQLite journal_mode to be set at run-time.
- Fixed case-sensitivity issue with DataSet.
- Added support for CAST expressions.
- Added a hook for extending Node with custom methods.
- JOIN_<type> became JOIN.<type>, e.g. .join(JOIN.LEFT_OUTER).
- OP_<code> became OP.<code>.
- #556, allowed using + and - prefixes to indicate ascending/descending
  ordering.
- #550, added Database.initialize_connection() hook.
- #549, bind selected columns to a particular model. Thanks @jhorman, nice PR!
- #531, support for swapping databases at run-time via Using.
- #530, support for SQLCipher and Python3.
- New RowIDField for sqlite_ext playhouse module. This field can be used
  to interact with SQLite rowid fields.
- Added LateralJoin helper to the postgres_ext playhouse module.

2.4.7
- #504, Docs updates.
- #506, Fixed regression in aggregate_rows()
- #510, Fixes bug in pwiz overwriting columns.
- #514, Correctly cast foreign keys in prefetch().
- #515, Simplifies queries issued when doing recursive deletes.
- #516, Fix cloning of Field objects.
- #519, Aggregate rows now correctly preserves ordering of joined instances.
- Unreported, fixed bug to not leave expired connections sitting around
  in the pool.
- Added support for Postgresql's jsonb type with BinaryJSONField.
- Add some basic Flask helpers.
- Add support for UNION ALL queries in #512
- Add SqlCipherExtDatabase, which combines the sqlcipher database with
  the sqlite extensions.
- Add option to print metadata when generating code with pwiz.

2.4.6
- #503, fixes behavior of aggregate_rows() when used with a CompositeKey.
- #498, fixes value coercion for field aliases.
- #492, fixes bug with pwiz and composite primary keys.
- #486, correctly handle schemas with reflection module.
- Peewee has a new ManyToManyField available in the playhouse.shortcuts
  module.
- Peewee now has proper support for NOT IN queries through the Node.not_in()
  method.
- Models now support iteration. This is equivalent to Model.select().

2.4.5
- #471, #482 and #484, all of which had to do with how joins were handled
  by the aggregate_rows() query result wrapper.
- #472 removed some needless special-casing in Model.save().
- #466 fixed case-sensitive issues with the SQLite migrator.
- #474 fixed a handful of bugs that cropped up migrating foreign keys
  with SQLite.
- #475 fixed the behavior of the SQLite migrator regarding auto-generated
  indexes.
- #479 fixed a bug in the code that stripped extra parentheses
  in the SQL generator.
- Fixed a handful of bugs in the APSW extension.
- Added connection abstraction called ExecutionContext (see docs).
- Made all context managers work as decorators (atomic, transaction,
  savepoint, execution_context).
- Added explicit methods for IS NULL and IS NOT NULL queries. The latter was
  actually necessary since the behavior is different from NOT IS NULL (...).
- Allow disabling backref validation (#465)
- Made quite a few improvements to the documentation, particularly sections
  on transactions.
- Added caching to the DataSet extension, which should improve performance.
- Made the SQLite migrator smarter with regards to preserving indexes
  when a table copy is necessary.

Revision 1.3: download - view: text, markup, annotated - select for diffs
Fri Dec 12 11:42:25 2014 UTC (10 years ago) by fhajny
Branches: MAIN
CVS tags: pkgsrc-2015Q1-base, pkgsrc-2015Q1, pkgsrc-2014Q4-base, pkgsrc-2014Q4
Diff to: previous 1.2: preferred, colored
Changes since revision 1.2: +2 -2 lines
Update py-peewee to 2.4.4.

2.4.4
=====
* Backwards-incompatible changes
  - The argument signature for the SqliteExtDatabase.aggregate() decorator
    changed so that the aggregate name is the first parameter, and
    the number of parameters is the second parameter. If no values are
    specified, peewee will choose the name of the class and an un-specified
    number of arguments (-1).
  - The logic for saving a model with a composite key changed slightly.
    Previously, if a model had a composite primary key and you called save(),
    only the dirty fields would be saved.
* Bugs fixed
  - #462
  - #465, add hook for disabling backref validation.
  - #466, fix case-sensitive table names with migration module.
  - #469, save only dirty fields.
* New features
  - Lots of enhancements and cleanup to the playhouse.apsw_ext module.
  - The playhouse.reflection module now supports introspecting indexes.
  - Added a model option for disabling backref validation.
  - Added support for the SQLite closure table extension.
  - Added support for virtual fields, which act on dynamically-created
    virtual table fields.
  - Added a new example: a virtual table implementation that exposes Redis
    as a relational database table.
  - Added a module playhouse.sqlite_aggregates that contains a handful of
    aggregates you may find useful when developing with SQLite.
  - Small documentation updates here and there.

2.4.3
=====
* Bugs fixed
  - #466, table names are case sensitive in the SQLite migrations module.
  - #465, added option to disable backref validation.
  - #462, use the schema name consistently with postgres reflection.
* New features
  - New model Meta option to disable backref validation. See
    validate_backrefs.
  - Added documentation on ordering by calculated values.
  - Added basic PyPy compatibility.
  - Added logic to close cursors after they have been exhausted.
  - Structured and consolidated database metadata introspection, including
    improvements for introspecting indexes.
  - Added support to prefetch for traversing up the query tree.
  - Added introspection option to skip invalid models while introspecting.
  - Added option to limit the tables introspected.
  - Added closed connection detection to the MySQL connection pool.
  - Enhancements to passing options to creating virtual tables with SQLite.
  - Added factory method for generating Closure tables for use with the
    transitive_closure SQLite extension.
  - Added support for loading SQLite extensions.
  - Numerous test-suite enhancements and new test-cases.

2.4.2
=====
* Bugs fixed
  - #449, typo in the db_url extension, thanks to @malea for the fix.
  - #457 and #458, fixed documentation deficiences.
* New features
  - Added support for importing data when using the DataSet extension.
  - Added an encrypted diary app to the examples.
  - Better index reconstruction when altering columns on SQLite databases
    with the migrate module.
  - Support for multi-column primary keys in the reflection module.
  - Close cursors more aggressively when executing SELECT queries.

Revision 1.2: download - view: text, markup, annotated - select for diffs
Wed Oct 29 13:13:38 2014 UTC (10 years, 1 month ago) by fhajny
Branches: MAIN
Diff to: previous 1.1: preferred, colored
Changes since revision 1.1: +7 -2 lines
Update py-peewee to 2.4.1.

Changes in 2.4.1:
- Fixed #448, add hook to the connection pool for detecting closed
  connections.
- Fixed #229, fix join attribute detection.
- Fixed #447, fixed documentation typo.

Changes in 2.4.0:
- Most of the introspection logic was moved out of the pwiz module and
  into playhouse.reflection.
- Created a new reflection extension for introspecting databases. The
  reflection module additionally can generate actual peewee Model classes
  dynamically.
- Created a dataset library (based on the SQLAlchemy project of the same
  name). For more info check out the blog post announcing playhouse.dataset.
- Added a db_url module which creates Database objects from a connection
  string.
- Added csv dump functionality to the CSV utils extension.
- Added an atomic context manager to support nested transactions.
- Added support for HStore, JSON and TSVector to the reflection module.
- More documentation updates.
- Fixed #440, which fixes a bug where Model.dirty_fields did not return
  an empty set for some subclasses of QueryResultWrapper.

Revision 1.1: download - view: text, markup, annotated - select for diffs
Fri Oct 17 10:24:04 2014 UTC (10 years, 1 month ago) by fhajny
Branches: MAIN
Import peewee as databases/py-peewee.

Peewee is a simple and small ORM. It has few (but expressive)
concepts, making it easy to learn and intuitive to use.
Supports SQLite, MySQL and PostgreSQL.

Diff request

This form allows you to request diffs between any two revisions of a file. You may select a symbolic revision name using the selection box or you may type in a numeric name using the type-in text box.

Log view options

CVSweb <webmaster@jp.NetBSD.org>