CVS commit: pkgsrc/databases/py-sqlparse

To: pkgsrc-changes%NetBSD.org@localhost
Subject: CVS commit: pkgsrc/databases/py-sqlparse
From: "Adam Ciarcinski" <adam%netbsd.org@localhost>
Date: Thu, 7 Sep 2023 15:46:23 +0000

Module Name:    pkgsrc
Committed By:   adam
Date:           Thu Sep  7 15:46:23 UTC 2023

Modified Files:
        pkgsrc/databases/py-sqlparse: Makefile PLIST distinfo

Log Message:
py-sqlparse: updated to 0.4.4

Release 0.4.4 (Apr 18, 2023)
----------------------------

Notable Changes

* IMPORTANT: This release fixes a security vulnerability in the
  parser where a regular expression vulnerable to ReDOS (Regular
  Expression Denial of Service) was used. See the security advisory
  for details: https://github.com/andialbrecht/sqlparse/security/advisories/GHSA-rrm6-wvj7-cwh2
  The vulnerability was discovered by @erik-krogh from GitHub
  Security Lab (GHSL). Thanks for reporting!

Bug Fixes

* Revert a change from 0.4.0 that changed IN to be a comparison (issue694).
  The primary expectation is that IN is treated as a keyword and not as a
  comparison operator. That also follows the definition of reserved keywords
  for the major SQL syntax definitions.
* Fix regular expressions for string parsing.

Other

* sqlparse now uses pyproject.toml instead of setup.cfg (issue685).

Release 0.4.3 (Sep 23, 2022)
----------------------------

Enhancements

* Add support for DIV operator (pr664, by chezou).
* Add support for additional SPARK keywords (pr643, by mrmasterplan).
* Avoid tokens copy (pr622, by living180).
* Add REGEXP as a comparision (pr647, by PeterSandwich).
* Add DISTINCTROW keyword for MS Access (issue677).
* Improve parsing of CREATE TABLE AS SELECT (pr662, by chezou).

Bug Fixes

* Fix spelling of INDICATOR keyword (pr653, by ptld).
* Fix formatting error in EXTRACT function (issue562, issue670, pr676, by ecederstrand).
* Fix bad parsing of create table statements that use lower case (issue217, pr642, by mrmasterplan).
* Handle backtick as valid quote char (issue628, pr629, by codenamelxl).
* Allow any unicode character as valid identifier name (issue641).

Other

* Update github actions to test on Python 3.10 as well (pr661, by cclaus).

Release 0.4.2 (Sep 10, 2021)
----------------------------

Notable Changes

* IMPORTANT: This release fixes a security vulnerability in the
  strip comments filter. In this filter a regular expression that was
  vulnerable to ReDOS (Regular Expression Denial of Service) was
  used. See the security advisory for details: https://github.com/andialbrecht/sqlparse/security/advisories/GHSA-p5w8-wqhj-9hhf
  The vulnerability was discovered by @erik-krogh and @yoff from
  GitHub Security Lab (GHSL). Thanks for reporting!

Enhancements

* Add ELSIF as keyword (issue584).
* Add CONFLICT and ON_ERROR_STOP keywords (pr595, by j-martin).

Bug Fixes

* Fix parsing of backticks (issue588).
* Fix parsing of scientific number (issue399).

Release 0.4.1 (Oct 08, 2020)
----------------------------

Bug Fixes

* Just removed a debug print statement, sorry...

Release 0.4.0 (Oct 07, 2020)
----------------------------

Notable Changes

* Remove support for end-of-life Python 2.7 and 3.4. Python 3.5+ is now
  required.
* Remaining strings that only consist of whitespaces are not treated as
  statements anymore. Code that ignored the last element from
  sqlparse.split() should be updated accordingly since that function
  now doesn't return an empty string as the last element in some
  cases (issue496).

Enhancements

* Add WINDOW keyword (pr579 by ali-tny).
* Add RLIKE keyword (pr582 by wjones1).

Bug Fixes

* Improved parsing of IN(...) statements (issue566, pr567 by hurcy).
* Preserve line breaks when removing comments (issue484).
* Fix parsing error when using square bracket notation (issue583).
* Fix splitting when using DECLARE ... HANDLER (issue581).
* Fix splitting of statements using CASE ... WHEN (issue580).
* Improve formatting of type casts in parentheses.
* Stabilize formatting of invalid SQL statements.


To generate a diff of this commit:
cvs rdiff -u -r1.21 -r1.22 pkgsrc/databases/py-sqlparse/Makefile
cvs rdiff -u -r1.2 -r1.3 pkgsrc/databases/py-sqlparse/PLIST
cvs rdiff -u -r1.17 -r1.18 pkgsrc/databases/py-sqlparse/distinfo

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.

Modified files:

Index: pkgsrc/databases/py-sqlparse/Makefile
diff -u pkgsrc/databases/py-sqlparse/Makefile:1.21 pkgsrc/databases/py-sqlparse/Makefile:1.22
--- pkgsrc/databases/py-sqlparse/Makefile:1.21  Tue Jun  6 12:40:34 2023
+++ pkgsrc/databases/py-sqlparse/Makefile       Thu Sep  7 15:46:23 2023
@@ -1,8 +1,7 @@
-# $NetBSD: Makefile,v 1.21 2023/06/06 12:40:34 riastradh Exp $
+# $NetBSD: Makefile,v 1.22 2023/09/07 15:46:23 adam Exp $
 
-DISTNAME=      sqlparse-0.3.1
+DISTNAME=      sqlparse-0.4.4
 PKGNAME=       ${PYPKGPREFIX}-${DISTNAME}
-PKGREVISION=   2
 CATEGORIES=    databases python
 MASTER_SITES=  ${MASTER_SITE_PYPI:=s/sqlparse/}
 
