Updated py-psycopg2 to 2.7.

What's new in psycopg 2.7
-------------------------

New features:

- Added `~psycopg2.sql` module to generate SQL dynamically (:ticket:`#308`).
- Added :ref:`replication-support` (:ticket:`#322`). Main authors are
  Oleksandr Shulgin and Craig Ringer, who deserve a huge thank you.
- Added `~psycopg2.extensions.parse_dsn()` and
  `~psycopg2.extensions.make_dsn()` functions (:tickets:`#321, #363`).
  `~psycopg2.connect()` now can take both *dsn* and keyword arguments, merging
  them together.
- Added `~psycopg2.__libpq_version__` and
  `~psycopg2.extensions.libpq_version()` to inspect the version of the
  ``libpq`` library the module was compiled/loaded with
  (:tickets:`#35, #323`).
- The attributes `~connection.notices` and `~connection.notifies` can be
  customized replacing them with any object exposing an `!append()` method
  (:ticket:`#326`).
- Adapt network types to `ipaddress` objects when available. When not
  enabled, convert arrays of network types to lists by default. The old `!Inet`
  adapter is deprecated (:tickets:`#317, #343, #387`).
- Added `~psycopg2.extensions.quote_ident()` function (:ticket:`#359`).
- Added `~connection.get_dsn_parameters()` connection method (:ticket:`#364`).
- `~cursor.callproc()` now accepts a dictionary of parameters (:ticket:`#381`).
- Give precedence to `!__conform__()` over superclasses to choose an object
  adapter (:ticket:`#456`).
- Using Python C API decoding functions and codecs caching for faster
  unicode encoding/decoding (:ticket:`#473`).
- `~cursor.executemany()` slowness addressed by
  `~psycopg2.extras.execute_batch()` and `~psycopg2.extras.execute_values()`
  (:ticket:`#491`).
- Added ``async_`` as an alias for ``async`` to support Python 3.7 where
  ``async`` will become a keyword (:ticket:`#495`).
- Unless in autocommit, do not use :sql:`default_transaction_*` settings to
  control the session characteristics as it may create problems with external
  connection pools such as pgbouncer; use :sql:`BEGIN` options instead
  (:ticket:`#503`).
- `~connection.isolation_level` is now writable and entirely separated from
  `~connection.autocommit`; added `~connection.readonly`,
  `~connection.deferrable` writable attributes.

Bug fixes:

- Fixed error caused by missing decoding `~psycopg2.extras.LoggingConnection`
  (:ticket:`#483`).
- Fixed integer overflow in :sql:`interval` seconds (:ticket:`#512`).

Other changes:

- Dropped support for Python 2.5 and 3.1.
- Dropped support for client library older than PostgreSQL 9.1 (but older
  server versions are still supported).
- `~connection.isolation_level` doesn't read from the database but will return
  `~psycopg2.extensions.ISOLATION_LEVEL_DEFAULT` if no value was set on the
  connection.
- Empty arrays no more converted into lists if they don't have a type attached
  (:ticket:`#506`)

3 files changed, 30 insertions, 10 deletions

diff --git a/databases/py-psycopg2/Makefile b/databases/py-psycopg2/Makefile
index f388b084650..3b8eb38ce37 100644
--- a/databases/py-psycopg2/Makefile
+++ b/databases/py-psycopg2/Makefile
@@ -1,10 +1,9 @@
-# $NetBSD: Makefile,v 1.33 2016/10/09 21:41:57 wiz Exp $
+# $NetBSD: Makefile,v 1.34 2017/03/05 14:19:07 wiz Exp $
 
-DISTNAME=	psycopg2-2.6.2
+DISTNAME=	psycopg2-2.7
 PKGNAME=	${PYPKGPREFIX}-${DISTNAME}
-PKGREVISION=	2
 CATEGORIES=	databases python
-MASTER_SITES=	http://initd.org/psycopg/tarballs/PSYCOPG-2-6/
+MASTER_SITES=	http://initd.org/psycopg/tarballs/PSYCOPG-2-7/
 
 MAINTAINER=	joerg@NetBSD.org
 HOMEPAGE=	http://initd.org/psycopg/
diff --git a/databases/py-psycopg2/PLIST b/databases/py-psycopg2/PLIST
index a4367263d0b..809dbeb78f4 100644
--- a/databases/py-psycopg2/PLIST
+++ b/databases/py-psycopg2/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.10 2016/07/24 19:44:16 wiz Exp $
+@comment $NetBSD: PLIST,v 1.11 2017/03/05 14:19:07 wiz Exp $
 ${PYSITELIB}/${EGG_INFODIR}/PKG-INFO
 ${PYSITELIB}/${EGG_INFODIR}/SOURCES.txt
 ${PYSITELIB}/${EGG_INFODIR}/dependency_links.txt
@@ -6,6 +6,9 @@ ${PYSITELIB}/${EGG_INFODIR}/top_level.txt
 ${PYSITELIB}/psycopg2/__init__.py
 ${PYSITELIB}/psycopg2/__init__.pyc
 ${PYSITELIB}/psycopg2/__init__.pyo
+${PYSITELIB}/psycopg2/_ipaddress.py
+${PYSITELIB}/psycopg2/_ipaddress.pyc
+${PYSITELIB}/psycopg2/_ipaddress.pyo
 ${PYSITELIB}/psycopg2/_json.py
 ${PYSITELIB}/psycopg2/_json.pyc
 ${PYSITELIB}/psycopg2/_json.pyo
