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

23 files changed, 378 insertions, 340 deletions

diff --git a/databases/Makefile b/databases/Makefile
index e9be4706d24c..980939a6722a 100644
--- a/databases/Makefile
+++ b/databases/Makefile
@@ -776,10 +776,12 @@
     SUBDIR += py-riak
     SUBDIR += py-rrdtool_lgpl
     SUBDIR += py-south
-    SUBDIR += py-sqlalchemy
-    SUBDIR += py-sqlalchemy-devel
     SUBDIR += py-sqlalchemy-migrate
     SUBDIR += py-sqlalchemy06
+    SUBDIR += py-sqlalchemy07
+    SUBDIR += py-sqlalchemy08
+    SUBDIR += py-sqlalchemy09
+    SUBDIR += py-sqlalchemy10
     SUBDIR += py-sqlite3
     SUBDIR += py-sqlite3dbm
     SUBDIR += py-sqlobject
diff --git a/databases/py-alembic/Makefile b/databases/py-alembic/Makefile
index e8e7cb8962c2..08b861511ccb 100644
--- a/databases/py-alembic/Makefile
+++ b/databases/py-alembic/Makefile
@@ -11,7 +11,7 @@ COMMENT=	Database migration tool for SQLAlchemy
 
 LICENSE=	MIT
 
-RUN_DEPENDS=	${PYTHON_PKGNAMEPREFIX}sqlalchemy>=0.7.3:databases/py-sqlalchemy \
+RUN_DEPENDS=	${PYTHON_PKGNAMEPREFIX}sqlalchemy07>=0.7.3:databases/py-sqlalchemy07 \
 		${PYTHON_PKGNAMEPREFIX}mako>=0:textproc/py-mako
 
 USES=		python
diff --git a/databases/py-flask-sqlalchemy/Makefile b/databases/py-flask-sqlalchemy/Makefile
index a4b30cbed69a..78ac4ead8aec 100644
--- a/databases/py-flask-sqlalchemy/Makefile
+++ b/databases/py-flask-sqlalchemy/Makefile
@@ -13,7 +13,7 @@ COMMENT=	Adds SQLAlchemy support to Flask
 LICENSE=	BSD3CLAUSE
 
 RUN_DEPENDS=	${PYTHON_PKGNAMEPREFIX}Flask>=0.10:www/py-flask \
-	${PYTHON_PKGNAMEPREFIX}sqlalchemy>=0.7:databases/py-sqlalchemy
+	${PYTHON_PKGNAMEPREFIX}sqlalchemy07>=0.7:databases/py-sqlalchemy07
 
 USES=	python
 USE_PYTHON=	distutils autoplist
diff --git a/databases/py-geoalchemy/Makefile b/databases/py-geoalchemy/Makefile
index 9ab681175b90..22f4fdc583d2 100644
--- a/databases/py-geoalchemy/Makefile
+++ b/databases/py-geoalchemy/Makefile
@@ -13,7 +13,7 @@ COMMENT=	Using SQLAlchemy with Spatial Databases
 
 LICENSE=	MIT
 
-RUN_DEPENDS=	${PYTHON_PKGNAMEPREFIX}sqlalchemy>=0.6.1:databases/py-sqlalchemy
+RUN_DEPENDS=	${PYTHON_PKGNAMEPREFIX}sqlalchemy07>=0.6.1:databases/py-sqlalchemy07
 
 USE_PYTHON=	autoplist distutils
 USES=		python:2
diff --git a/databases/py-geoalchemy2/Makefile b/databases/py-geoalchemy2/Makefile
index 8d7d41ca8bc0..d3aa5a58ac43 100644
--- a/databases/py-geoalchemy2/Makefile
+++ b/databases/py-geoalchemy2/Makefile
@@ -13,7 +13,7 @@ COMMENT=	Using SQLAlchemy with Spatial Databases
 
 LICENSE=	MIT
 
-RUN_DEPENDS=	${PYTHON_PKGNAMEPREFIX}sqlalchemy08>=0.8:databases/py-sqlalchemy-devel
+RUN_DEPENDS=	${PYTHON_PKGNAMEPREFIX}sqlalchemy08>=0.8:databases/py-sqlalchemy08
 
 NO_ARCH=	yes
 USE_PYTHON=	autoplist concurrent distutils
