Updated py-sqlparse to 0.2.0.

Release 0.2.0 (Jul 20, 2016)
----------------------------

IMPORTANT: The supported Python versions have changed with this release.
sqlparse 0.2.x supports Python 2.7 and Python >= 3.3.

Thanks to the many contributors for writing bug reports and working
on pull requests who made this version possible!

Internal Changes

* sqlparse.SQLParseError was removed from top-level module and moved to
  sqlparse.exceptions.
* sqlparse.sql.Token.to_unicode was removed.
* The signature of a filter's process method has changed from
  process(stack, stream) -> to process(stream). Stack was never used at
  all.
* Lots of code cleanups and modernization (thanks esp. to vmuriart!).
* Improved grouping performance. (sjoerdjob)

Enhancements

* Support WHILE loops (issue215, by shenlongxing).
* Better support for CTEs (issue217, by Andrew Tipton).
* Recognize USING as a keyword more consistently (issue236, by koljonen).
* Improve alignment of columns (issue207, issue235, by vmuriat).
* Add wrap_after option for better alignment when formatting
  lists (issue248, by Dennis Taylor).
* Add reindent-aligned option for alternate formatting (Adam Greenhall)
* Improved grouping of operations (issue211, by vmuriat).

Bug Fixes

* Leading whitespaces are now removed when format() is called with
  strip_whitespace=True (issue213, by shenlongxing).
* Fix typo in keywords list (issue229, by cbeloni).
* Fix parsing of functions in comparisons (issue230, by saaj).
* Fix grouping of identifiers (issue233).
* Fix parsing of CREATE TABLE statements (issue242, by Tenghuan).
* Minor bug fixes (issue101).
* Improve formatting of CASE WHEN constructs (issue164, by vmuriat).


Release 0.1.19 (Mar 07, 2016)
-----------------------------

Bug Fixes

* Fix IndexError when statement contains WITH clauses (issue205).

Release 0.1.18 (Oct 25, 2015)
-----------------------------

Bug Fixes

* Remove universal wheel support, added in 0.1.17 by mistake.


Release 0.1.17 (Oct 24, 2015)
-----------------------------

Enhancements

* Speed up parsing of large SQL statements (pull request: issue201, fixes the
  following issues: issue199, issue135, issue62, issue41, by Ryan Wooden).

Bug Fixes

* Fix another splitter bug regarding DECLARE (issue194).

Misc

* Packages on PyPI are signed from now on.


Release 0.1.16 (Jul 26, 2015)
-----------------------------

Bug Fixes

* Fix a regression in get_alias() introduced in 0.1.15 (issue185).
* Fix a bug in the splitter regarding DECLARE (issue193).
* sqlformat command line tool doesn't duplicat newlines anymore (issue191).
* Don't mix up MySQL comments starting with hash and MSSQL
  temp tables (issue192).
* Statement.get_type() now ignores comments at the beginning of
  a statement (issue186).


Release 0.1.15 (Apr 15, 2015)
-----------------------------

Bug Fixes

* Fix a regression for identifiers with square bracktes
  notation (issue153, by darikg).
* Add missing SQL types (issue154, issue155, issue156, by jukebox).
* Fix parsing of multi-line comments (issue172, by JacekPliszka).
* Fix parsing of escaped backslashes (issue174, by caseyching).
* Fix parsing of identifiers starting with underscore (issue175).
* Fix misinterpretation of IN keyword (issue183).

Enhancements

* Improve formatting of HAVING statements.
* Improve parsing of inline comments (issue163).
* Group comments to parent object (issue128, issue160).
* Add double precision builtin (issue169, by darikg).
* Add support for square bracket array indexing (issue170, issue176,
  issue177 by darikg).
* Improve grouping of aliased elements (issue167, by darikg).
* Support comments starting with '#' character (issue178).

4 files changed, 53 insertions, 21 deletions

diff --git a/databases/py-sqlparse/ALTERNATIVES b/databases/py-sqlparse/ALTERNATIVES
new file mode 100644
index 00000000000..db2912233fc
--- /dev/null
+++ b/databases/py-sqlparse/ALTERNATIVES
@@ -0,0 +1 @@
+bin/sqlformat @PREFIX@/bin/sqlformat-@PYVERSSUFFIX@
diff --git a/databases/py-sqlparse/Makefile b/databases/py-sqlparse/Makefile
index 2f794203656..f35c659e63e 100644
--- a/databases/py-sqlparse/Makefile
+++ b/databases/py-sqlparse/Makefile
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.8 2016/06/08 17:43:21 wiz Exp $
+# $NetBSD: Makefile,v 1.9 2016/10/19 14:02:11 wiz Exp $
 