@@ -11,19 +10,23 @@ HOMEPAGE=   https://github.com/andialbrech
 COMMENT=       Non-validating SQL parser
 LICENSE=       modified-bsd
 
-TOOL_DEPENDS+= ${PYPKGPREFIX}-test-runner-[0-9]*:../../devel/py-test-runner
+TOOL_DEPENDS+= ${PYPKGPREFIX}-flit_core>=3.2:../../devel/py-flit_core
+TEST_DEPENDS+= ${PYPKGPREFIX}-test-[0-9]*:../../devel/py-test
+TEST_DEPENDS+= ${PYPKGPREFIX}-test-cov-[0-9]*:../../devel/py-test-cov
 
 USE_LANGUAGES= # none
 
-PYTHON_VERSIONS_INCOMPATIBLE=  27
-
-USE_PKG_RESOURCES=     yes
+REPLACE_PYTHON+=       sqlparse/cli.py
 
-PYSETUPTESTTARGET=     pytest
+PYTHON_VERSIONS_INCOMPATIBLE=  27
 
 post-install:
        cd ${DESTDIR}${PREFIX}/bin && \
        ${MV} sqlformat sqlformat-${PYVERSSUFFIX} || ${TRUE}
 
-.include "../../lang/python/egg.mk"
+do-test:
+       cd ${WRKSRC} && ${SETENV} ${TEST_ENV} pytest-${PYVERSSUFFIX} tests
+
+.include "../../lang/python/application.mk"
+.include "../../lang/python/wheel.mk"
 .include "../../mk/bsd.pkg.mk"

Index: pkgsrc/databases/py-sqlparse/PLIST
diff -u pkgsrc/databases/py-sqlparse/PLIST:1.2 pkgsrc/databases/py-sqlparse/PLIST:1.3
--- pkgsrc/databases/py-sqlparse/PLIST:1.2      Wed Oct 19 14:02:11 2016
+++ pkgsrc/databases/py-sqlparse/PLIST  Thu Sep  7 15:46:23 2023
@@ -1,73 +1,52 @@
-@comment $NetBSD: PLIST,v 1.2 2016/10/19 14:02:11 wiz Exp $
+@comment $NetBSD: PLIST,v 1.3 2023/09/07 15:46:23 adam 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}/${WHEEL_INFODIR}/INSTALLER
+${PYSITELIB}/${WHEEL_INFODIR}/LICENSE
+${PYSITELIB}/${WHEEL_INFODIR}/METADATA
+${PYSITELIB}/${WHEEL_INFODIR}/RECORD
+${PYSITELIB}/${WHEEL_INFODIR}/REQUESTED
+${PYSITELIB}/${WHEEL_INFODIR}/WHEEL
+${PYSITELIB}/${WHEEL_INFODIR}/direct_url.json
+${PYSITELIB}/${WHEEL_INFODIR}/entry_points.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_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/__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/keywords.py
 ${PYSITELIB}/sqlparse/keywords.pyc
-${PYSITELIB}/sqlparse/keywords.pyo
 ${PYSITELIB}/sqlparse/lexer.py
 ${PYSITELIB}/sqlparse/lexer.pyc
-${PYSITELIB}/sqlparse/lexer.pyo
 ${PYSITELIB}/sqlparse/sql.py
 ${PYSITELIB}/sqlparse/sql.pyc
-${PYSITELIB}/sqlparse/sql.pyo
 ${PYSITELIB}/sqlparse/tokens.py
 ${PYSITELIB}/sqlparse/tokens.pyc
-${PYSITELIB}/sqlparse/tokens.pyo
 ${PYSITELIB}/sqlparse/utils.py
 ${PYSITELIB}/sqlparse/utils.pyc
-${PYSITELIB}/sqlparse/utils.pyo

Index: pkgsrc/databases/py-sqlparse/distinfo
diff -u pkgsrc/databases/py-sqlparse/distinfo:1.17 pkgsrc/databases/py-sqlparse/distinfo:1.18
--- pkgsrc/databases/py-sqlparse/distinfo:1.17  Tue Oct 26 10:09:53 2021
+++ pkgsrc/databases/py-sqlparse/distinfo       Thu Sep  7 15:46:23 2023
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.17 2021/10/26 10:09:53 nia Exp $
+$NetBSD: distinfo,v 1.18 2023/09/07 15:46:23 adam Exp $
 
-BLAKE2s (sqlparse-0.3.1.tar.gz) = 6caa4c8067500c48d57b68f937ce6310fceb52b572b5c6c2865c3d916daa58cd
-SHA512 (sqlparse-0.3.1.tar.gz) = 4c56a528b43578a7a48fc31cee369215b15761d9903ea1d8e034c69f0eb6431dd15362aab13af25a36fccb361436f1cba746bcbb515cbab5d30319629dd2ddfb
-Size (sqlparse-0.3.1.tar.gz) = 67572 bytes
+BLAKE2s (sqlparse-0.4.4.tar.gz) = 80ec96a4c299a7ab09ea2c76ac99b8b61065a4eab792c2985e6488aeb65e79d9
+SHA512 (sqlparse-0.4.4.tar.gz) = bb655f8de2466c2ed51aca901b6561b8ac7730bf65f1254d218d7b9dabbece609cadd8a52a092b301895ad83813ddf02691e2de49cf55a26e676a2661c240a2b
+Size (sqlparse-0.4.4.tar.gz) = 72383 bytes

Prev by Date: Re: CVS commit: pkgsrc/print/mupdf
Next by Date: CVS commit: pkgsrc/doc
Previous by Thread: CVS commit: pkgsrc/devel/py-meson_python
Next by Thread: CVS commit: pkgsrc/doc
Indexes:

Home | Main Index | Thread Index | Old Index