diff --git a/databases/py-sqlalchemy-devel/Makefile b/databases/py-sqlalchemy-devel/Makefile
deleted file mode 100644
index dc513c331ccf..000000000000
--- a/databases/py-sqlalchemy-devel/Makefile
+++ /dev/null
@@ -1,99 +0,0 @@
-# Created by: Dryice Dong Liu <dryice@dryice.name>
-# $FreeBSD$
-
-PORTNAME=	sqlalchemy
-PORTVERSION=	0.8.2
-PORTREVISION=	1
-CATEGORIES=	databases python
-MASTER_SITES=	CHEESESHOP
-PKGNAMEPREFIX=	${PYTHON_PKGNAMEPREFIX}
-PKGNAMESUFFIX=	08
-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
-
-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
-
-SYBASE_DESC=	Sybase backend
-TESTS_DESC=	Include nose for unit tests
-
-MSSQL_RUN_DEPENDS=	${PYTHON_PKGNAMEPREFIX}mssql>0:databases/py-mssql
-PGSQL_RUN_DEPENDS=	${PYTHON_PKGNAMEPREFIX}psycopg2>=2.0.8:databases/py-psycopg2
-SQLITE_RUN_DEPENDS=	${PYTHON_PKGNAMEPREFIX}sqlite3>0:databases/py-sqlite3
-SYBASE_RUN_DEPENDS=	${PYTHON_PKGNAMEPREFIX}sybase>0:databases/py-sybase
-TESTS_BUILD_DEPENDS:=	${TEST_DEPENDS}
-
-DOCSDIR=	${PREFIX}/share/doc/${PKGNAMEPREFIX}${PORTNAME}
-EXAMPLESDIR=	${PREFIX}/share/examples/${PKGNAMEPREFIX}${PORTNAME}
-PORTDOCS=	*
-PORTEXAMPLES=	*
-
-.include <bsd.port.options.mk>
-.include <bsd.port.pre.mk>
-
-.if ${PORT_OPTIONS:MDOCS}
-AL_PORTDOCS=		*.html *.js
-AL_PORTDOCS_SUBDIR=	core dialects orm
-.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 ${PYTHON_REL} < 3300
-TEST_DEPENDS+=	${PYTHON_PKGNAMEPREFIX}mock>=1.0.1:devel/py-mock
-.endif
-
-.if ${PYTHON_REL} >= 3000
-pre-build:
-	@${PY2TO3_CMD} ${PY2TO3_ARGS} ${WRKSRC}/lib
-.endif
-
-post-install:
-	@${MKDIR} ${STAGEDIR}${DOCSDIR}
-.if ${PYTHON_REL} >= 3000
-	${PY2TO3_CMD} ${PY2TO3_ARGS} ${WRKSRC}/doc
-.endif
-
-.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})
-
-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-devel/distinfo b/databases/py-sqlalchemy-devel/distinfo
deleted file mode 100644
index 9201bb5b07f1..000000000000
--- a/databases/py-sqlalchemy-devel/distinfo
+++ /dev/null
@@ -1,2 +0,0 @@
-SHA256 (SQLAlchemy-0.8.2.tar.gz) = 71ce685f0e643bae95c7d4ace7ff8d6dcb37e99605cab3cf31c2be006c17905f
-SIZE (SQLAlchemy-0.8.2.tar.gz) = 3816467
diff --git a/databases/py-sqlalchemy-migrate/Makefile b/databases/py-sqlalchemy-migrate/Makefile
index 51ab97bf1005..80e7f040b3bd 100644
--- a/databases/py-sqlalchemy-migrate/Makefile
+++ b/databases/py-sqlalchemy-migrate/Makefile
@@ -13,7 +13,7 @@ COMMENT=	Database schema migrations for SQLAlchemy
 
 LICENSE=	MIT
 
-RUN_DEPENDS=	${PYTHON_PKGNAMEPREFIX}sqlalchemy>=0.7:databases/py-sqlalchemy \
+RUN_DEPENDS=	${PYTHON_PKGNAMEPREFIX}sqlalchemy07>=0.7:databases/py-sqlalchemy07 \
 		${PYTHON_PKGNAMEPREFIX}Tempita>0:textproc/py-Tempita \
 		${PYTHON_PKGNAMEPREFIX}decorator>0:devel/py-decorator
 
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/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
diff --git a/databases/py-sqlalchemy06/Makefile b/databases/py-sqlalchemy06/Makefile
index 9fd961428d35..a4a2d79045cb 100644
--- a/databases/py-sqlalchemy06/Makefile
+++ b/databases/py-sqlalchemy06/Makefile
@@ -10,14 +10,18 @@ PKGNAMEPREFIX=	${PYTHON_PKGNAMEPREFIX}
 DISTNAME=	SQLAlchemy-${DISTVERSION}
 
 MAINTAINER=	nivit@FreeBSD.org
