All Versions
Latest Version
Avg Release Cycle
36 days
Latest Release

Changelog History
Page 13

  • v2.2.3 Changes

    ๐Ÿš€ This release contains a new migrations module in addition to a number of small features and bug fixes.

    ๐Ÿ”„ Changes in 2.2.3

    • ๐Ÿ†• New migrations module.
    • โž• Added a return value to 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

  • v2.2.1 Changes

    ๐Ÿš€ I've been looking forward to this release, as it contains a couple new features that I've been wanting to add for some time now. Hope you find them useful.

    ๐Ÿ”„ Changes in 2.2.1

    • 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

  • v2.2.0 Changes

    ๐Ÿš€ This release contains a large refactoring of the way SQL was generated for both โšก๏ธ the standard query classes (Select, Insert, Update, Delete) as well as for the DDL methods (create_table, create_index, etc). Instead of joining strings of SQL and manually quoting things, I've created Clause objects containing multiple Node objects to represent all parts of the query.

    I also changed the way peewee determins the SQL to represent a field. Now a field implements __ddl__ and __ddl_column__ methods. The former creates the entire field definition, e.g.:

    "quoted_column_name" <result of call to __ddl_column__> [NOT NULL/PRIMARY KEY/DEFAULT NEXTVAL(...)/CONSTRAINTS...]

    The latter method is responsible just for the column type definition. This might ๐Ÿ‘ return VARCHAR(255) or simply TEXT. I've also added support for arbitrary constraints on each field, so you might have:

    price = DecimalField(decimal_places=2, constraints=[Check('price > 0')])

    ๐Ÿ”„ Changes in 2.2.0

    • ๐Ÿ”จ 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

  • v2.1.7 Changes

    ๐Ÿ”„ Changes in 2.1.7

    • ๐Ÿ‘Œ 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: ๐Ÿš€ Released 2013-12-25

  • v2.1.6 Changes

    ๐Ÿ”„ Changes included in 2.1.6:

    • โœ… Lightweight Django integration.
    • โž• Added a csv loader to playhouse.
    • Register unicode converters per-connection instead of globally when using pscyopg2.
    • ๐Ÿ›  Fix for how the related object cache is invalidated (#243).

    Commits: ๐Ÿš€ Released 2013-11-19

  • v2.1.5 Changes

    Summary of new features

    • โœ… Rewrote the playhouse.postgres_ext.ServerSideCursor helper to work with a single query. Docs.
    • Added error handler hook to the database class, allowing your code to choose how to handle errors executing SQL. Docs.
    • ๐Ÿ‘ Allow arbitrary attributes to be stored in Model.Meta a5e13bb26d6196dbd24ff228f99ff63d9c046f79.
    • ๐Ÿ‘Œ Support for composite primary keys (!!). How-to and API docs.
    • โž• Added helper for generating CASE expressions. Docs.
    • ๐Ÿ‘ Allow the table alias to be specified as a model Meta option.
    • โž• Added ability to specify NOWAIT when issuing SELECT FOR UPDATE queries.

    ๐Ÿ› Bug fixes

    • #147, SQLite auto-increment behavior.
    • #222
    • ๐Ÿ“„ #223, missing call to execute() in docs.
    • #224, python 3 compatibility fix.
    • #227, was using wrong column type for boolean with MySQL.

    Commits: ๐Ÿš€ Released 2013-10-19

  • v2.1.4 Changes

    • ๐Ÿ”จ Small refactor of some components used to represent expressions (mostly better names).
    • ๐Ÿ‘Œ Support for Array fields in postgresql.
    • โž• Added notes on Proxy
    • ๐Ÿ‘Œ Support for Server side cursors with postgresql.
    • Code cleanups for more consistency.

    Commits: ๐Ÿš€ Released 2013-08-05

  • v2.1.3 Changes

    • โž• Added the sqlite_ext module, including support for virtual tables, full-text search, user-defined functions, collations and aggregates, as well as more granular locking.
    • ๐Ÿ›  Manually convert data-types when doing simple aggregations - fixes issue #208
    • ๐ŸŽ Profiled code and dramatically increased performance of benchmarks.
    • โž• Added a proxy object for lazy database initialization - fixes issue #210

    Commits: ๐Ÿš€ Released 2013-06-28