-DISTNAME=	sqlparse-0.1.14
+DISTNAME=	sqlparse-0.2.0
 PKGNAME=	${PYPKGPREFIX}-${DISTNAME}
 CATEGORIES=	databases
 MASTER_SITES=	${MASTER_SITE_PYPI:=s/sqlparse/}
@@ -12,5 +12,11 @@ LICENSE=	modified-bsd
 
 USE_LANGUAGES=	# none
 
+# TEST_DEPENDS
+BUILD_DEPENDS+=	${PYPKGPREFIX}-test-[0-9]*:../../devel/py-test
+
+post-install:
+	cd ${DESTDIR}${PREFIX}/bin && mv sqlformat sqlformat-${PYVERSSUFFIX}
+
 .include "../../lang/python/egg.mk"
 .include "../../mk/bsd.pkg.mk"
diff --git a/databases/py-sqlparse/PLIST b/databases/py-sqlparse/PLIST
index f0e4f73d9db..2ba4f6cab53 100644
--- a/databases/py-sqlparse/PLIST
+++ b/databases/py-sqlparse/PLIST
@@ -1,42 +1,67 @@
-@comment $NetBSD: PLIST,v 1.1 2013/09/30 17:24:18 wiz Exp $
-bin/sqlformat
+@comment $NetBSD: PLIST,v 1.2 2016/10/19 14:02:11 wiz Exp $
+bin/sqlformat-${PYVERSSUFFIX}
 ${PYSITELIB}/${EGG_INFODIR}/PKG-INFO
 ${PYSITELIB}/${EGG_INFODIR}/SOURCES.txt
 ${PYSITELIB}/${EGG_INFODIR}/dependency_links.txt
+${PYSITELIB}/${EGG_INFODIR}/entry_points.txt
 ${PYSITELIB}/${EGG_INFODIR}/top_level.txt
 ${PYSITELIB}/sqlparse/__init__.py
 ${PYSITELIB}/sqlparse/__init__.pyc
 ${PYSITELIB}/sqlparse/__init__.pyo
+${PYSITELIB}/sqlparse/__main__.py
+${PYSITELIB}/sqlparse/__main__.pyc
+${PYSITELIB}/sqlparse/__main__.pyo
+${PYSITELIB}/sqlparse/cli.py
+${PYSITELIB}/sqlparse/cli.pyc
+${PYSITELIB}/sqlparse/cli.pyo
+${PYSITELIB}/sqlparse/compat.py
+${PYSITELIB}/sqlparse/compat.pyc
+${PYSITELIB}/sqlparse/compat.pyo
 ${PYSITELIB}/sqlparse/engine/__init__.py
 ${PYSITELIB}/sqlparse/engine/__init__.pyc
 ${PYSITELIB}/sqlparse/engine/__init__.pyo
-${PYSITELIB}/sqlparse/engine/filter.py
-${PYSITELIB}/sqlparse/engine/filter.pyc
-${PYSITELIB}/sqlparse/engine/filter.pyo
+${PYSITELIB}/sqlparse/engine/filter_stack.py
+${PYSITELIB}/sqlparse/engine/filter_stack.pyc
+${PYSITELIB}/sqlparse/engine/filter_stack.pyo
 ${PYSITELIB}/sqlparse/engine/grouping.py
 ${PYSITELIB}/sqlparse/engine/grouping.pyc
 ${PYSITELIB}/sqlparse/engine/grouping.pyo
+${PYSITELIB}/sqlparse/engine/statement_splitter.py
+${PYSITELIB}/sqlparse/engine/statement_splitter.pyc
+${PYSITELIB}/sqlparse/engine/statement_splitter.pyo
 ${PYSITELIB}/sqlparse/exceptions.py
 ${PYSITELIB}/sqlparse/exceptions.pyc
 ${PYSITELIB}/sqlparse/exceptions.pyo