@@ -28,6 +31,9 @@ ${PYSITELIB}/psycopg2/pool.pyo
 ${PYSITELIB}/psycopg2/psycopg1.py
 ${PYSITELIB}/psycopg2/psycopg1.pyc
 ${PYSITELIB}/psycopg2/psycopg1.pyo
+${PYSITELIB}/psycopg2/sql.py
+${PYSITELIB}/psycopg2/sql.pyc
+${PYSITELIB}/psycopg2/sql.pyo
 ${PYSITELIB}/psycopg2/tests/__init__.py
 ${PYSITELIB}/psycopg2/tests/__init__.pyc
 ${PYSITELIB}/psycopg2/tests/__init__.pyo
@@ -40,6 +46,9 @@ ${PYSITELIB}/psycopg2/tests/dbapi20_tpc.pyo
 ${PYSITELIB}/psycopg2/tests/test_async.py
 ${PYSITELIB}/psycopg2/tests/test_async.pyc
 ${PYSITELIB}/psycopg2/tests/test_async.pyo
+${PYSITELIB}/psycopg2/tests/test_async_keyword.py
+${PYSITELIB}/psycopg2/tests/test_async_keyword.pyc
+${PYSITELIB}/psycopg2/tests/test_async_keyword.pyo
 ${PYSITELIB}/psycopg2/tests/test_bugX000.py
 ${PYSITELIB}/psycopg2/tests/test_bugX000.pyc
 ${PYSITELIB}/psycopg2/tests/test_bugX000.pyo
@@ -67,9 +76,15 @@ ${PYSITELIB}/psycopg2/tests/test_errcodes.pyo
 ${PYSITELIB}/psycopg2/tests/test_extras_dictcursor.py
 ${PYSITELIB}/psycopg2/tests/test_extras_dictcursor.pyc
 ${PYSITELIB}/psycopg2/tests/test_extras_dictcursor.pyo
+${PYSITELIB}/psycopg2/tests/test_fast_executemany.py
+${PYSITELIB}/psycopg2/tests/test_fast_executemany.pyc
+${PYSITELIB}/psycopg2/tests/test_fast_executemany.pyo
 ${PYSITELIB}/psycopg2/tests/test_green.py
 ${PYSITELIB}/psycopg2/tests/test_green.pyc
 ${PYSITELIB}/psycopg2/tests/test_green.pyo
+${PYSITELIB}/psycopg2/tests/test_ipaddress.py
+${PYSITELIB}/psycopg2/tests/test_ipaddress.pyc
+${PYSITELIB}/psycopg2/tests/test_ipaddress.pyo
 ${PYSITELIB}/psycopg2/tests/test_lobject.py
 ${PYSITELIB}/psycopg2/tests/test_lobject.pyc
 ${PYSITELIB}/psycopg2/tests/test_lobject.pyo
@@ -85,6 +100,12 @@ ${PYSITELIB}/psycopg2/tests/test_psycopg2_dbapi20.pyo
 ${PYSITELIB}/psycopg2/tests/test_quote.py
 ${PYSITELIB}/psycopg2/tests/test_quote.pyc
 ${PYSITELIB}/psycopg2/tests/test_quote.pyo
+${PYSITELIB}/psycopg2/tests/test_replication.py
+${PYSITELIB}/psycopg2/tests/test_replication.pyc
+${PYSITELIB}/psycopg2/tests/test_replication.pyo
+${PYSITELIB}/psycopg2/tests/test_sql.py
+${PYSITELIB}/psycopg2/tests/test_sql.pyc
+${PYSITELIB}/psycopg2/tests/test_sql.pyo
 ${PYSITELIB}/psycopg2/tests/test_transaction.py
 ${PYSITELIB}/psycopg2/tests/test_transaction.pyc
 ${PYSITELIB}/psycopg2/tests/test_transaction.pyo
diff --git a/databases/py-psycopg2/distinfo b/databases/py-psycopg2/distinfo
index 7392432ca6e..db101ded50f 100644
--- a/databases/py-psycopg2/distinfo
+++ b/databases/py-psycopg2/distinfo
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.23 2016/07/21 12:53:20 wiz Exp $
+$NetBSD: distinfo,v 1.24 2017/03/05 14:19:07 wiz Exp $
 
-SHA1 (psycopg2-2.6.2.tar.gz) = 9964686caa8759b9eedfbc4f73e1e2665f6b6d7e
-RMD160 (psycopg2-2.6.2.tar.gz) = f9b73dd247d2caa97f08b8730798d9f6f4ae9dd1
-SHA512 (psycopg2-2.6.2.tar.gz) = 614314b5ab7ab5fa7c5e9c4f861579f90bd73521a9964dcb5a0938f77a9d6dfbea689cef35ad399cda698a45bb736c315912cb5dca85a52132f011d79f4863ac
-Size (psycopg2-2.6.2.tar.gz) = 376348 bytes
+SHA1 (psycopg2-2.7.tar.gz) = 060c1b19dd0e1037ef958dfee1998ee0f9abb6f5
+RMD160 (psycopg2-2.7.tar.gz) = 7315c887eb1859f4ca67b24f870595b31f753604
+SHA512 (psycopg2-2.7.tar.gz) = 6e8923767960fc1fbd03623030005d6cbb2a0c98a51e6681622aa86903c22ea9d4827238a1ce1c9fbd2140c3eccd0c421a89ad5810b7e8577618e5a61e395b42
+Size (psycopg2-2.7.tar.gz) = 421773 bytes