-COMMENT=	Python SQL toolkit and Object Relational Mapper (series 0.6)
+COMMENT=	Python SQL toolkit and Object Relational Mapper 0.6.x
 
 LICENSE=	MIT
 
-# Python3 ready
+DEPRECATED=	Upstream has declared this version EoL: please migrate to databases/py-sqlalchemy10
+EXPIRATION_DATE=	2016-08-20
+
 USES=		python
 USE_PYTHON=	distutils autoplist
 
+CONFLICTS_INSTALL=	${PYTHON_PKGNAMEPREFIX}sqlalchemy{0[789],10}*
+
 OPTIONS_DEFINE=	CEXTENSIONS DOCS EXAMPLES NOSE
 
 OPTIONS_MULTI=	BACKEND
diff --git a/databases/py-sqlalchemy07/Makefile b/databases/py-sqlalchemy07/Makefile
new file mode 100644
index 000000000000..a3293778bce5
--- /dev/null
+++ b/databases/py-sqlalchemy07/Makefile
@@ -0,0 +1,90 @@
+# Created by: Dryice Dong Liu <dryice@dryice.name>
+# $FreeBSD$
+
+PORTNAME=	sqlalchemy
+PORTVERSION=	0.7.10
+PORTREVISION=	3
+CATEGORIES=	databases python
+MASTER_SITES=	CHEESESHOP
+PKGNAMEPREFIX=	${PYTHON_PKGNAMEPREFIX}
+PKGNAMESUFFIX=	07
+DISTNAME=	SQLAlchemy-${DISTVERSION}
+
+MAINTAINER=	nivit@FreeBSD.org
+COMMENT=	Python SQL toolkit and Object Relational Mapper 0.7.x
+
+LICENSE=	MIT
+
+DEPRECATED=	Upstream has declared this version EoL: please migrate to databases/py-sqlalchemy10
+EXPIRATION_DATE=	2016-08-20
+
+TEST_DEPENDS=	${PYTHON_PKGNAMEPREFIX}nose>0:devel/py-nose \
+		${PYTHON_PKGNAMEPREFIX}mock>0:devel/py-mock
+
+USES=		python
+USE_PYTHON=	autoplist distutils
+
+PY2TO3_CMD=	${LOCALBASE}/bin/2to3-${PYTHON_VER}
+PY2TO3_ARGS=	--no-diffs --nobackups --verbose --write
+TEST_TARGET=	do-test
+
+CONFLICTS_INSTALL=	${PYTHON_PKGNAMEPREFIX}sqlalchemy{0[689],10}*
+
+OPTIONS_DEFINE=		DOCS EXAMPLES
+OPTIONS_MULTI=		BACKEND
+OPTIONS_MULTI_BACKEND=	FIREBIRD MSSQL MYSQL PGSQL SQLITE SYBASE
+OPTIONS_DEFAULT=	SQLITE
+
+FIREBIRD_DESC=	Firebird backend
+MSSQL_DESC=	MS SQL Server backend
+SYBASE_DESC=	Sybase backend
+
+FIREBIRD_RUN_DEPENDS=	${PYTHON_SITELIBDIR}/kinterbasdb/__init__.py:databases/kinterbasdb
+MSSQL_RUN_DEPENDS=	${PYTHON_PKGNAMEPREFIX}mssql>0:databases/py-mssql
+PGSQL_RUN_DEPENDS=	${PYTHON_PKGNAMEPREFIX}psycopg2>=2.0.8:databases/py-psycopg2
+SQLITE_RUN_DEPENDS=	${PYTHON_PKGNAMEPREFIX}sqlite3>0:databases/py-sqlite3
+SYBASE_RUN_DEPENDS=	${PYTHON_PKGNAMEPREFIX}sybase>0:databases/py-sybase
+
+PORTDOCS=	*
+PORTEXAMPLES=	*
+
+.include <bsd.port.pre.mk>
+
+.if ${PYTHON_REL} < 3000
+MYSQL_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
+
+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
+	@${PY2TO3_CMD} ${PY2TO3_ARGS} ${WRKSRC}/doc
+	@${PY2TO3_CMD} ${PY2TO3_ARGS} ${WRKSRC}/examples
+.endif
+
+# C extensions are not supported with all versions of Python, so ignore
+# errors here if there are no .so files to strip.
+post-install:
+	-@${STRIP_CMD} ${STAGEDIR}${PYTHON_SITELIBDIR}/sqlalchemy/*.so
+
+post-install-DOCS-on:
+	@${MKDIR} ${STAGEDIR}${DOCSDIR}
+	cd ${WRKSRC}/doc/ && ${COPYTREE_SHARE} . ${STAGEDIR}${DOCSDIR}
+
+post-install-EXAMPLES-on:
+	@${MKDIR} ${STAGEDIR}${EXAMPLESDIR}
+	cd ${WRKSRC}/examples/ && ${COPYTREE_SHARE} . ${STAGEDIR}${EXAMPLESDIR}
+
+do-test:
+.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-sqlalchemy07/distinfo
index fc43a0e734ec..74e2f2a617ca 100644
--- a/databases/py-sqlalchemy/distinfo
+++ b/databases/py-sqlalchemy07/distinfo
@@ -1,2 +1,3 @@
+TIMESTAMP = 1463753628
 SHA256 (SQLAlchemy-0.7.10.tar.gz) = 77aa39d65c9d043eba6ba329b359ff867424fd6c403b7c0cb112b65e507e1d66
 SIZE (SQLAlchemy-0.7.10.tar.gz) = 3541639
diff --git a/databases/py-sqlalchemy-devel/pkg-descr b/databases/py-sqlalchemy07/pkg-descr
index 84d56454ff4e..84d56454ff4e 100644
--- a/databases/py-sqlalchemy-devel/pkg-descr
+++ b/databases/py-sqlalchemy07/pkg-descr
diff --git a/databases/py-sqlalchemy08/Makefile b/databases/py-sqlalchemy08/Makefile
new file mode 100644
index 000000000000..31a5658bf390
--- /dev/null
+++ b/databases/py-sqlalchemy08/Makefile
@@ -0,0 +1,81 @@
+# Created by: Dryice Dong Liu <dryice@dryice.name>
+# $FreeBSD$
+
+PORTNAME=	sqlalchemy
+PORTVERSION=	0.8.7
+CATEGORIES=	databases python
+MASTER_SITES=	CHEESESHOP
+PKGNAMEPREFIX=	${PYTHON_PKGNAMEPREFIX}
+PKGNAMESUFFIX=	08
+DISTNAME=	SQLAlchemy-${DISTVERSION}
+
+MAINTAINER=	nivit@FreeBSD.org
+COMMENT=	Python SQL toolkit and Object Relational Mapper 0.8.x
+
+LICENSE=	MIT
+
+TEST_DEPENDS=	${PYTHON_PKGNAMEPREFIX}nose>0:devel/py-nose \
+		${PYTHON_PKGNAMEPREFIX}mock>0:devel/py-mock
+
+USES=		python
+USE_PYTHON=	distutils autoplist
+
+PY2TO3_CMD=	${LOCALBASE}/bin/2to3-${PYTHON_VER}
+PY2TO3_ARGS=	--no-diffs --nobackups --verbose --write
+TEST_TARGET=	do-test
+
+CONFLICTS_INSTALL=	${PYTHON_PKGNAMEPREFIX}sqlalchemy{0[679],10}*
+
+OPTIONS_DEFINE=		DOCS EXAMPLES
+OPTIONS_MULTI=		BACKEND
+OPTIONS_MULTI_BACKEND=	MSSQL MYSQL PGSQL SQLITE SYBASE
+OPTIONS_DEFAULT=	SQLITE
+
+MSSQL_DESC=	MS SQL Server backend
+SYBASE_DESC=	Sybase backend
+
+MSSQL_RUN_DEPENDS=	${PYTHON_PKGNAMEPREFIX}mssql>0:databases/py-mssql
+PGSQL_RUN_DEPENDS=	${PYTHON_PKGNAMEPREFIX}psycopg2>=2.0.8:databases/py-psycopg2
+SQLITE_RUN_DEPENDS=	${PYTHON_PKGNAMEPREFIX}sqlite3>0:databases/py-sqlite3
+SYBASE_RUN_DEPENDS=	${PYTHON_PKGNAMEPREFIX}sybase>0:databases/py-sybase
+
+PORTDOCS=		*
+PORTEXAMPLES=		*
+
+.include <bsd.port.pre.mk>
+
+.if ${PYTHON_REL} < 3000
+MYSQL_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
+#MYSQL_RUN_DEPENDS=	pymysql>=0.5:databases/py-pymysql
+.endif
+
+pre-build:
+.if ${PYTHON_REL} >= 3000
+	@${PY2TO3_CMD} ${PY2TO3_ARGS} ${WRKSRC}/lib
+	@${PY2TO3_CMD} ${PY2TO3_ARGS} ${WRKSRC}/doc
+	@${PY2TO3_CMD} ${PY2TO3_ARGS} ${WRKSRC}/examples
+.endif
+
+# C extensions are not supported with all versions of Python, so ignore
+# errors here if there are no .so files to strip.
+post-install:
+	-@${STRIP_CMD} ${STAGEDIR}${PYTHON_SITELIBDIR}/sqlalchemy/*.so
+
+post-install-DOCS-on:
+	@${MKDIR} ${STAGEDIR}${DOCSDIR}
+	cd ${WRKSRC}/doc/ && ${COPYTREE_SHARE} . ${STAGEDIR}${DOCSDIR}
+
+post-install-EXAMPLES-on:
+	@${MKDIR} ${STAGEDIR}${EXAMPLESDIR}
+	cd ${WRKSRC}/examples/ && ${COPYTREE_SHARE} . ${STAGEDIR}${EXAMPLESDIR}
+
+do-test:
+.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-sqlalchemy08/distinfo b/databases/py-sqlalchemy08/distinfo
new file mode 100644
index 000000000000..b1a74b7856ce
--- /dev/null
+++ b/databases/py-sqlalchemy08/distinfo
@@ -0,0 +1,3 @@
+TIMESTAMP = 1463498186
+SHA256 (SQLAlchemy-0.8.7.tar.gz) = 9edb47d137db42d57fd26673d6c841e189b1aeb9b566cca908962fcc8448c0bc
+SIZE (SQLAlchemy-0.8.7.tar.gz) = 3548308
diff --git a/databases/py-sqlalchemy/pkg-descr b/databases/py-sqlalchemy08/pkg-descr
index 84d56454ff4e..84d56454ff4e 100644
--- a/databases/py-sqlalchemy/pkg-descr
+++ b/databases/py-sqlalchemy08/pkg-descr
diff --git a/databases/py-sqlalchemy09/Makefile b/databases/py-sqlalchemy09/Makefile
new file mode 100644
index 000000000000..8a33a0199441
--- /dev/null
+++ b/databases/py-sqlalchemy09/Makefile
@@ -0,0 +1,81 @@
+# Created by: Dryice Dong Liu <dryice@dryice.name>
+# $FreeBSD$
+
+PORTNAME=	sqlalchemy
+PORTVERSION=	0.9.10
+CATEGORIES=	databases python
+MASTER_SITES=	CHEESESHOP
+PKGNAMEPREFIX=	${PYTHON_PKGNAMEPREFIX}
+PKGNAMESUFFIX=	09
+DISTNAME=	SQLAlchemy-${DISTVERSION}
+
+MAINTAINER=	m.tsatsenko@gmail.com
+COMMENT=	Python SQL toolkit and Object Relational Mapper 0.9.x
+
+LICENSE=	MIT
+
+TEST_DEPENDS=	${PYTHON_PKGNAMEPREFIX}pytest>0:devel/py-pytest \
+		${PYTHON_PKGNAMEPREFIX}mock>0:devel/py-mock
+
+USES=		python
+USE_PYTHON=	distutils autoplist
+
+PY2TO3_CMD=	${LOCALBASE}/bin/2to3-${PYTHON_VER}
+PY2TO3_ARGS=	--no-diffs --nobackups --verbose --write
+TEST_TARGET=	do-test
+
+CONFLICTS_INSTALL=	${PYTHON_PKGNAMEPREFIX}sqlalchemy{0[678],10}*
+
+OPTIONS_DEFINE=		DOCS EXAMPLES
+OPTIONS_MULTI=		BACKEND
+OPTIONS_MULTI_BACKEND=	MSSQL MYSQL PGSQL SQLITE SYBASE
+OPTIONS_DEFAULT=	SQLITE
+
+MSSQL_DESC=	MS SQL Server backend
+SYBASE_DESC=	Sybase backend
+
+MSSQL_RUN_DEPENDS=	${PYTHON_SITELIBDIR}/pymssql.py:databases/py-mssql
+PGSQL_RUN_DEPENDS=	${PYTHON_PKGNAMEPREFIX}psycopg2>=2.0.8:databases/py-psycopg2
+SQLITE_RUN_DEPENDS=	${PYTHON_PKGNAMEPREFIX}sqlite3>0:databases/py-sqlite3
+SYBASE_RUN_DEPENDS=	${PYTHON_SITELIBDIR}/Sybase.py:databases/py-sybase
+
+PORTDOCS=		*
+PORTEXAMPLES=		*
+
+.include <bsd.port.pre.mk>
+
+.if ${PYTHON_REL} < 3000
+MYSQL_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
+#MYSQL_RUN_DEPENDS=	pymysql>=0.5:databases/py-pymysql
+.endif
+
+pre-build:
+.if ${PYTHON_REL} >= 3000
+	@${PY2TO3_CMD} ${PY2TO3_ARGS} ${WRKSRC}/lib
+	@${PY2TO3_CMD} ${PY2TO3_ARGS} ${WRKSRC}/doc
+	@${PY2TO3_CMD} ${PY2TO3_ARGS} ${WRKSRC}/examples
+.endif
+
+# C extensions are not supported with all versions of Python, so ignore
+# errors here if there are no .so files to strip.
+post-install:
+	-@${STRIP_CMD} ${STAGEDIR}${PYTHON_SITELIBDIR}/sqlalchemy/*.so
+
+post-install-DOCS-on:
+	@${MKDIR} ${STAGEDIR}${DOCSDIR}
+	cd ${WRKSRC}/doc/ && ${COPYTREE_SHARE} . ${STAGEDIR}${DOCSDIR}
+
+post-install-EXAMPLES-on:
+	@${MKDIR} ${STAGEDIR}${EXAMPLESDIR}
+	cd ${WRKSRC}/examples/ && ${COPYTREE_SHARE} . ${STAGEDIR}${EXAMPLESDIR}
+
+do-test:
+.if ${PYTHON_REL} >= 3000
+	${PY2TO3_CMD} ${PY2TO3_ARGS} ${WRKSRC}/test
+.endif
+	@cd ${WRKSRC} && py.test
+
+.include <bsd.port.post.mk>
diff --git a/databases/py-sqlalchemy09/distinfo b/databases/py-sqlalchemy09/distinfo
new file mode 100644
index 000000000000..9d23737cd54f
--- /dev/null
+++ b/databases/py-sqlalchemy09/distinfo
@@ -0,0 +1,3 @@
+TIMESTAMP = 1463481163
+SHA256 (SQLAlchemy-0.9.10.tar.gz) = 445cba2d5e36b9334aa06c06e00fbedb71f1b1dd03d1d2763b6cf77b9cd6163b
+SIZE (SQLAlchemy-0.9.10.tar.gz) = 4274855
diff --git a/databases/py-sqlalchemy09/pkg-descr b/databases/py-sqlalchemy09/pkg-descr
new file mode 100644
index 000000000000..84d56454ff4e
--- /dev/null
+++ b/databases/py-sqlalchemy09/pkg-descr
@@ -0,0 +1,10 @@
+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-sqlalchemy10/Makefile b/databases/py-sqlalchemy10/Makefile
new file mode 100644
index 000000000000..6b7afc06e928
--- /dev/null
+++ b/databases/py-sqlalchemy10/Makefile
@@ -0,0 +1,81 @@
+# Created by: Dryice Dong Liu <dryice@dryice.name>
+# $FreeBSD$
+
+PORTNAME=	sqlalchemy
+PORTVERSION=	1.0.13
+CATEGORIES=	databases python
+MASTER_SITES=	CHEESESHOP
+PKGNAMEPREFIX=	${PYTHON_PKGNAMEPREFIX}
+PKGNAMESUFFIX=	10
+DISTNAME=	SQLAlchemy-${DISTVERSION}
+
+MAINTAINER=	m.tsatsenko@gmail.com
+COMMENT=	Python SQL toolkit and Object Relational Mapper 1.0.x
+
+LICENSE=	MIT
+
+TEST_DEPENDS=	${PYTHON_PKGNAMEPREFIX}pytest>0:devel/py-pytest \
+		${PYTHON_PKGNAMEPREFIX}mock>0:devel/py-mock
+
+USES=		python
+USE_PYTHON=	distutils autoplist
+
+PY2TO3_CMD=	${LOCALBASE}/bin/2to3-${PYTHON_VER}
+PY2TO3_ARGS=	--no-diffs --nobackups --verbose --write
+TEST_TARGET=	do-test
+
+CONFLICTS_INSTALL=	${PYTHON_PKGNAMEPREFIX}sqlalchemy0[6789]*
+
+OPTIONS_DEFINE=		DOCS EXAMPLES
+OPTIONS_MULTI=		BACKEND
+OPTIONS_MULTI_BACKEND=	MSSQL MYSQL PGSQL SQLITE SYBASE
+OPTIONS_DEFAULT=	SQLITE
+
+MSSQL_DESC=	MS SQL Server backend
+SYBASE_DESC=	Sybase backend
+
+MSSQL_RUN_DEPENDS=	${PYTHON_SITELIBDIR}/pymssql.py:databases/py-mssql
+PGSQL_RUN_DEPENDS=	${PYTHON_PKGNAMEPREFIX}psycopg2>=2.0.8:databases/py-psycopg2
+SQLITE_RUN_DEPENDS=	${PYTHON_PKGNAMEPREFIX}sqlite3>0:databases/py-sqlite3
+SYBASE_RUN_DEPENDS=	${PYTHON_SITELIBDIR}/Sybase.py:databases/py-sybase
+
+PORTDOCS=		*
+PORTEXAMPLES=		*
+
+.include <bsd.port.pre.mk>
+
+.if ${PYTHON_REL} < 3000
+MYSQL_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
+#MYSQL_RUN_DEPENDS+=	pymysql>=0.5:databases/py-pymysql
+.endif
+
+pre-build:
+.if ${PYTHON_REL} >= 3000
+	@${PY2TO3_CMD} ${PY2TO3_ARGS} ${WRKSRC}/lib
+	@${PY2TO3_CMD} ${PY2TO3_ARGS} ${WRKSRC}/doc
+	@${PY2TO3_CMD} ${PY2TO3_ARGS} ${WRKSRC}/examples
+.endif
+
+# C extensions are not supported with all versions of Python, so ignore
+# errors here if there are no .so files to strip.
+post-install:
+	-@${STRIP_CMD} ${STAGEDIR}${PYTHON_SITELIBDIR}/sqlalchemy/*.so
+
+post-install-DOCS-on:
+	@${MKDIR} ${STAGEDIR}${DOCSDIR}
+	cd ${WRKSRC}/doc/ && ${COPYTREE_SHARE} . ${STAGEDIR}${DOCSDIR}
+
+post-install-EXAMPLES-on:
+	@${MKDIR} ${STAGEDIR}${EXAMPLESDIR}
+	cd ${WRKSRC}/examples/ && ${COPYTREE_SHARE} . ${STAGEDIR}${EXAMPLESDIR}
+
+do-test:
+.if ${PYTHON_REL} >= 3000
+	${PY2TO3_CMD} ${PY2TO3_ARGS} ${WRKSRC}/test
+.endif
+	@cd ${WRKSRC} && py.test
+
+.include <bsd.port.post.mk>
diff --git a/databases/py-sqlalchemy10/distinfo b/databases/py-sqlalchemy10/distinfo
new file mode 100644
index 000000000000..ad8273ef45f5
--- /dev/null
+++ b/databases/py-sqlalchemy10/distinfo
@@ -0,0 +1,3 @@
+TIMESTAMP = 1463481609
+SHA256 (SQLAlchemy-1.0.13.tar.gz) = e755fd23b8bd574163d392ae85f41f6cd32eca8fe5bd7b5692de77265bb220cf
+SIZE (SQLAlchemy-1.0.13.tar.gz) = 4757399
diff --git a/databases/py-sqlalchemy10/pkg-descr b/databases/py-sqlalchemy10/pkg-descr
new file mode 100644
index 000000000000..84d56454ff4e
--- /dev/null
+++ b/databases/py-sqlalchemy10/pkg-descr
@@ -0,0 +1,10 @@
+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/