-${PYSITELIB}/sqlparse/filters.py
-${PYSITELIB}/sqlparse/filters.pyc
-${PYSITELIB}/sqlparse/filters.pyo
+${PYSITELIB}/sqlparse/filters/__init__.py
+${PYSITELIB}/sqlparse/filters/__init__.pyc
+${PYSITELIB}/sqlparse/filters/__init__.pyo
+${PYSITELIB}/sqlparse/filters/aligned_indent.py
+${PYSITELIB}/sqlparse/filters/aligned_indent.pyc
+${PYSITELIB}/sqlparse/filters/aligned_indent.pyo
+${PYSITELIB}/sqlparse/filters/others.py
+${PYSITELIB}/sqlparse/filters/others.pyc
+${PYSITELIB}/sqlparse/filters/others.pyo
+${PYSITELIB}/sqlparse/filters/output.py
+${PYSITELIB}/sqlparse/filters/output.pyc
+${PYSITELIB}/sqlparse/filters/output.pyo
+${PYSITELIB}/sqlparse/filters/reindent.py
+${PYSITELIB}/sqlparse/filters/reindent.pyc
+${PYSITELIB}/sqlparse/filters/reindent.pyo
+${PYSITELIB}/sqlparse/filters/right_margin.py
+${PYSITELIB}/sqlparse/filters/right_margin.pyc
+${PYSITELIB}/sqlparse/filters/right_margin.pyo
+${PYSITELIB}/sqlparse/filters/tokens.py
+${PYSITELIB}/sqlparse/filters/tokens.pyc
+${PYSITELIB}/sqlparse/filters/tokens.pyo
 ${PYSITELIB}/sqlparse/formatter.py
 ${PYSITELIB}/sqlparse/formatter.pyc
 ${PYSITELIB}/sqlparse/formatter.pyo
-${PYSITELIB}/sqlparse/functions.py
-${PYSITELIB}/sqlparse/functions.pyc
-${PYSITELIB}/sqlparse/functions.pyo
 ${PYSITELIB}/sqlparse/keywords.py
 ${PYSITELIB}/sqlparse/keywords.pyc
 ${PYSITELIB}/sqlparse/keywords.pyo
 ${PYSITELIB}/sqlparse/lexer.py
 ${PYSITELIB}/sqlparse/lexer.pyc
 ${PYSITELIB}/sqlparse/lexer.pyo
-${PYSITELIB}/sqlparse/pipeline.py
-${PYSITELIB}/sqlparse/pipeline.pyc
-${PYSITELIB}/sqlparse/pipeline.pyo
 ${PYSITELIB}/sqlparse/sql.py
 ${PYSITELIB}/sqlparse/sql.pyc
 ${PYSITELIB}/sqlparse/sql.pyo
diff --git a/databases/py-sqlparse/distinfo b/databases/py-sqlparse/distinfo
index 98fe8be253d..950d29fd767 100644
--- a/databases/py-sqlparse/distinfo
+++ b/databases/py-sqlparse/distinfo
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.8 2015/11/03 01:56:28 agc Exp $
+$NetBSD: distinfo,v 1.9 2016/10/19 14:02:11 wiz Exp $
 
-SHA1 (sqlparse-0.1.14.tar.gz) = 117db829bed1ed002717456b8d4516ed522dbd4d
-RMD160 (sqlparse-0.1.14.tar.gz) = d159549be95372f4ccfff9067d6a953883eda2d9
-SHA512 (sqlparse-0.1.14.tar.gz) = 212f0dc1f05057f44cb441c2b0d29a597a826c3170ec87276a74c79f5d445cf736cfcbf8ff7cfe40c252416bba9851ce4a4739418627172ac41d98e6835668c6
-Size (sqlparse-0.1.14.tar.gz) = 55307 bytes
+SHA1 (sqlparse-0.2.0.tar.gz) = 97bcb1e3414478cd0847f197580b36aed19b00b1
+RMD160 (sqlparse-0.2.0.tar.gz) = f14d6ef20abcf7789c85bc712bebfd324e522bce
+SHA512 (sqlparse-0.2.0.tar.gz) = 4fe1d4037bee321bdeb83a186a59fa98b0f01568c77ee8845bba081e287866d1fee850a2adaac6950d4d8c089f1e70ff9bce0db94e95560a1138ea134bc26176
+Size (sqlparse-0.2.0.tar.gz) = 52554 bytes