311devs-peewee

* Added a `Window` object for creating reusable window definitions.
* Added support for `DISTINCT ON (...)`.
* Added a BerkeleyDB-backed sqlite `Database` and build script.
* Fixed how the `UUIDField` handles `None` values (thanks alexlatchford).
* Fixed various things in the example app.
* Added 3.4 to the travis build (thanks frewsxcv).

[View commits](https://github.com/coleifer/peewee/compare/2.2.4...2.2.5)

* Rewrite of `pwiz`, schema introspection utility.
* `Model.save()` returns a value indicating the number of modified rows.
* Fixed bug with `PostgresqlDatabase.last_insert_id()` leaving a transaction open in autocommit mode (353).
* Added BM25 ranking algorithm for full-text searches with SQLite.

[View commits](https://github.com/coleifer/peewee/compare/2.2.3...2.2.4)

* New migrations module.
* Added a return value to `Model.save()` indicating number of rows affected.
* Added a `date_trunc()` method that works for Sqlite.
* Added a `Model.sqlall()` class-method to return all the SQL to generate the model / indices.

Bugs fixed

* 342, allow functions to not coerce parameters automatically.
* 338, fixed unaliased columns when using Array and Json fields with postgres, thanks mtwesley.
* 331, corrected issue with the way unicode arrays were adapted with psycopg2.
* 328, pwiz / mysql bug.
* 326, fixed calculation of the alias_map when using subqueries.
* 324, bug with `prefetch()` not selecting the correct primary key.


[View commits](https://github.com/coleifer/peewee/compare/2.2.2...2.2.3)

* Window queries using ``OVER`` syntax.
* Compound query operations ``UNION``, ``INTERSECT``, ``EXCEPT`` as well as symmetric difference.

Bugs fixed

* 300, pwiz was not correctly interpreting some foreign key constraints in SQLite.
* 298, drop table with cascade API was missing.
* 294, typo.

[View commits](https://github.com/coleifer/peewee/compare/2.2.0...2.2.1)

* Refactored query generation for both SQL queries and DDL queries.
* Support for arbitrary column constraints.
* `autorollback` option to the `Database` class that will roll back the
transaction before raising an exception.
* Added `JSONField` type to the `postgresql_ext` module.
* Track fields that are explicitly set, allowing faster saves (thanks soasme).
* Allow the `FROM` clause to be an arbitrary `Node` object (290).
* `schema` is a new `Model.Mketa` option and is used throughout the code.
* Allow indexing operation on HStore fields (thanks zdxerr, 293).

Bugs fixed

* 277 (where calls not chainable with update query)
* 278, use `wraps()`, thanks lucasmarshall
* 284, call `prepared()` after `create()`, thanks soasme.
* 286, cursor description issue with pwiz + postgres

[View commits](https://github.com/coleifer/peewee/compare/2.1.7...2.2.0)

* Support for savepoints (Sqlite, Postgresql and MySQL) using an API similar to that of transactions.
* Common set of exceptions to wrap DB-API 2 driver-specific exception classes, e.g. ``peewee.IntegrityError``.
* When pwiz cannot determine the underlying column type, display it in a comment in the generated code.
* Support for circular foreign-keys.
* Moved ``Proxy`` into peewee (previously in ``playhouse.proxy``).
* Renamed ``R()`` to ``SQL()``.
* General code cleanup, some new comments and docstrings.

Bugs fixed

* Fixed a small bug in the way errors were handled in transaction context manager.
* 257
* 265, nest multiple calls to functions decorated with `database.commit_on_success`.
* 266
* 267

Commits: https://github.com/coleifer/peewee/compare/2.1.6...2.1.7
Released 2013-12-25