databases/py-sqlite2: Update to 2.8.3.

Version 2.8.3
-------------

- Fixed bug where cursor.description was an emtpy tuple instead of None for
  non-SELECT statements

Version 2.8.2
-------------

- Make sure pysqlite compiles with Visual Studio, which does not support C99
- Switch to sqlite3_open_v2. The flags parameter is now exposed. You can use it
  to modify the behaviour of the opened database connection, for example
  opening a database file in read-only mode or enable URI mode.


Version 2.8.1
-------------

BUG FIXES

- Fixed multiple refcount problems.

IMPROVEMENTS

- Added versionchanged about changed transaction behaviour wrt DDL statements
  to documentation.
- I was informed by Roger Binns that FTS5 is not stable yet. The amalgamation
  is now built with FTS3 and FTS4 instead.


Version 2.8.0
-------------

NEW FEATURES

- No new features, but tons of bugfixes. These mean that things now work that
  didn't before:
- Transactional DDL now works
- You can use SAVEPOINTs now


BUILD PROCESS

- Python 2.7.x is now required. If trying to use it with Python 3, print a
  useful error message.  Integrated all fixes from the sqlite3 module in Python
  2.7.10.


MAJOR IMPROVEMENTS

- Completety got rid of statement parsing. We now use SQLite functions to
  determine if a statement modifies the database or not. If a statement
  modifies the database, then we implicitly start a transaction. For backwards
  compatibility reasons, we do NOT implicitly start a transaction if we
  encounter a DDL statement.

  You can, however, now have transactional DDL if you want to:

    cur = con.cursor()
    cur.execute("begin")
    cur.execute("create table foo(bar)")
    con.rollback()

  This also means that people can now finally use SAVEPOINTS.

- Use sqlite3_get_autocommit() to determine if we are within a transaction
  instead of trying to be smart.

- Switch to v2 statement API. This simplified the code and will increase
  stability.

MINOR IMPROVEMENTS

- You can use unicode strings as index for Row objects.


BUGFIXES

- Fixed a regression: statements should not be reset after a commit.


GENERAL CLEANUP AND DEPRECATIONS

- Since december 2005, row_factory is a feature of the Connection class
  instead of the Cursor class.
- DEPRECATE converters and adapters.
- DEPRECATE text_factory.
- Remove compatibility workarounds for old Python versions.
- Remove workarounds for old SQLite versions.
- Remove apsw related code.


Version 2.7.0
-------------

NEW FEATURES

- The limit functionality of SQLite is now wrapped.

BUILD PROCESS

- Instead of fts3, build fts5 extension when using amalgamation.
- use pkg-config for finding SQLite if available
- Removed the download/unpacking of SQLite amalgamation files.

IMPROVEMENTS

- Use toc.db file from the SQLite web site and a custom script to make sure
  that we have all integer constants mapped to Python.
- Use Travis CI
- Added Trove classifier to make sure Python 3 users do not accidentally
  try to install it.

BUGFIXES

- Fix for parsing fractional second part of timestamps.
- Fixed bug where when using converters, empty strings ended up as None
  on the Python side.
- SQLite can cope with text with embedded NUL. We can now, too.
- many others

4 files changed, 18 insertions, 23 deletions

diff --git a/databases/py-sqlite2/Makefile b/databases/py-sqlite2/Makefile
index 2124dfa1ed7..1054cef6832 100644
--- a/databases/py-sqlite2/Makefile
+++ b/databases/py-sqlite2/Makefile
@@ -1,13 +1,12 @@
-# $NetBSD: Makefile,v 1.48 2017/11/30 16:45:18 adam Exp $
+# $NetBSD: Makefile,v 1.49 2018/04/04 11:40:34 fhajny Exp $
 
-DISTNAME=	pysqlite-2.6.3
+DISTNAME=	pysqlite-2.8.3
 PKGNAME=	${PYPKGPREFIX}-${DISTNAME:S/pysqlite/sqlite2/}
-PKGREVISION=	15
 CATEGORIES=	databases python
-#MASTER_SITES=	https://pypi.python.org/pypi/pysqlite/files/
+MASTER_SITES=	${MASTER_SITE_PYPI:=p/pysqlite/}
 
 MAINTAINER=	pkgsrc-users@NetBSD.org
-#HOMEPAGE=	https://pypi.python.org/pypi/pysqlite/
+HOMEPAGE=	http://github.com/ghaering/pysqlite/
 COMMENT=	SQLite database adapter for Python
 LICENSE=	mit
 
