aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--MOVED2
-rw-r--r--databases/Makefile6
-rw-r--r--databases/py-alembic/Makefile2
-rw-r--r--databases/py-flask-sqlalchemy/Makefile2
-rw-r--r--databases/py-geoalchemy/Makefile2
-rw-r--r--databases/py-geoalchemy2/Makefile2
-rw-r--r--databases/py-sqlalchemy-devel/Makefile99
-rw-r--r--databases/py-sqlalchemy-devel/distinfo2
-rw-r--r--databases/py-sqlalchemy-migrate/Makefile2
-rw-r--r--databases/py-sqlalchemy/Makefile117
-rw-r--r--databases/py-sqlalchemy/pkg-plist113
-rw-r--r--databases/py-sqlalchemy06/Makefile8
-rw-r--r--databases/py-sqlalchemy07/Makefile90
-rw-r--r--databases/py-sqlalchemy07/distinfo (renamed from databases/py-sqlalchemy/distinfo)1
-rw-r--r--databases/py-sqlalchemy07/pkg-descr (renamed from databases/py-sqlalchemy-devel/pkg-descr)0
-rw-r--r--databases/py-sqlalchemy08/Makefile81
-rw-r--r--databases/py-sqlalchemy08/distinfo3
-rw-r--r--databases/py-sqlalchemy08/pkg-descr (renamed from databases/py-sqlalchemy/pkg-descr)0
-rw-r--r--databases/py-sqlalchemy09/Makefile81
-rw-r--r--databases/py-sqlalchemy09/distinfo3
-rw-r--r--databases/py-sqlalchemy09/pkg-descr10
-rw-r--r--databases/py-sqlalchemy10/Makefile81
-rw-r--r--databases/py-sqlalchemy10/distinfo3
-rw-r--r--databases/py-sqlalchemy10/pkg-descr10
-rw-r--r--deskutils/gourmet/Makefile2
-rw-r--r--devel/buildbot/Makefile2
-rw-r--r--games/anki/Makefile2
-rw-r--r--games/childsplay/Makefile2
-rw-r--r--games/pyfa/Makefile2
-rw-r--r--irc/py-limnoria/Makefile2
-rw-r--r--math/py-pandas/Makefile11
-rw-r--r--multimedia/py-openlp/Makefile4
-rw-r--r--net/py-kombu/Makefile2
-rw-r--r--science/py-obspy/Makefile2
-rw-r--r--textproc/py-wtforms/Makefile2
-rw-r--r--www/geeknote/Makefile2
-rw-r--r--www/py-bottle-cork/Makefile2
-rw-r--r--www/py-flexget/Makefile2
-rw-r--r--www/py-imdbpy/Makefile2
-rw-r--r--www/py-rhodecode/Makefile2
-rw-r--r--www/py-turbogears2/Makefile2
41 files changed, 400 insertions, 365 deletions
diff --git a/MOVED b/MOVED
index f9d113a8a7bf..13a1580aaa0c 100644
--- a/MOVED
+++ b/MOVED
@@ -8326,3 +8326,5 @@ devel/py-gyp-devel|devel/py-gyp|2016-05-16|Renamed to devel/py-gyp
sysutils/relaunchd|sysutils/jobd|2016-05-20|Renamed to sysutils/jobd
dns/nsd3|dns/nsd|2016-05-20|Has expired: NSD 3 is EOL, please upgrade to NSD 4 in dns/nsd
security/easypg||2016-05-22|Has expired: Included into emacs since 2.3
+databases/py-sqlalchemy|databases/py-sqlalchemy07|2016-05-18|Renamed to databases/py-sqlalchemy07
+databases/py-sqlalchemy-devel|databases/py-sqlalchemy08|2016-05-18|Renamed to databases/py-sqlalchemy08
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/
diff --git a/deskutils/gourmet/Makefile b/deskutils/gourmet/Makefile
index 4c083ee1dd00..d12c9101f3c8 100644
--- a/deskutils/gourmet/Makefile
+++ b/deskutils/gourmet/Makefile
@@ -15,7 +15,7 @@ LICENSE_FILE= ${WRKSRC}/LICENSE
BUILD_DEPENDS= ${PYTHON_PKGNAMEPREFIX}python-distutils-extra>0:devel/py-python-distutils-extra \
${PYTHON_PKGNAMEPREFIX}elib.intl>0:textproc/py-elib.intl
RUN_DEPENDS= ${PYTHON_PKGNAMEPREFIX}sqlite3>=0:databases/py-sqlite3 \
- ${PYTHON_PKGNAMEPREFIX}sqlalchemy>=0:databases/py-sqlalchemy \
+ ${PYTHON_PKGNAMEPREFIX}sqlalchemy07>=0:databases/py-sqlalchemy07 \
${PYTHON_PKGNAMEPREFIX}pillow>0:graphics/py-pillow \
${PYTHON_PKGNAMEPREFIX}poppler>=0:graphics/py-poppler \
${PYTHON_PKGNAMEPREFIX}rtf>=0:print/py-rtf \
diff --git a/devel/buildbot/Makefile b/devel/buildbot/Makefile
index bf86972ad689..850f7cff42cb 100644
--- a/devel/buildbot/Makefile
+++ b/devel/buildbot/Makefile
@@ -17,7 +17,7 @@ RUN_DEPENDS= ${PYTHON_PKGNAMEPREFIX}twisted>=11.0.0:devel/py-twisted \
${PYTHON_PKGNAMEPREFIX}Jinja2>=2.1:devel/py-Jinja2 \
${PYTHON_PKGNAMEPREFIX}dateutil>=2.1:devel/py-dateutil \
${PYTHON_PKGNAMEPREFIX}sqlalchemy-migrate>=0.7:databases/py-sqlalchemy-migrate \
- ${PYTHON_PKGNAMEPREFIX}sqlalchemy>=0.6:databases/py-sqlalchemy \
+ ${PYTHON_PKGNAMEPREFIX}sqlalchemy07>=0.6:databases/py-sqlalchemy07 \
${PYTHON_PKGNAMEPREFIX}sqlite3>0:databases/py-sqlite3
TEST_DEPENDS= trial:devel/py-twisted \
${PYTHON_PKGNAMEPREFIX}mock>0.8.0:devel/py-mock \
diff --git a/games/anki/Makefile b/games/anki/Makefile
index c7ae4c3b9434..6e860b0db928 100644
--- a/games/anki/Makefile
+++ b/games/anki/Makefile
@@ -16,7 +16,7 @@ LICENSE_FILE= ${WRKSRC}/LICENSE
RUN_DEPENDS= lame:audio/lame \
mplayer:multimedia/mplayer \
${PYTHON_PKGNAMEPREFIX}pyaudio>0:audio/py-pyaudio \
- ${PYTHON_PKGNAMEPREFIX}sqlalchemy>0:databases/py-sqlalchemy \
+ ${PYTHON_PKGNAMEPREFIX}sqlalchemy07>0:databases/py-sqlalchemy07 \
${PYTHON_PKGNAMEPREFIX}sqlite3>0:databases/py-sqlite3 \
${PYTHON_PKGNAMEPREFIX}qt4-network>=4.4:net/py-qt4-network \
${PYTHON_PKGNAMEPREFIX}beautifulsoup32>=0:www/py-beautifulsoup32 \
diff --git a/games/childsplay/Makefile b/games/childsplay/Makefile
index e4672a9325b4..d503fc81da7c 100644
--- a/games/childsplay/Makefile
+++ b/games/childsplay/Makefile
@@ -13,7 +13,7 @@ LICENSE= GPLv3 # only
LICENSE_FILE= ${WRKSRC}/gpl-3.0.txt
BUILD_DEPENDS= ${PYTHON_PKGNAMEPREFIX}game>0:devel/py-game
-RUN_DEPENDS= ${PYTHON_PKGNAMEPREFIX}sqlalchemy>0:databases/py-sqlalchemy \
+RUN_DEPENDS= ${PYTHON_PKGNAMEPREFIX}sqlalchemy07>0:databases/py-sqlalchemy07 \
${PYTHON_PKGNAMEPREFIX}game>0:devel/py-game
NO_BUILD= yes
diff --git a/games/pyfa/Makefile b/games/pyfa/Makefile
index e6c90d83586c..a0cff33a078c 100644
--- a/games/pyfa/Makefile
+++ b/games/pyfa/Makefile
@@ -13,7 +13,7 @@ LICENSE= GPLv3+
LICENSE_FILE= ${WRKSRC}/LICENSE
RUN_DEPENDS= ${PYTHON_PKGNAMEPREFIX}dateutil>0:devel/py-dateutil \
- ${PYTHON_PKGNAMEPREFIX}sqlalchemy>=0.6:databases/py-sqlalchemy \
+ ${PYTHON_PKGNAMEPREFIX}sqlalchemy07>=0.6:databases/py-sqlalchemy07 \
${PYTHON_PKGNAMEPREFIX}requests>=2.3.0:www/py-requests
USE_GITHUB= yes
diff --git a/irc/py-limnoria/Makefile b/irc/py-limnoria/Makefile
index a13a560ab300..0f73bf63445b 100644
--- a/irc/py-limnoria/Makefile
+++ b/irc/py-limnoria/Makefile
@@ -15,7 +15,7 @@ RUN_DEPENDS= ${PYTHON_PKGNAMEPREFIX}chardet>=0:textproc/py-chardet \
${PYTHON_PKGNAMEPREFIX}dateutil>=0:devel/py-dateutil \
${PYTHON_PKGNAMEPREFIX}python-gnupg>=0:security/py-python-gnupg \
${PYTHON_PKGNAMEPREFIX}feedparser>=0:textproc/py-feedparser \
- ${PYTHON_PKGNAMEPREFIX}sqlalchemy>=0:databases/py-sqlalchemy \
+ ${PYTHON_PKGNAMEPREFIX}sqlalchemy07>=0:databases/py-sqlalchemy07 \
${PYTHON_PKGNAMEPREFIX}pysocks>=0:net/py-pysocks \
${PYTHON_PKGNAMEPREFIX}ecdsa>0:security/py-ecdsa
diff --git a/math/py-pandas/Makefile b/math/py-pandas/Makefile
index b64ec8a7fc0d..64734467362e 100644
--- a/math/py-pandas/Makefile
+++ b/math/py-pandas/Makefile
@@ -19,7 +19,7 @@ RUN_DEPENDS:= ${BUILD_DEPENDS} \
TEST_DEPENDS:= ${RUN_DEPENDS} \
nosetests-${PYTHON_VER}:devel/py-nose \
cython:lang/cython \
- ${PYTHON_PKGNAMEPREFIX}sqlalchemy>0:databases/py-sqlalchemy \
+ ${PYTHON_PKGNAMEPREFIX}sqlalchemy08>0:databases/py-sqlalchemy08 \
${PYTHON_PKGNAMEPREFIX}boto>0:devel/py-boto \
${PYTHON_PKGNAMEPREFIX}lxml>0:devel/py-lxml \
${PYTHON_PKGNAMEPREFIX}tables>=3.0.0:devel/py-tables \
@@ -51,7 +51,7 @@ BTLNCK_DESC= Accelerate certain NaN evals via math/py-bottleneck
NUMEXPR_DESC= Accelerate certain numerical ops via math/py-numexpr
BOTO_DESC= Support Amazon S3 storage via devel/py-boto
TABLES_DESC= Support HDF5-based storage via devel/py-tables
-SQL_DESC= Support SQL databases via databases/py-sqlalchemy
+SQL_DESC= Support SQL databases via databases/py-sqlalchemy08
LXML_DESC= Parse HTML with devel/py-lxml and www/py-beautifulsoup
JINJA2_DESC= Support conditional HTML formatting with devel/py-Jinja2
HTML5LIB_DESC= Parse HTML with www/py-html5lib and www/py-beautifulsoup
@@ -70,12 +70,7 @@ BTLNCK_RUN_DEPENDS= ${PYTHON_PKGNAMEPREFIX}bottleneck>0:math/py-bottleneck
NUMEXPR_RUN_DEPENDS= ${PYTHON_PKGNAMEPREFIX}numexpr>=2.1.0:math/py-numexpr
BOTO_RUN_DEPENDS= ${PYTHON_PKGNAMEPREFIX}boto>0:devel/py-boto
TABLES_RUN_DEPENDS= ${PYTHON_PKGNAMEPREFIX}tables>=3.0.0:devel/py-tables
-# Note: upstream recommends SQLAlchemy 0.8.1 or higher, which is not
-# available in the ports tree as of this writing
-# See: https://reviews.freebsd.org/D908
-# See: https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=191442
-# See: https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=205852
-SQL_RUN_DEPENDS= ${PYTHON_PKGNAMEPREFIX}sqlalchemy>0:databases/py-sqlalchemy
+SQL_RUN_DEPENDS= ${PYTHON_PKGNAMEPREFIX}sqlalchemy08>0:databases/py-sqlalchemy08
LXML_RUN_DEPENDS= ${PYTHON_PKGNAMEPREFIX}lxml>0:devel/py-lxml
HTML5LIB_RUN_DEPENDS= ${PYTHON_PKGNAMEPREFIX}html5lib>0:www/py-html5lib
diff --git a/multimedia/py-openlp/Makefile b/multimedia/py-openlp/Makefile
index 4bd480b44cc8..933d92046cf4 100644
--- a/multimedia/py-openlp/Makefile
+++ b/multimedia/py-openlp/Makefile
@@ -15,12 +15,12 @@ BUILD_DEPENDS= ${PYTHON_PKGNAMEPREFIX}sip>=0:devel/py-sip \
${PYTHON_PKGNAMEPREFIX}qt4-core>=0:devel/py-qt4-core \
${PYTHON_PKGNAMEPREFIX}qt4-gui>=0:x11-toolkits/py-qt4-gui \
${PYTHON_PKGNAMEPREFIX}mako>0:textproc/py-mako \
- ${PYTHON_PKGNAMEPREFIX}sqlalchemy>=0.5:databases/py-sqlalchemy
+ ${PYTHON_PKGNAMEPREFIX}sqlalchemy07>=0.5:databases/py-sqlalchemy07
RUN_DEPENDS= ${PYTHON_PKGNAMEPREFIX}beautifulsoup32>0:www/py-beautifulsoup32 \
${PYTHON_PKGNAMEPREFIX}lxml>=0:devel/py-lxml \
${PYTHON_PKGNAMEPREFIX}qt4-core>=0:devel/py-qt4-core \
${PYTHON_PKGNAMEPREFIX}qt4-phonon>=0:multimedia/py-qt4-phonon \
- ${PYTHON_PKGNAMEPREFIX}sqlalchemy>=0.5:databases/py-sqlalchemy \
+ ${PYTHON_PKGNAMEPREFIX}sqlalchemy07>=0.5:databases/py-sqlalchemy07 \
${PYTHON_PKGNAMEPREFIX}qt4-gui>=0:x11-toolkits/py-qt4-gui \
${PYTHON_PKGNAMEPREFIX}qt4-webkit>=0:www/py-qt4-webkit \
${PYTHON_PKGNAMEPREFIX}qt4-network>=0:net/py-qt4-network \
diff --git a/net/py-kombu/Makefile b/net/py-kombu/Makefile
index 00565dfdc731..9ed90f29de52 100644
--- a/net/py-kombu/Makefile
+++ b/net/py-kombu/Makefile
@@ -28,7 +28,7 @@ BEANSTALK_RUN_DEPENDS= ${PYTHON_PKGNAMEPREFIX}beanstalkc>0:net/py-beanstalkc
BOTO_RUN_DEPENDS= ${PYTHON_PKGNAMEPREFIX}boto>=2.6.0:devel/py-boto
MONGODB_RUN_DEPENDS= ${PYTHON_PKGNAMEPREFIX}pymongo>0:databases/pymongo
REDIS_RUN_DEPENDS= ${PYTHON_PKGNAMEPREFIX}redis>0:databases/py-redis
-SQLALCHEMY_RUN_DEPENDS= ${PYTHON_PKGNAMEPREFIX}sqlalchemy>0:databases/py-sqlalchemy
+SQLALCHEMY_RUN_DEPENDS= ${PYTHON_PKGNAMEPREFIX}sqlalchemy07>0:databases/py-sqlalchemy07
ZMQ_RUN_DEPENDS= ${PYTHON_PKGNAMEPREFIX}pyzmq>=13.1.0:net/py-pyzmq
diff --git a/science/py-obspy/Makefile b/science/py-obspy/Makefile
index c5ba0ee3f929..632689736559 100644
--- a/science/py-obspy/Makefile
+++ b/science/py-obspy/Makefile
@@ -20,7 +20,7 @@ BUILD_DEPENDS= ${PYNUMPY} \
${PYTHON_PKGNAMEPREFIX}suds>=0.4.0:net/py-suds \
${PYTHON_PKGNAMEPREFIX}requests>=0:www/py-requests \
${PYTHON_PKGNAMEPREFIX}decorator>=0:devel/py-decorator \
- ${PYTHON_PKGNAMEPREFIX}sqlalchemy>=0:databases/py-sqlalchemy
+ ${PYTHON_PKGNAMEPREFIX}sqlalchemy07>=0:databases/py-sqlalchemy07
RUN_DEPENDS:= ${BUILD_DEPENDS}
USES= fortran python shebangfix zip
diff --git a/textproc/py-wtforms/Makefile b/textproc/py-wtforms/Makefile
index 176132d82bdc..8c00c924e7c1 100644
--- a/textproc/py-wtforms/Makefile
+++ b/textproc/py-wtforms/Makefile
@@ -16,7 +16,7 @@ LICENSE_FILE= ${WRKSRC}/LICENSE.txt
RUN_DEPENDS= ${PYTHON_PKGNAMEPREFIX}Babel>0:devel/py-babel
TEST_DEPENDS= ${PYTHON_PKGNAMEPREFIX}coverage>0:devel/py-coverage \
- ${PYTHON_PKGNAMEPREFIX}sqlalchemy08>0:databases/py-sqlalchemy-devel \
+ ${PYTHON_PKGNAMEPREFIX}sqlalchemy08>0:databases/py-sqlalchemy08 \
${PYTHON_PKGNAMEPREFIX}pep8>0:devel/pep8 \
${PYTHON_PKGNAMEPREFIX}dateutil>0:devel/py-dateutil
diff --git a/www/geeknote/Makefile b/www/geeknote/Makefile
index 7870e2b6728b..a5e35d9ab77e 100644
--- a/www/geeknote/Makefile
+++ b/www/geeknote/Makefile
@@ -13,7 +13,7 @@ LICENSE= GPLv2
RUN_DEPENDS= ${PYTHON_PKGNAMEPREFIX}evernote>=1.17:www/py-evernote \
${PYTHON_PKGNAMEPREFIX}html2text>0:textproc/py-html2text \
- ${PYTHON_PKGNAMEPREFIX}sqlalchemy>0:databases/py-sqlalchemy \
+ ${PYTHON_PKGNAMEPREFIX}sqlalchemy07>0:databases/py-sqlalchemy07 \
${PYTHON_PKGNAMEPREFIX}markdown2>0:textproc/py-markdown2 \
${PYTHON_PKGNAMEPREFIX}beautifulsoup>=4.0:www/py-beautifulsoup \
${PYTHON_PKGNAMEPREFIX}thrift>0:devel/py-thrift
diff --git a/www/py-bottle-cork/Makefile b/www/py-bottle-cork/Makefile
index 508b957147cd..cfa411c37b7c 100644
--- a/www/py-bottle-cork/Makefile
+++ b/www/py-bottle-cork/Makefile
@@ -27,7 +27,7 @@ OPTIONS_DEFINE= SQLITE MONGODB SQLALCHEMY EXAMPLES
SQLITE_RUN_DEPENDS= ${PYTHON_PKGNAMEPREFIX}sqlite3>0:databases/py-sqlite3
MONGODB_RUN_DEPENDS= ${PYTHON_PKGNAMEPREFIX}pymongo>0:databases/pymongo
-SQLALCHEMY_RUN_DEPENDS= ${PYTHON_PKGNAMEPREFIX}sqlalchemy>0:databases/py-sqlalchemy
+SQLALCHEMY_RUN_DEPENDS= ${PYTHON_PKGNAMEPREFIX}sqlalchemy07>0:databases/py-sqlalchemy07
.if ${PORT_OPTIONS:MEXAMPLES}
post-install:
diff --git a/www/py-flexget/Makefile b/www/py-flexget/Makefile
index acf9f4743d32..56c36140453f 100644
--- a/www/py-flexget/Makefile
+++ b/www/py-flexget/Makefile
@@ -16,7 +16,7 @@ LICENSE= MIT
BUILD_DEPENDS= ${PYTHON_PKGNAMEPREFIX}paver>=0:devel/py-paver
RUN_DEPENDS= ${PYTHON_PKGNAMEPREFIX}feedparser>=5.1.3:textproc/py-feedparser \
- ${PYTHON_PKGNAMEPREFIX}sqlalchemy>=0.7.5:databases/py-sqlalchemy \
+ ${PYTHON_PKGNAMEPREFIX}sqlalchemy07>=0.7.5:databases/py-sqlalchemy07 \
${PYTHON_PKGNAMEPREFIX}yaml>0:devel/py-yaml \
${PYTHON_SITELIBDIR}/BeautifulSoup.py:www/py-beautifulsoup32 \
${PYTHON_SITELIBDIR}/bs4/__init__.py:www/py-beautifulsoup \
diff --git a/www/py-imdbpy/Makefile b/www/py-imdbpy/Makefile
index 18c12a7ba869..b2cf67a00473 100644
--- a/www/py-imdbpy/Makefile
+++ b/www/py-imdbpy/Makefile
@@ -17,7 +17,7 @@ LICENSE_COMB= dual
RUN_DEPENDS= ${PYTHON_PKGNAMEPREFIX}lxml>=0:devel/py-lxml \
${PYTHON_PKGNAMEPREFIX}sqlalchemy-migrate>=0.6.1:databases/py-sqlalchemy-migrate \
- ${PYTHON_PKGNAMEPREFIX}sqlalchemy>=0:databases/py-sqlalchemy \
+ ${PYTHON_PKGNAMEPREFIX}sqlalchemy07>=0:databases/py-sqlalchemy07 \
${PYTHON_PKGNAMEPREFIX}sqlobject>=0:databases/py-sqlobject
OPTIONS_DEFINE= DOCS
diff --git a/www/py-rhodecode/Makefile b/www/py-rhodecode/Makefile
index 513bf811dae9..4349994444b2 100644
--- a/www/py-rhodecode/Makefile
+++ b/www/py-rhodecode/Makefile
@@ -21,7 +21,7 @@ RUN_DEPENDS= ${PYTHON_PKGNAMEPREFIX}pylons>=1.0:www/py-pylons \
${PYTHON_PKGNAMEPREFIX}formencode>=1.2.4:www/py-formencode \
${PYTHON_PKGNAMEPREFIX}webhelpers>=1.3:www/py-webhelpers \
${PYTHON_PKGNAMEPREFIX}mako>=0.7.3:textproc/py-mako \
- ${PYTHON_PKGNAMEPREFIX}sqlalchemy>=0.7.10:databases/py-sqlalchemy \
+ ${PYTHON_PKGNAMEPREFIX}sqlalchemy07>=0.7.10:databases/py-sqlalchemy07 \
${PYTHON_PKGNAMEPREFIX}pygments>=1.5:textproc/py-pygments \
${PYTHON_PKGNAMEPREFIX}whoosh>=2.4.0:textproc/py-whoosh \
${PYTHON_PKGNAMEPREFIX}Babel>=0.9.6:devel/py-babel \
diff --git a/www/py-turbogears2/Makefile b/www/py-turbogears2/Makefile
index 2271726a4a70..edc60448183a 100644
--- a/www/py-turbogears2/Makefile
+++ b/www/py-turbogears2/Makefile
@@ -24,7 +24,7 @@ RUN_DEPENDS= ${PYTHON_PKGNAMEPREFIX}ToscaWidgets>=0.9.4:devel/py-ToscaWidgets \
${PYTHON_PKGNAMEPREFIX}coverage>=0:devel/py-coverage \
${PYTHON_PKGNAMEPREFIX}nose>=0:devel/py-nose \
${PYTHON_PKGNAMEPREFIX}TurboKid>=1.0.4:devel/py-turbokid \
- ${PYTHON_PKGNAMEPREFIX}sqlalchemy>=0.4:databases/py-sqlalchemy \
+ ${PYTHON_PKGNAMEPREFIX}sqlalchemy07>=0.4:databases/py-sqlalchemy07 \
${PYTHON_PKGNAMEPREFIX}Jinja2>=0:devel/py-Jinja2 \
${PYTHON_PKGNAMEPREFIX}Chameleon>=2.0:textproc/py-Chameleon \
${PYTHON_PKGNAMEPREFIX}mako>=0:textproc/py-mako \