Reorganise and modernise the py-sqlalchemy ports.

 - Introduce new ports for the sqlalchemy 0.9 and 1.0 release branches.
 - Deprecate the ports for the 0.6 and 0.7 release branches, as these
   have been declared EoL and are no longer supported by upstream.
 - Update to the latest available version in each branch.

In detail:

   Port                 Version Maintainer
   ----------------------------------------------
   py-sqlalchemy06      0.6.9   nivit@FreeBSD.org (Deprecate 2016-08-20) [1]
   py-sqlalchemy07      0.7.10  nivit@FreeBSD.org (renamed py-sqlalchemy, Deprecate 2016-08-20) [1]
   py-sqlalchemy08      0.8.7   nivit@FreeBSD.org (renamed py-sqlalchemy-devel) [1]
   py-sqlalchemy09      0.9.10  m.tsatsenko@gmail.com (new, repocopy from py-sqlalchemy-devel) [2]
   py-sqlalchemy10      1.0.13  m.tsatsenko@gmail.com (new, repocopy from py-sqlalchemy-devel) [2]

 - Use options-helpers and option dependent make targets.
 - Use autoplist for documents as well as python code
 - Add all the docments to the packages: previously an arbitrary
   subset was added in a way that excluded CSS, images and other HTML
   assets.
 - Use TEST_DEPENDS and add a TEST_TARGET instead of having a 'TEST'
   option.
 - Use py-pytest for 0.9.x and later, rather than py-nose.
 - Add CONFLICTS_INSTALL between all of the py-sqlalchemyXY ports.

PR:		191442
Submitted by:	robak
Reviewed by:	robak
Reviewed by:	pi
Approved by:	nivit (maintainer timeout, ~300days) [1]
Approved by:    m.tsatsenko@gmail.com (maintainer) [2]
Sponsored by:	https://reviews.freebsd.org/D908

4 files changed, 0 insertions, 242 deletions

