Revisions of python-peewee
buildservice-autocommit
accepted
request 741075
from
Tomáš Chvátal (scarabeus_iv)
(revision 23)
baserev update by copy to link target
Tomáš Chvátal (scarabeus_iv)
accepted
request 741068
from
Markéta Machová (mcalabkova)
(revision 22)
- Update to 3.11.2 * Implement hash interface for Alias instances, allowing them to be used in multi-source queries. * Workaround for MySQL prior to 8 and MariaDB handling of union queries inside of parenthesized expressions (like IN). * Be more permissive in letting invalid values be stored in a field whose type is INTEGER or REAL, since Sqlite allows this. * Fix for issue #1991 regarding setting intervening models to None. * Fixes the Model._pk and get_id() interfaces so they no longer introduce the possibility of accidentally resolving the FK.
buildservice-autocommit
accepted
request 730058
from
Tomáš Chvátal (scarabeus_iv)
(revision 21)
baserev update by copy to link target
Tomáš Chvátal (scarabeus_iv)
committed
(revision 20)
- Update to 3.10.0: * Many bugfixes to enumerate, see CHANGELOG.md
buildservice-autocommit
accepted
request 717890
from
Tomáš Chvátal (scarabeus_iv)
(revision 19)
baserev update by copy to link target
Tomáš Chvátal (scarabeus_iv)
committed
(revision 18)
- Update to 3.9.6: * Support nesting the Database instance as a context-manager. The outermost block will handle opening and closing the connection along with wrapping everything in a transaction. Nested blocks will use savepoints. * Add new session_start(), session_commit() and session_rollback() interfaces to the Database object to support using transactional controls in situations where a context-manager or decorator is awkward. * Fix error that would arise when attempting to do an empty bulk-insert. * Set isolation_level=None in SQLite connection constructor rather than afterwards using the setter. * Add create_table() method to Select query to implement CREATE TABLE AS. * Cleanup some declarations in the Sqlite C extension. * Add new example showing how to implement Reddit's ranking algorithm in SQL.
buildservice-autocommit
accepted
request 702514
from
Alexei Podvalsky (awissu)
(revision 17)
baserev update by copy to link target
Alexei Podvalsky (awissu)
accepted
request 702513
from
Alexei Podvalsky (awissu)
(revision 16)
- Update to 3.9.5: * Added small helper for setting timezone when using Postgres. * Improved SQL generation for VALUES clause. * Support passing resolution to TimestampField as a power-of-10. * Small improvements to INSERT queries when the primary-key is not an auto-incrementing integer, but is generated by the database server (eg uuid). * Cleanups to virtual table implementation and python-to-sqlite value conversions. * Fixed bug related to binding previously-unbound models to a database using a context manager, #1913. - Change in 3.9.4: * Add Model.bulk_update() method for bulk-updating fields across multiple model instances. Docs. * Add lazy_load parameter to ForeignKeyField. When initialized with lazy_load=False, the foreign-key will not use an additional query to resolve the related model instance. * Added Model.truncate_table() method. * The reflection and pwiz extensions now attempt to be smarter about converting database table and column names into snake-case. * Bulk insert via insert_many() no longer require specification of the fields argument when the inserted rows are lists/tuples. In that case, the fields will be inferred to be all model fields except any auto-increment id. * Add DatabaseProxy, which implements several of the Database class context managers. * Add support for window function frame exclusion and added built-in support for the GROUPS frame type. * Add support for chaining window functions by extending a previously-declared window function. * Playhouse Postgresql extension TSVectorField.match() method supports an additional argument plain, which can be used to control the parsing of the TS query. * Added very minimal JSONField to the playhouse MySQL extension. - Update to 3.9.3: * Added cross-database support for NULLS FIRST/LAST when specifying the ordering for a query. Previously this was only supported for Postgres. * Added EXCLUDED helper for referring to the EXCLUDED namespace used with INSERT...ON CONFLICT queries, when referencing values in the conflicting row data. * Added helper method to the model Metadata class for setting the table name at run-time. Setting the Model._meta.table_name directly may have appeared to work in some situations, but could lead to subtle bugs. The new API is Model._meta.set_table_name(). * Enhanced helpers for working with Peewee interactively, see doc. * Fix cache invalidation bug in DataSet that was originally reported on the sqlite-web project. * New example script implementing a hexastore. - Update to 3.8.2: * The default row-type for INSERT queries executed with a non-default RETURNING clause has changed from tuple to Model instances. This makes INSERT behavior consistent with UPDATE and DELETE queries that specify a RETURNING clause. * Removing support for the table_alias model Meta option. * Added playhouse.shortcuts.ReconnectMixin, which can be used to implement automatic reconnect under certain error conditions. * Fix SQL generation bug when using an inline window function in the ORDER BY clause of a query. * Fix possible zero-division in user-defined implementation of BM25 ranking algorithm for SQLite full-text search. - Update to 3.7.1: * Added table_settings model Meta option, which should be a list of strings specifying additional options for CREATE TABLE, which are placed after the closing parentheses. * Allow specification of on_update and on_delete behavior for many-to-many relationships when using ManyToManyField. * Fixed incorrect SQL generation for Postgresql ON CONFLICT clause when the conflict_target is a named constraint (rather than an index expression). This introduces a new keyword-argument to the on_conflict() method: conflict_constraint, which is currently only supported by Postgresql. Refs issue #1737. * Fixed incorrect SQL for sub-selects used on the right side of IN expressions. Previously the query would be assigned an alias, even though an alias was not needed. * Fixed incorrect SQL generation for Model indexes which contain SQL functions as indexed columns. * Fixed bug in the generation of special queries used to perform operations on SQLite FTS5 virtual tables. * Allow frozenset to be correctly parameterized as a list of values. * Allow multi-value INSERT queries to specify columns as a list of strings. * Support CROSS JOIN for model select queries. - Add missing "that". - Update to 3.6.4: - bugfixes - works with python 3.7.0 - Support for specifying ROWS or RANGE window frame types. - Add APIs for user-defined window functions if using pysqlite3 and sqlite 3.25.0 or newer. - TimestampField now uses 64-bit integer data-type for storage. - Added support to pwiz and playhouse.reflection to enable generating models from VIEWs. - Added lower-level database API for introspecting VIEWs. - Revamped continuous integration setup for better coverage, including 3.7 and 3.8-dev. - Allow building C extensions even if Cython is not installed, by distributing pre-generated C source files. - Fixes tests - Update to 3.5.2: * New guide to using window functions in Peewee. * New and improved table name auto-generation. * Allow passing single fields/columns to window function order_by and partition_by arguments. * Support for FILTER (WHERE...) clauses with window functions and aggregates. * Added IdentityField class suitable for use with Postgres 10's new identity column type. * Fixed bug creating indexes on tables that are in attached databases (SQLite). * Fixed obscure bug when using prefetch() and ModelAlias to populate a back-reference related model. - Change in 3.5.1: * New documentation for working with relationships in Peewee. * Improved tests and documentation for MySQL upsert functionality. * Allow database parameter to be specified with ModelSelect.get() method. For discussion, see #1620. * Add QualifiedNames helper to peewee module exports. * Add temporary= meta option to support temporary tables. * Allow a Database object to be passed to constructor of DataSet helper. - Update to 3.5.0: * see: /usr/share/package/python-peewee/CHANGELOG.md - Build with dependencies: sqlite3, cython - Build with python3 and python2 (singlespec) - Drop the noarch package (arch-independent-package-contains-binary-or-object) - Spec file cleanup - update version 2.6.3 * read https://github.com/coleifer/peewee/releases - update version 2.2.3 * New migrations module * Added a return value to Model.save() indicating number of rows affected. * Added a date_trunc() method that works for Sqlite. * Added a Model.sqlall() class-method to return all the SQL to generate the model/indices. * bugfixes - initial version 2.2.2 * see https://github.com/coleifer/peewee/commits/master for details
buildservice-autocommit
accepted
request 687976
from
Alexei Podvalsky (awissu)
(revision 15)
baserev update by copy to link target
Alexei Podvalsky (awissu)
accepted
request 687975
from
Alexei Podvalsky (awissu)
(revision 14)
- Update to 3.9.3: * Added cross-database support for NULLS FIRST/LAST when specifying the ordering for a query. Previously this was only supported for Postgres. * Added EXCLUDED helper for referring to the EXCLUDED namespace used with INSERT...ON CONFLICT queries, when referencing values in the conflicting row data. * Added helper method to the model Metadata class for setting the table name at run-time. Setting the Model._meta.table_name directly may have appeared to work in some situations, but could lead to subtle bugs. The new API is Model._meta.set_table_name(). * Enhanced helpers for working with Peewee interactively, see doc. * Fix cache invalidation bug in DataSet that was originally reported on the sqlite-web project. * New example script implementing a hexastore.
buildservice-autocommit
accepted
request 667064
from
Alexei Podvalsky (awissu)
(revision 13)
baserev update by copy to link target
Alexei Podvalsky (awissu)
accepted
request 667063
from
Alexei Podvalsky (awissu)
(revision 12)
- Update to 3.8.2: * The default row-type for INSERT queries executed with a non-default RETURNING clause has changed from tuple to Model instances. This makes INSERT behavior consistent with UPDATE and DELETE queries that specify a RETURNING clause. * Removing support for the table_alias model Meta option. * Added playhouse.shortcuts.ReconnectMixin, which can be used to implement automatic reconnect under certain error conditions. * Fix SQL generation bug when using an inline window function in the ORDER BY clause of a query. * Fix possible zero-division in user-defined implementation of BM25 ranking algorithm for SQLite full-text search. - Update to 3.7.1: * Added table_settings model Meta option, which should be a list of strings specifying additional options for CREATE TABLE, which are placed after the closing parentheses. * Allow specification of on_update and on_delete behavior for many-to-many relationships when using ManyToManyField. * Fixed incorrect SQL generation for Postgresql ON CONFLICT clause when the conflict_target is a named constraint (rather than an index expression). This introduces a new keyword-argument to the on_conflict() method: conflict_constraint, which is currently only supported by Postgresql. Refs issue #1737. * Fixed incorrect SQL for sub-selects used on the right side of IN expressions. Previously the query would be assigned an alias, even though an alias was not needed. * Fixed incorrect SQL generation for Model indexes which contain SQL functions as indexed columns. * Fixed bug in the generation of special queries used to perform operations on SQLite FTS5 virtual tables. * Allow frozenset to be correctly parameterized as a list of values. * Allow multi-value INSERT queries to specify columns as a list of strings. * Support CROSS JOIN for model select queries. - Add missing "that". - Update to 3.6.4: - bugfixes - works with python 3.7.0 - Support for specifying ROWS or RANGE window frame types. - Add APIs for user-defined window functions if using pysqlite3 and sqlite 3.25.0 or newer. - TimestampField now uses 64-bit integer data-type for storage. - Added support to pwiz and playhouse.reflection to enable generating models from VIEWs. - Added lower-level database API for introspecting VIEWs. - Revamped continuous integration setup for better coverage, including 3.7 and 3.8-dev. - Allow building C extensions even if Cython is not installed, by distributing pre-generated C source files. - Fixes tests - Update to 3.5.2: * New guide to using window functions in Peewee. * New and improved table name auto-generation. * Allow passing single fields/columns to window function order_by and partition_by arguments. * Support for FILTER (WHERE...) clauses with window functions and aggregates. * Added IdentityField class suitable for use with Postgres 10's new identity column type. * Fixed bug creating indexes on tables that are in attached databases (SQLite). * Fixed obscure bug when using prefetch() and ModelAlias to populate a back-reference related model. - Change in 3.5.1: * New documentation for working with relationships in Peewee. * Improved tests and documentation for MySQL upsert functionality. * Allow database parameter to be specified with ModelSelect.get() method. For discussion, see #1620. * Add QualifiedNames helper to peewee module exports. * Add temporary= meta option to support temporary tables. * Allow a Database object to be passed to constructor of DataSet helper. - Update to 3.5.0: * see: /usr/share/package/python-peewee/CHANGELOG.md - Build with dependencies: sqlite3, cython - Build with python3 and python2 (singlespec) - Drop the noarch package (arch-independent-package-contains-binary-or-object) - Spec file cleanup - update version 2.6.3 * read https://github.com/coleifer/peewee/releases - update version 2.2.3 * New migrations module * Added a return value to Model.save() indicating number of rows affected. * Added a date_trunc() method that works for Sqlite. * Added a Model.sqlall() class-method to return all the SQL to generate the model/indices. * bugfixes - initial version 2.2.2 * see https://github.com/coleifer/peewee/commits/master for details
buildservice-autocommit
accepted
request 640692
from
Alexei Podvalsky (awissu)
(revision 11)
baserev update by copy to link target
Alexei Podvalsky (awissu)
accepted
request 640691
from
Alexei Podvalsky (awissu)
(revision 10)
- Update to 3.7.1: * Added table_settings model Meta option, which should be a list of strings specifying additional options for CREATE TABLE, which are placed after the closing parentheses. * Allow specification of on_update and on_delete behavior for many-to-many relationships when using ManyToManyField. * Fixed incorrect SQL generation for Postgresql ON CONFLICT clause when the conflict_target is a named constraint (rather than an index expression). This introduces a new keyword-argument to the on_conflict() method: conflict_constraint, which is currently only supported by Postgresql. Refs issue #1737. * Fixed incorrect SQL for sub-selects used on the right side of IN expressions. Previously the query would be assigned an alias, even though an alias was not needed. * Fixed incorrect SQL generation for Model indexes which contain SQL functions as indexed columns. * Fixed bug in the generation of special queries used to perform operations on SQLite FTS5 virtual tables. * Allow frozenset to be correctly parameterized as a list of values. * Allow multi-value INSERT queries to specify columns as a list of strings. * Support CROSS JOIN for model select queries.
buildservice-autocommit
accepted
request 625970
from
Tomáš Chvátal (scarabeus_iv)
(revision 9)
baserev update by copy to link target
Tomáš Chvátal (scarabeus_iv)
accepted
request 625960
from
Jan Engelhardt (jengelh)
(revision 8)
- Add missing "that".
Matej Cepl (mcepl)
committed
(revision 7)
- Update to 3.6.4: - bugfixes - works with python 3.7.0 - Support for specifying ROWS or RANGE window frame types. - Add APIs for user-defined window functions if using pysqlite3 and sqlite 3.25.0 or newer. - TimestampField now uses 64-bit integer data-type for storage. - Added support to pwiz and playhouse.reflection to enable generating models from VIEWs. - Added lower-level database API for introspecting VIEWs. - Revamped continuous integration setup for better coverage, including 3.7 and 3.8-dev. - Allow building C extensions even if Cython is not installed, by distributing pre-generated C source files.
Matej Cepl (mcepl)
committed
(revision 6)
Fixes tests
buildservice-autocommit
accepted
request 620635
from
Alexei Podvalsky (awissu)
(revision 5)
baserev update by copy to link target
Alexei Podvalsky (awissu)
committed
(revision 4)
Displaying revisions 41 - 60 of 63