On Thu, Nov 02, 2017 at 09:34:14AM +0100, Sebastien Marie wrote:
> Hi,
>
> The following diff updates py-sql from 0.8 to 0.9.
ping
> ChangeLog: Version 0.9 - 2017-04-24
> - Add distinct_on on Select
> - Allow to use Select as Column of Select query
> - Support Select without from clause
>
> I also added python3 flavor.
>
> Thanks.
> --
> Sebastien Marie
>
>
> Index: Makefile
> ===================================================================
> RCS file: /cvs/ports/databases/py-sql/Makefile,v
> retrieving revision 1.7
> diff -u -p -r1.7 Makefile
> --- Makefile 8 Jan 2016 13:07:34 -0000 1.7
> +++ Makefile 2 Nov 2017 08:31:47 -0000
> @@ -2,10 +2,9 @@
>
> COMMENT= library to write SQL queries
>
> -MODPY_EGG_VERSION = 0.8
> +MODPY_EGG_VERSION = 0.9
> DISTNAME= python-sql-${MODPY_EGG_VERSION}
> PKGNAME= py-sql-${MODPY_EGG_VERSION}
> -REVISION= 1
>
> CATEGORIES= databases
>
> @@ -17,5 +16,8 @@ PERMIT_PACKAGE_CDROM= Yes
> MODULES= lang/python
>
> MODPY_SETUPTOOLS= Yes
> +
> +FLAVOR?=
> +FLAVORS= python3
>
> .include <bsd.port.mk>
> Index: distinfo
> ===================================================================
> RCS file: /cvs/ports/databases/py-sql/distinfo,v
> retrieving revision 1.3
> diff -u -p -r1.3 distinfo
> --- distinfo 21 Sep 2015 08:32:35 -0000 1.3
> +++ distinfo 2 Nov 2017 08:31:47 -0000
> @@ -1,2 +1,2 @@
> -SHA256 (python-sql-0.8.tar.gz) = Ag7XjnfwMh8w5A9OMW6USySjuZXOavbuwtjhrtNIM3Y=
> -SIZE (python-sql-0.8.tar.gz) = 29853
> +SHA256 (python-sql-0.9.tar.gz) = B7Ucwcl371SA/mccrlB1rUtopvxn9FaXguBvASRW01w=
> +SIZE (python-sql-0.9.tar.gz) = 30219
> Index: pkg/PLIST
> ===================================================================
> RCS file: /cvs/ports/databases/py-sql/pkg/PLIST,v
> retrieving revision 1.2
> diff -u -p -r1.2 PLIST
> --- pkg/PLIST 19 Sep 2015 10:52:58 -0000 1.2
> +++ pkg/PLIST 2 Nov 2017 08:31:47 -0000
> @@ -6,59 +6,61 @@ lib/python${MODPY_VERSION}/site-packages
>
> lib/python${MODPY_VERSION}/site-packages/python_sql-${MODPY_EGG_VERSION}-py${MODPY_VERSION}.egg-info/top_level.txt
> lib/python${MODPY_VERSION}/site-packages/sql/
> lib/python${MODPY_VERSION}/site-packages/sql/__init__.py
> -lib/python${MODPY_VERSION}/site-packages/sql/__init__.pyc
> +${MODPY_COMMENT}lib/python${MODPY_VERSION}/site-packages/sql/${MODPY_PYCACHE}/
> +lib/python${MODPY_VERSION}/site-packages/sql/${MODPY_PYCACHE}__init__.${MODPY_PYC_MAGIC_TAG}pyc
> +lib/python${MODPY_VERSION}/site-packages/sql/${MODPY_PYCACHE}aggregate.${MODPY_PYC_MAGIC_TAG}pyc
> +lib/python${MODPY_VERSION}/site-packages/sql/${MODPY_PYCACHE}conditionals.${MODPY_PYC_MAGIC_TAG}pyc
> +lib/python${MODPY_VERSION}/site-packages/sql/${MODPY_PYCACHE}functions.${MODPY_PYC_MAGIC_TAG}pyc
> +lib/python${MODPY_VERSION}/site-packages/sql/${MODPY_PYCACHE}operators.${MODPY_PYC_MAGIC_TAG}pyc
> lib/python${MODPY_VERSION}/site-packages/sql/aggregate.py
> -lib/python${MODPY_VERSION}/site-packages/sql/aggregate.pyc
> lib/python${MODPY_VERSION}/site-packages/sql/conditionals.py
> -lib/python${MODPY_VERSION}/site-packages/sql/conditionals.pyc
> lib/python${MODPY_VERSION}/site-packages/sql/functions.py
> -lib/python${MODPY_VERSION}/site-packages/sql/functions.pyc
> lib/python${MODPY_VERSION}/site-packages/sql/operators.py
> -lib/python${MODPY_VERSION}/site-packages/sql/operators.pyc
> lib/python${MODPY_VERSION}/site-packages/sql/tests/
> lib/python${MODPY_VERSION}/site-packages/sql/tests/__init__.py
> -lib/python${MODPY_VERSION}/site-packages/sql/tests/__init__.pyc
> +${MODPY_COMMENT}lib/python${MODPY_VERSION}/site-packages/sql/tests/${MODPY_PYCACHE}/
> +lib/python${MODPY_VERSION}/site-packages/sql/tests/${MODPY_PYCACHE}__init__.${MODPY_PYC_MAGIC_TAG}pyc
> +lib/python${MODPY_VERSION}/site-packages/sql/tests/${MODPY_PYCACHE}test_aggregate.${MODPY_PYC_MAGIC_TAG}pyc
> +lib/python${MODPY_VERSION}/site-packages/sql/tests/${MODPY_PYCACHE}test_alias.${MODPY_PYC_MAGIC_TAG}pyc
> +lib/python${MODPY_VERSION}/site-packages/sql/tests/${MODPY_PYCACHE}test_as.${MODPY_PYC_MAGIC_TAG}pyc
> +lib/python${MODPY_VERSION}/site-packages/sql/tests/${MODPY_PYCACHE}test_cast.${MODPY_PYC_MAGIC_TAG}pyc
> +lib/python${MODPY_VERSION}/site-packages/sql/tests/${MODPY_PYCACHE}test_column.${MODPY_PYC_MAGIC_TAG}pyc
> +lib/python${MODPY_VERSION}/site-packages/sql/tests/${MODPY_PYCACHE}test_combining_query.${MODPY_PYC_MAGIC_TAG}pyc
> +lib/python${MODPY_VERSION}/site-packages/sql/tests/${MODPY_PYCACHE}test_conditionals.${MODPY_PYC_MAGIC_TAG}pyc
> +lib/python${MODPY_VERSION}/site-packages/sql/tests/${MODPY_PYCACHE}test_delete.${MODPY_PYC_MAGIC_TAG}pyc
> +lib/python${MODPY_VERSION}/site-packages/sql/tests/${MODPY_PYCACHE}test_for.${MODPY_PYC_MAGIC_TAG}pyc
> +lib/python${MODPY_VERSION}/site-packages/sql/tests/${MODPY_PYCACHE}test_functions.${MODPY_PYC_MAGIC_TAG}pyc
> +lib/python${MODPY_VERSION}/site-packages/sql/tests/${MODPY_PYCACHE}test_insert.${MODPY_PYC_MAGIC_TAG}pyc
> +lib/python${MODPY_VERSION}/site-packages/sql/tests/${MODPY_PYCACHE}test_join.${MODPY_PYC_MAGIC_TAG}pyc
> +lib/python${MODPY_VERSION}/site-packages/sql/tests/${MODPY_PYCACHE}test_lateral.${MODPY_PYC_MAGIC_TAG}pyc
> +lib/python${MODPY_VERSION}/site-packages/sql/tests/${MODPY_PYCACHE}test_literal.${MODPY_PYC_MAGIC_TAG}pyc
> +lib/python${MODPY_VERSION}/site-packages/sql/tests/${MODPY_PYCACHE}test_operators.${MODPY_PYC_MAGIC_TAG}pyc
> +lib/python${MODPY_VERSION}/site-packages/sql/tests/${MODPY_PYCACHE}test_order.${MODPY_PYC_MAGIC_TAG}pyc
> +lib/python${MODPY_VERSION}/site-packages/sql/tests/${MODPY_PYCACHE}test_select.${MODPY_PYC_MAGIC_TAG}pyc
> +lib/python${MODPY_VERSION}/site-packages/sql/tests/${MODPY_PYCACHE}test_table.${MODPY_PYC_MAGIC_TAG}pyc
> +lib/python${MODPY_VERSION}/site-packages/sql/tests/${MODPY_PYCACHE}test_update.${MODPY_PYC_MAGIC_TAG}pyc
> +lib/python${MODPY_VERSION}/site-packages/sql/tests/${MODPY_PYCACHE}test_values.${MODPY_PYC_MAGIC_TAG}pyc
> +lib/python${MODPY_VERSION}/site-packages/sql/tests/${MODPY_PYCACHE}test_window.${MODPY_PYC_MAGIC_TAG}pyc
> +lib/python${MODPY_VERSION}/site-packages/sql/tests/${MODPY_PYCACHE}test_with.${MODPY_PYC_MAGIC_TAG}pyc
> lib/python${MODPY_VERSION}/site-packages/sql/tests/test_aggregate.py
> -lib/python${MODPY_VERSION}/site-packages/sql/tests/test_aggregate.pyc
> lib/python${MODPY_VERSION}/site-packages/sql/tests/test_alias.py
> -lib/python${MODPY_VERSION}/site-packages/sql/tests/test_alias.pyc
> lib/python${MODPY_VERSION}/site-packages/sql/tests/test_as.py
> -lib/python${MODPY_VERSION}/site-packages/sql/tests/test_as.pyc
> lib/python${MODPY_VERSION}/site-packages/sql/tests/test_cast.py
> -lib/python${MODPY_VERSION}/site-packages/sql/tests/test_cast.pyc
> lib/python${MODPY_VERSION}/site-packages/sql/tests/test_column.py
> -lib/python${MODPY_VERSION}/site-packages/sql/tests/test_column.pyc
> lib/python${MODPY_VERSION}/site-packages/sql/tests/test_combining_query.py
> -lib/python${MODPY_VERSION}/site-packages/sql/tests/test_combining_query.pyc
> lib/python${MODPY_VERSION}/site-packages/sql/tests/test_conditionals.py
> -lib/python${MODPY_VERSION}/site-packages/sql/tests/test_conditionals.pyc
> lib/python${MODPY_VERSION}/site-packages/sql/tests/test_delete.py
> -lib/python${MODPY_VERSION}/site-packages/sql/tests/test_delete.pyc
> lib/python${MODPY_VERSION}/site-packages/sql/tests/test_for.py
> -lib/python${MODPY_VERSION}/site-packages/sql/tests/test_for.pyc
> lib/python${MODPY_VERSION}/site-packages/sql/tests/test_functions.py
> -lib/python${MODPY_VERSION}/site-packages/sql/tests/test_functions.pyc
> lib/python${MODPY_VERSION}/site-packages/sql/tests/test_insert.py
> -lib/python${MODPY_VERSION}/site-packages/sql/tests/test_insert.pyc
> lib/python${MODPY_VERSION}/site-packages/sql/tests/test_join.py
> -lib/python${MODPY_VERSION}/site-packages/sql/tests/test_join.pyc
> lib/python${MODPY_VERSION}/site-packages/sql/tests/test_lateral.py
> -lib/python${MODPY_VERSION}/site-packages/sql/tests/test_lateral.pyc
> lib/python${MODPY_VERSION}/site-packages/sql/tests/test_literal.py
> -lib/python${MODPY_VERSION}/site-packages/sql/tests/test_literal.pyc
> lib/python${MODPY_VERSION}/site-packages/sql/tests/test_operators.py
> -lib/python${MODPY_VERSION}/site-packages/sql/tests/test_operators.pyc
> lib/python${MODPY_VERSION}/site-packages/sql/tests/test_order.py
> -lib/python${MODPY_VERSION}/site-packages/sql/tests/test_order.pyc
> lib/python${MODPY_VERSION}/site-packages/sql/tests/test_select.py
> -lib/python${MODPY_VERSION}/site-packages/sql/tests/test_select.pyc
> lib/python${MODPY_VERSION}/site-packages/sql/tests/test_table.py
> -lib/python${MODPY_VERSION}/site-packages/sql/tests/test_table.pyc
> lib/python${MODPY_VERSION}/site-packages/sql/tests/test_update.py
> -lib/python${MODPY_VERSION}/site-packages/sql/tests/test_update.pyc
> lib/python${MODPY_VERSION}/site-packages/sql/tests/test_values.py
> -lib/python${MODPY_VERSION}/site-packages/sql/tests/test_values.pyc
> lib/python${MODPY_VERSION}/site-packages/sql/tests/test_window.py
> -lib/python${MODPY_VERSION}/site-packages/sql/tests/test_window.pyc
> lib/python${MODPY_VERSION}/site-packages/sql/tests/test_with.py
> -lib/python${MODPY_VERSION}/site-packages/sql/tests/test_with.pyc
--
Sebastien Marie