diff --git a/databases/py-sqlalchemy/Makefile b/databases/py-sqlalchemy/Makefile
deleted file mode 100644
index 9ee0fe513187..000000000000
--- a/databases/py-sqlalchemy/Makefile
+++ /dev/null
@@ -1,117 +0,0 @@
-# Created by: Dryice Dong Liu <dryice@dryice.name>
-# $FreeBSD$
-
-PORTNAME=	sqlalchemy
-PORTVERSION=	0.7.10
-PORTREVISION=	2
-CATEGORIES=	databases python
-MASTER_SITES=	CHEESESHOP
-PKGNAMEPREFIX=	${PYTHON_PKGNAMEPREFIX}
-DISTNAME=	SQLAlchemy-${DISTVERSION}
-
-MAINTAINER=	nivit@FreeBSD.org
-COMMENT=	Python SQL toolkit and Object Relational Mapper
-
-LICENSE=	MIT
-
-TEST_DEPENDS:=	${RUN_DEPENDS} \
-		${PYTHON_PKGNAMEPREFIX}nose>0:devel/py-nose
-
-# Python3 ready
-USES=		python
-USE_PYTHON=	distutils autoplist
-PY2TO3_CMD=	${LOCALBASE}/bin/2to3-${PYTHON_VER}
-PY2TO3_ARGS=	--no-diffs --nobackups --verbose --write
-
-OPTIONS_DEFINE=		DOCS EXAMPLES TESTS
-OPTIONS_MULTI=		BACKEND
-OPTIONS_MULTI_BACKEND=	MSSQL MYSQL PGSQL SQLITE SYBASE
-OPTIONS_DEFAULT=	SQLITE
-
-MSSQL_DESC=	MS SQL Server backend
-TESTS_DESC=	Include nose for unit tests
-SYBASE_DESC=	Sybase backend
-
-.include <bsd.port.options.mk>
-
-DOCSDIR=	${PREFIX}/share/doc/${PKGNAMEPREFIX}${PORTNAME}
-EXAMPLESDIR=	${PREFIX}/share/examples/${PKGNAMEPREFIX}${PORTNAME}
-
-.include <bsd.port.pre.mk>
-
-.if ${PORT_OPTIONS:MDOCS}
-AL_PORTDOCS=	*.html *.js
-AL_PORTDOCS_SUBDIR=	core dialects orm
-.endif
-
-.if ${PORT_OPTIONS:MMSSQL}
-RUN_DEPENDS+=	${PYTHON_SITELIBDIR}/pymssql.py:databases/py-mssql
-.endif
-
-.if ${PORT_OPTIONS:MMYSQL}
-.if ${PYTHON_VER} < 3.0
-RUN_DEPENDS+=	${PYTHON_PKGNAMEPREFIX}MySQLdb>=1.2.2:databases/py-MySQLdb
-#.else
-# At the moment databases/py-pymysql does not build with Python3
-# See https://github.com/petehunt/PyMySQL#python-3-0-support
-#RUN_DEPENDS+=	pymysql>=0.5:databases/py-pymysql
-.endif
-.endif
-
-.if ${PORT_OPTIONS:MTESTS}
-BUILD_DEPENDS+=	${PYTHON_PKGNAMEPREFIX}nose>0:devel/py-nose
-.endif
-
-.if ${PORT_OPTIONS:MPGSQL}
-RUN_DEPENDS+=	${PYTHON_PKGNAMEPREFIX}psycopg2>=2.0.8:databases/py-psycopg2
-.endif
-
-.if ${PORT_OPTIONS:MSQLITE}
-RUN_DEPENDS+=	${PYTHON_PKGNAMEPREFIX}sqlite3>0:databases/py-sqlite3
-.endif
-
-.if ${PORT_OPTIONS:MSYBASE}
-RUN_DEPENDS+=	${PYTHON_SITELIBDIR}/Sybase.py:databases/py-sybase
-.endif
-
-post-patch:
-	${REINPLACE_CMD} -e 's/import logging/&.handlers/1' -i.bak ${WRKSRC}/test/engine/test_execute.py
-
-pre-build:
-.if ${PYTHON_REL} >= 3000
-	@${PY2TO3_CMD} ${PY2TO3_ARGS} ${WRKSRC}/lib
-.endif
-
-post-install:
-.if ${PYTHON_REL} >= 3000
-	@${PY2TO3_CMD} ${PY2TO3_ARGS} ${WRKSRC}/doc
-.endif
-	@${MKDIR} ${STAGEDIR}${DOCSDIR}
-.for i in ${AL_PORTDOCS}
-	${INSTALL_DATA} ${WRKSRC}/doc/${i} ${STAGEDIR}${DOCSDIR}
-.endfor
-.for i in ${AL_PORTDOCS_SUBDIR}
-	${MKDIR} ${STAGEDIR}${DOCSDIR}/${i}
-	@cd ${WRKSRC}/doc/${i} && ${COPYTREE_SHARE} . ${STAGEDIR}${DOCSDIR}/${i}
-.endfor
-
-	@${MKDIR} ${STAGEDIR}${EXAMPLESDIR}
-.if ${PYTHON_REL} >= 3000
-	@${PY2TO3_CMD} ${PY2TO3_ARGS} ${WRKSRC}/examples
-.endif
-	cd ${WRKSRC}/examples/ && ${COPYTREE_SHARE} . ${STAGEDIR}${EXAMPLESDIR}
-
-.if ${PYTHON_REL} < 3000
-PLIST_SUB+=	SPEEDUPS=""
-.else
-# C extensions are not supported in py3k
-PLIST_SUB+=	SPEEDUPS="@comment "
-.endif
-
-regression-test: build
-.if ${PYTHON_REL} >= 3000
-	${PY2TO3_CMD} ${PY2TO3_ARGS} ${WRKSRC}/test
-.endif
-	@cd ${WRKSRC} && ${PYTHON_CMD} sqla_nose.py
-
-.include <bsd.port.post.mk>
diff --git a/databases/py-sqlalchemy/distinfo b/databases/py-sqlalchemy/distinfo
deleted file mode 100644
index fc43a0e734ec..000000000000
--- a/databases/py-sqlalchemy/distinfo
+++ /dev/null
@@ -1,2 +0,0 @@
-SHA256 (SQLAlchemy-0.7.10.tar.gz) = 77aa39d65c9d043eba6ba329b359ff867424fd6c403b7c0cb112b65e507e1d66
-SIZE (SQLAlchemy-0.7.10.tar.gz) = 3541639
diff --git a/databases/py-sqlalchemy/pkg-descr b/databases/py-sqlalchemy/pkg-descr
deleted file mode 100644
index 84d56454ff4e..000000000000
--- a/databases/py-sqlalchemy/pkg-descr
+++ /dev/null
@@ -1,10 +0,0 @@
-The Python SQL Toolkit and Object Relational Mapper
-
-SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that
-gives application developers the full power and flexibility of SQL.
-
-It provides a full suite of well known enterprise-level persistence
-patterns, designed for efficient and high-performing database access,
-adapted into a simple and Pythonic domain language.
-
-WWW: http://www.sqlalchemy.org/
diff --git a/databases/py-sqlalchemy/pkg-plist b/databases/py-sqlalchemy/pkg-plist
deleted file mode 100644
index b423555a3b7a..000000000000
--- a/databases/py-sqlalchemy/pkg-plist
+++ /dev/null
@@ -1,113 +0,0 @@
-%%PORTDOCS%%%%DOCSDIR%%/contents.html
-%%PORTDOCS%%%%DOCSDIR%%/copyright.html
-%%PORTDOCS%%%%DOCSDIR%%/core/compiler.html
-%%PORTDOCS%%%%DOCSDIR%%/core/connections.html
-%%PORTDOCS%%%%DOCSDIR%%/core/engines.html
-%%PORTDOCS%%%%DOCSDIR%%/core/event.html
-%%PORTDOCS%%%%DOCSDIR%%/core/events.html
-%%PORTDOCS%%%%DOCSDIR%%/core/exceptions.html
-%%PORTDOCS%%%%DOCSDIR%%/core/expression_api.html
-%%PORTDOCS%%%%DOCSDIR%%/core/index.html
-%%PORTDOCS%%%%DOCSDIR%%/core/interfaces.html
-%%PORTDOCS%%%%DOCSDIR%%/core/internals.html
-%%PORTDOCS%%%%DOCSDIR%%/core/pooling.html
-%%PORTDOCS%%%%DOCSDIR%%/core/schema.html
-%%PORTDOCS%%%%DOCSDIR%%/core/serializer.html
-%%PORTDOCS%%%%DOCSDIR%%/core/tutorial.html
-%%PORTDOCS%%%%DOCSDIR%%/core/types.html
-%%PORTDOCS%%%%DOCSDIR%%/dialects/access.html
-%%PORTDOCS%%%%DOCSDIR%%/dialects/drizzle.html
-%%PORTDOCS%%%%DOCSDIR%%/dialects/firebird.html
-%%PORTDOCS%%%%DOCSDIR%%/dialects/index.html
-%%PORTDOCS%%%%DOCSDIR%%/dialects/informix.html
-%%PORTDOCS%%%%DOCSDIR%%/dialects/maxdb.html
-%%PORTDOCS%%%%DOCSDIR%%/dialects/mssql.html
-%%PORTDOCS%%%%DOCSDIR%%/dialects/mysql.html
-%%PORTDOCS%%%%DOCSDIR%%/dialects/oracle.html
-%%PORTDOCS%%%%DOCSDIR%%/dialects/postgresql.html
-%%PORTDOCS%%%%DOCSDIR%%/dialects/sqlite.html
-%%PORTDOCS%%%%DOCSDIR%%/dialects/sybase.html
-%%PORTDOCS%%%%DOCSDIR%%/genindex.html
-%%PORTDOCS%%%%DOCSDIR%%/glossary.html
-%%PORTDOCS%%%%DOCSDIR%%/index.html
-%%PORTDOCS%%%%DOCSDIR%%/intro.html
-%%PORTDOCS%%%%DOCSDIR%%/orm/collections.html
-%%PORTDOCS%%%%DOCSDIR%%/orm/deprecated.html
-%%PORTDOCS%%%%DOCSDIR%%/orm/events.html
-%%PORTDOCS%%%%DOCSDIR%%/orm/examples.html
-%%PORTDOCS%%%%DOCSDIR%%/orm/exceptions.html
-%%PORTDOCS%%%%DOCSDIR%%/orm/extensions/associationproxy.html
-%%PORTDOCS%%%%DOCSDIR%%/orm/extensions/declarative.html
-%%PORTDOCS%%%%DOCSDIR%%/orm/extensions/horizontal_shard.html
-%%PORTDOCS%%%%DOCSDIR%%/orm/extensions/hybrid.html
-%%PORTDOCS%%%%DOCSDIR%%/orm/extensions/index.html
-%%PORTDOCS%%%%DOCSDIR%%/orm/extensions/mutable.html
-%%PORTDOCS%%%%DOCSDIR%%/orm/extensions/orderinglist.html
-%%PORTDOCS%%%%DOCSDIR%%/orm/extensions/sqlsoup.html
-%%PORTDOCS%%%%DOCSDIR%%/orm/index.html
-%%PORTDOCS%%%%DOCSDIR%%/orm/inheritance.html
-%%PORTDOCS%%%%DOCSDIR%%/orm/interfaces.html
-%%PORTDOCS%%%%DOCSDIR%%/orm/internals.html
-%%PORTDOCS%%%%DOCSDIR%%/orm/loading.html
-%%PORTDOCS%%%%DOCSDIR%%/orm/mapper_config.html
-%%PORTDOCS%%%%DOCSDIR%%/orm/query.html
-%%PORTDOCS%%%%DOCSDIR%%/orm/relationships.html
-%%PORTDOCS%%%%DOCSDIR%%/orm/session.html
-%%PORTDOCS%%%%DOCSDIR%%/orm/tutorial.html
-%%PORTDOCS%%%%DOCSDIR%%/search.html
-%%PORTDOCS%%%%DOCSDIR%%/searchindex.js
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/__init__.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/adjacency_list/__init__.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/adjacency_list/adjacency_list.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/association/__init__.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/association/basic_association.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/association/dict_of_sets_with_default.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/association/proxied_association.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/beaker_caching/__init__.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/beaker_caching/advanced.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/beaker_caching/caching_query.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/beaker_caching/environment.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/beaker_caching/fixture_data.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/beaker_caching/helloworld.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/beaker_caching/local_session_caching.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/beaker_caching/model.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/beaker_caching/relation_caching.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/custom_attributes/__init__.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/custom_attributes/custom_management.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/custom_attributes/listen_for_events.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/declarative_reflection/__init__.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/declarative_reflection/declarative_reflection.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/dynamic_dict/__init__.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/dynamic_dict/dynamic_dict.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/elementtree/__init__.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/elementtree/adjacency_list.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/elementtree/optimized_al.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/elementtree/pickle.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/elementtree/test.xml
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/elementtree/test2.xml
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/elementtree/test3.xml
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/generic_associations/__init__.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/generic_associations/discriminator_on_association.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/generic_associations/table_per_association.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/generic_associations/table_per_related.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/graphs/__init__.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/graphs/directed_graph.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/inheritance/__init__.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/inheritance/concrete.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/inheritance/polymorph.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/inheritance/single.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/large_collection/__init__.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/large_collection/large_collection.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/nested_sets/__init__.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/nested_sets/nested_sets.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/postgis/__init__.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/postgis/postgis.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/sharding/__init__.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/sharding/attribute_shard.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/versioning/__init__.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/versioning/_lib.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/versioning/history_meta.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/versioning/test_versioning.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/vertical/__init__.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/vertical/dictlike-polymorphic.py
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%/vertical/dictlike.py