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

4 files changed, 30 insertions, 9 deletions

diff --git a/databases/py-peewee/ALTERNATIVES b/databases/py-peewee/ALTERNATIVES
new file mode 100644
index 00000000000..b2e372d10aa
--- /dev/null
+++ b/databases/py-peewee/ALTERNATIVES
@@ -0,0 +1,3 @@
+bin/pskel @PREFIX@/bin/pskel@PYVERSSUFFIX@
+bin/pwiz @PREFIX@/bin/pwiz@PYVERSSUFFIX@
+@PKGMANDIR@/man1/peewee.1 @PREFIX@/@PKGMANDIR@/man1/peewee@PYVERSSUFFIX@.1
diff --git a/databases/py-peewee/Makefile b/databases/py-peewee/Makefile
index 0a2f45a62d8..06706e45ed6 100644
--- a/databases/py-peewee/Makefile
+++ b/databases/py-peewee/Makefile
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.14 2016/10/26 14:28:16 fhajny Exp $
+# $NetBSD: Makefile,v 1.15 2017/04/21 09:14:01 fhajny Exp $
 
-DISTNAME=	peewee-2.8.5
+DISTNAME=	peewee-2.9.2
 PKGNAME=	${PYPKGPREFIX}-${DISTNAME}
 CATEGORIES=	databases
 MASTER_SITES=	${MASTER_SITE_GITHUB:=coleifer/}
@@ -15,6 +15,9 @@ GITHUB_PROJECT=	peewee
 USE_LANGUAGES=	c
 USE_TOOLS+=	bash
 
+BUILD_DEPENDS+=	${PYPKGPREFIX}-sphinx-[0-9]*:../../textproc/py-sphinx
+
+FILES_SUBST+=	PKGMANDIR=${PKGMANDIR}
 MESSAGE_SUBST+=	PYPKGPREFIX=${PYPKGPREFIX}
 
 REPLACE_BASH+=		playhouse/berkeley_build.sh
@@ -22,6 +25,19 @@ REPLACE_PYTHON+=	pwiz.py
 
 PYDISTUTILSPKG=		yes
 
+INSTALLATION_DIRS+=	${PKGMANDIR}/man1
+
+post-build:
+	cd ${WRKSRC}/docs && ${BUILD_MAKE_CMD} man
+
+post-install:
+	${MV} ${DESTDIR}${PREFIX}/bin/pskel \
+		${DESTDIR}${PREFIX}/bin/pskel${PYVERSSUFFIX}
+	${MV} ${DESTDIR}${PREFIX}/bin/pwiz.py \
+		${DESTDIR}${PREFIX}/bin/pwiz${PYVERSSUFFIX}
+	${INSTALL_MAN} ${WRKSRC}/docs/_build/man/peewee.1 \
+		${DESTDIR}${PREFIX}/${PKGMANDIR}/man1/peewee${PYVERSSUFFIX}.1
+
 .include "../../devel/py-cython/buildlink3.mk"
 .include "../../lang/python/application.mk"
 .include "../../lang/python/extension.mk"
diff --git a/databases/py-peewee/PLIST b/databases/py-peewee/PLIST
index d67967ab672..3b24ff20635 100644
--- a/databases/py-peewee/PLIST
+++ b/databases/py-peewee/PLIST
@@ -1,5 +1,6 @@
-@comment $NetBSD: PLIST,v 1.11 2016/10/26 14:28:16 fhajny Exp $
-bin/pwiz.py
+@comment $NetBSD: PLIST,v 1.12 2017/04/21 09:14:01 fhajny Exp $
+bin/pskel${PYVERSSUFFIX}
+bin/pwiz${PYVERSSUFFIX}
 ${PYSITELIB}/peewee.py
 ${PYSITELIB}/peewee.pyc
 ${PYSITELIB}/peewee.pyo
@@ -84,3 +85,4 @@ ${PYSITELIB}/playhouse/test_utils.pyo
 ${PYSITELIB}/pwiz.py
 ${PYSITELIB}/pwiz.pyc
 ${PYSITELIB}/pwiz.pyo
+man/man1/peewee${PYVERSSUFFIX}.1
diff --git a/databases/py-peewee/distinfo b/databases/py-peewee/distinfo
index fe21d1a8cec..49d8717accf 100644
--- a/databases/py-peewee/distinfo
+++ b/databases/py-peewee/distinfo
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.14 2016/10/26 14:28:16 fhajny Exp $
+$NetBSD: distinfo,v 1.15 2017/04/21 09:14:01 fhajny Exp $
 
-SHA1 (peewee-2.8.5.tar.gz) = b3bc6b2c80897f02567a94c8dbf8b0e645faf843
-RMD160 (peewee-2.8.5.tar.gz) = 406c35612c56c65718d3212747aa3bc81b00857f
-SHA512 (peewee-2.8.5.tar.gz) = cdb7c4240844ff43ce92cf652e8bd8e5e6b0dae3bb29dbb035e6554aeabfcc9a6dacf96135fa6712a4f4f6d6e354cd8b79d68543fb3bba89a7434ac259eaf197
-Size (peewee-2.8.5.tar.gz) = 645471 bytes
+SHA1 (peewee-2.9.2.tar.gz) = f82d1e46d5561b1aa8da89b4af7fb36c0badacab
+RMD160 (peewee-2.9.2.tar.gz) = cf27168cd442eae3bd8a92c546cbf22b6a9da57b
+SHA512 (peewee-2.9.2.tar.gz) = 913b930c91ac96440ad3d7b2f5b227d3ff6e49d3c62e7fc0b6a60e65e3170d0891217c6449415211405209e1bf86245fdac9f70dc1d25268fd50f5b209debfed
+Size (peewee-2.9.2.tar.gz) = 655434 bytes