head 1.4; access; symbols pkgsrc-2023Q4:1.4.0.30 pkgsrc-2023Q4-base:1.4 pkgsrc-2023Q3:1.4.0.28 pkgsrc-2023Q3-base:1.4 pkgsrc-2023Q2:1.4.0.26 pkgsrc-2023Q2-base:1.4 pkgsrc-2023Q1:1.4.0.24 pkgsrc-2023Q1-base:1.4 pkgsrc-2022Q4:1.4.0.22 pkgsrc-2022Q4-base:1.4 pkgsrc-2022Q3:1.4.0.20 pkgsrc-2022Q3-base:1.4 pkgsrc-2022Q2:1.4.0.18 pkgsrc-2022Q2-base:1.4 pkgsrc-2022Q1:1.4.0.16 pkgsrc-2022Q1-base:1.4 pkgsrc-2021Q4:1.4.0.14 pkgsrc-2021Q4-base:1.4 pkgsrc-2021Q3:1.4.0.12 pkgsrc-2021Q3-base:1.4 pkgsrc-2021Q2:1.4.0.10 pkgsrc-2021Q2-base:1.4 pkgsrc-2021Q1:1.4.0.8 pkgsrc-2021Q1-base:1.4 pkgsrc-2020Q4:1.4.0.6 pkgsrc-2020Q4-base:1.4 pkgsrc-2020Q3:1.4.0.4 pkgsrc-2020Q3-base:1.4 pkgsrc-2020Q2:1.4.0.2 pkgsrc-2020Q2-base:1.4 pkgsrc-2020Q1:1.3.0.10 pkgsrc-2020Q1-base:1.3 pkgsrc-2019Q4:1.3.0.12 pkgsrc-2019Q4-base:1.3 pkgsrc-2019Q3:1.3.0.8 pkgsrc-2019Q3-base:1.3 pkgsrc-2019Q2:1.3.0.6 pkgsrc-2019Q2-base:1.3 pkgsrc-2019Q1:1.3.0.4 pkgsrc-2019Q1-base:1.3 pkgsrc-2018Q4:1.3.0.2 pkgsrc-2018Q4-base:1.3 pkgsrc-2018Q3:1.2.0.6 pkgsrc-2018Q3-base:1.2 pkgsrc-2018Q2:1.2.0.4 pkgsrc-2018Q2-base:1.2 pkgsrc-2018Q1:1.2.0.2 pkgsrc-2018Q1-base:1.2 pkgsrc-2017Q4:1.1.0.8 pkgsrc-2017Q4-base:1.1 pkgsrc-2017Q3:1.1.0.6 pkgsrc-2017Q3-base:1.1 pkgsrc-2017Q2:1.1.0.2 pkgsrc-2017Q2-base:1.1; locks; strict; comment @# @; 1.4 date 2020.05.06.11.16.45; author jperkin; state Exp; branches; next 1.3; commitid Nh5q5ZvZ9lnEEa7C; 1.3 date 2018.12.18.11.48.33; author adam; state Exp; branches; next 1.2; commitid 9tiOKInXTnqR5h4B; 1.2 date 2018.02.02.16.00.33; author fhajny; state Exp; branches; next 1.1; commitid x6gMy9MH1DU8KipA; 1.1 date 2017.04.21.09.14.01; author fhajny; state Exp; branches; next ; commitid eFdKDOtBJfZ3InOz; desc @@ 1.4 log @*: Remove manual page entries from ALTERNATIVES files. Thes are not supported by pkg_alternatives, and lead to breakage as found in . In many cases these were unnecessary anyway, as they match the corresponding command that pkg_alternatives will have automatically detected manual page entries for, plus many of them did not support PKGMANDIR. In the one case (databases/py-peewee) where the manual page does not match the command name, pkg_alternatives will need to be enhanced to support this before it can be re-enabled. @ text @bin/pwiz @@PREFIX@@/bin/pwiz-@@PYVERSSUFFIX@@ @ 1.3 log @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. @ text @a1 1 @@PKGMANDIR@@/man1/peewee.1 @@PREFIX@@/@@PKGMANDIR@@/man1/peewee-@@PYVERSSUFFIX@@.1 @ 1.2 log @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 @ text @d1 2 a2 2 bin/pwiz @@PREFIX@@/bin/pwiz@@PYVERSSUFFIX@@ @@PKGMANDIR@@/man1/peewee.1 @@PREFIX@@/@@PKGMANDIR@@/man1/peewee@@PYVERSSUFFIX@@.1 @ 1.1 log @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.). @ text @a0 1 bin/pskel @@PREFIX@@/bin/pskel@@PYVERSSUFFIX@@ @