./databases/py-peewee, Small, expressive ORM for PostgreSQL, MySQL and SQLite

[ CVSweb ] [ Homepage ] [ RSS ] [ Required by ] [ Add to tracker ]

Branch: CURRENT, Version: 3.8.2, Package name: py27-peewee-3.8.2, Maintainer: fhajny

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.

Required to run:
[devel/py-setuptools] [databases/py-sqlite3] [devel/py-cython] [lang/python27]

Required to build:
[textproc/py-sphinx] [pkgtools/cwrappers]

Master sites:

SHA1: 8711fed0fc964efc47862318a88911035481f41e
RMD160: 70cc439456ed827078e12c1c06ce9fdb0f854dcd
Filesize: 797.424 KB

Version history: (Expand)

CVS history: (Expand)

   2019-01-18 09:04:45 by Adam Ciarcinski | Files touched by this commit (2) | Package updated
Log message:
py-peewee: updated to 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).

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.
   2019-01-08 09:37:59 by Adam Ciarcinski | Files touched by this commit (3) | Package updated
Log message:
py-peewee: updated to 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).

Remove minimum passphrase restrictions in SQLCipher integration.

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.
   2018-12-18 12:48:33 by Adam Ciarcinski | Files touched by this commit (4) | Package updated
Log message:
py-peewee: updated to 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.


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


* 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.
   2018-12-15 22:12:25 by Thomas Klausner | Files touched by this commit (67) | Package updated
Log message:
*: update email for fhajny
   2018-12-09 19:52:52 by Adam Ciarcinski | Files touched by this commit (724)
Log message:
revbump after updating textproc/icu
   2018-10-26 13:57:01 by Jonathan Perkin | Files touched by this commit (3)
Log message:
py-peewee: Find libsqlite3 correctly.
   2018-10-07 10:42:24 by Adam Ciarcinski | Files touched by this commit (2) | Package updated
Log message:
py-peewee: updated to 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.

* 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.
   2018-09-07 11:01:09 by Adam Ciarcinski | Files touched by this commit (2) | Package updated
Log message:
py-peewee: updated to 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
* Add Model.bulk_create() method for bulk-inserting unsaved model instances.
* Add close_stale() method to the connection pool to support closing stale
* 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.

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