diff --git a/databases/py-sqlite2/PLIST b/databases/py-sqlite2/PLIST
index dd6ee8f903b..be576d0ba64 100644
--- a/databases/py-sqlite2/PLIST
+++ b/databases/py-sqlite2/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.12 2012/04/09 09:24:01 obache Exp $
+@comment $NetBSD: PLIST,v 1.13 2018/04/04 11:40:34 fhajny Exp $
 ${PYSITELIB}/${EGG_FILE}
 ${PYSITELIB}/pysqlite2/__init__.py
 ${PYSITELIB}/pysqlite2/__init__.pyc
@@ -25,12 +25,6 @@ ${PYSITELIB}/pysqlite2/test/factory.pyo
 ${PYSITELIB}/pysqlite2/test/hooks.py
 ${PYSITELIB}/pysqlite2/test/hooks.pyc
 ${PYSITELIB}/pysqlite2/test/hooks.pyo
-${PYSITELIB}/pysqlite2/test/py25/__init__.py
-${PYSITELIB}/pysqlite2/test/py25/__init__.pyc
-${PYSITELIB}/pysqlite2/test/py25/__init__.pyo
-${PYSITELIB}/pysqlite2/test/py25/py25tests.py
-${PYSITELIB}/pysqlite2/test/py25/py25tests.pyc
-${PYSITELIB}/pysqlite2/test/py25/py25tests.pyo
 ${PYSITELIB}/pysqlite2/test/regression.py
 ${PYSITELIB}/pysqlite2/test/regression.pyc
 ${PYSITELIB}/pysqlite2/test/regression.pyo
diff --git a/databases/py-sqlite2/distinfo b/databases/py-sqlite2/distinfo
index 6703c7376e2..ac1ceb5fd94 100644
--- a/databases/py-sqlite2/distinfo
+++ b/databases/py-sqlite2/distinfo
@@ -1,7 +1,7 @@
-$NetBSD: distinfo,v 1.11 2015/11/03 01:56:28 agc Exp $
+$NetBSD: distinfo,v 1.12 2018/04/04 11:40:34 fhajny Exp $
 
-SHA1 (pysqlite-2.6.3.tar.gz) = d74d7649c5a1e9fb19dfa78c28b163007468a8cf
-RMD160 (pysqlite-2.6.3.tar.gz) = a84c96b7f60daff1815ba3e455cbc6264eb3ea86
-SHA512 (pysqlite-2.6.3.tar.gz) = fe7618b9b4b764a32be94dc8abd97445e33009c8489d2b417c9677382452a5c2d176feffe8b3167eb543f89d5ed3b9b717ceef63bfb2157b3f24a539cfb89a51
-Size (pysqlite-2.6.3.tar.gz) = 74846 bytes
-SHA1 (patch-aa) = 634805bef4fc0c18c9087d3417c9d6235d8df4d8
+SHA1 (pysqlite-2.8.3.tar.gz) = 70e6ed5e771b1b584ffe23f93e3eb1ceef44895a
+RMD160 (pysqlite-2.8.3.tar.gz) = ec33a3083d8af35935c879796fce67ac0a9cf93d
+SHA512 (pysqlite-2.8.3.tar.gz) = 9bf378b47fe020b378a9bd749b2b27cefcf8018fbe715cca54004b36092d2202ed0bb7d8fb8bc9820ce16918e01cea8bd1f032c640d1c461bd99cdf2632b8e3e
+Size (pysqlite-2.8.3.tar.gz) = 80567 bytes
+SHA1 (patch-aa) = 0afccdad93c01b11ffa23ac15fbc797a73b9c97a
diff --git a/databases/py-sqlite2/patches/patch-aa b/databases/py-sqlite2/patches/patch-aa
index 6175b0192a5..5b8f21f8dd6 100644
--- a/databases/py-sqlite2/patches/patch-aa
+++ b/databases/py-sqlite2/patches/patch-aa
@@ -1,10 +1,12 @@
-$NetBSD: patch-aa,v 1.2 2010/09/16 11:31:16 adam Exp $
+$NetBSD: patch-aa,v 1.3 2018/04/04 11:40:34 fhajny Exp $
 
---- setup.py.orig	2010-09-16 10:49:08.000000000 +0000
+Ignore silly location for doc files.
+
+--- setup.py.orig	2016-03-26 16:11:47.000000000 +0000
 +++ setup.py
-@@ -175,7 +175,7 @@ def get_setup_args():
-             packages = ["pysqlite2", "pysqlite2.test"] +
-                        (["pysqlite2.test.py25"], [])[sys.version_info < (2, 5)],
+@@ -198,7 +198,7 @@ def get_setup_args():
+             package_dir = {"pysqlite2": "lib"},
+             packages = ["pysqlite2", "pysqlite2.test"],
              scripts=[],
 -            data_files = data_files,
 +#            data_files = data_files,