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/

PR:		ports/101920
Submitted by:	Dryice Liu <dryice@dryice.name>
Approved by:	krion (mentor)

11 files changed, 209 insertions, 0 deletions

diff --git a/databases/Makefile b/databases/Makefile
index 2d444f6eff65..365d66eeff1c 100644
--- a/databases/Makefile
+++ b/databases/Makefile
@@ -398,6 +398,7 @@
     SUBDIR += py-psycopg
     SUBDIR += py-psycopg2
     SUBDIR += py-pyPgSQL
+    SUBDIR += py-sqlalchemy
     SUBDIR += py-sqlite3
     SUBDIR += py-sqlobject
     SUBDIR += py-sqlrelay
diff --git a/databases/py-sqlalchemy/.pkg-descr.swp b/databases/py-sqlalchemy/.pkg-descr.swp
new file mode 100644
index 000000000000..169d7de3cdbb
--- /dev/null
+++ b/databases/py-sqlalchemy/.pkg-descr.swp
diff --git a/databases/py-sqlalchemy/Makefile b/databases/py-sqlalchemy/Makefile
new file mode 100644
index 000000000000..08db1ab89bc8
--- /dev/null
+++ b/databases/py-sqlalchemy/Makefile
@@ -0,0 +1,78 @@
+# Ports collection makefile for:	py-sqlalchemy
+# Date created:				12 Auguest 2004
+# Whom:					Dryice Dong Liu <dryice@dryice.name>
+#
+# $FreeBSD$
+#
+
+PORTNAME=	sqlalchemy
+PORTVERSION=	0.2.7
+CATEGORIES=	databases python
+MASTER_SITES=	${MASTER_SITE_SOURCEFORGE} \
+		http://cheeseshop.python.org/packages/source/S/SQLAlchemy/ \
+		http://dryice.name/computer/FreeBSD/distfiles/
+DISTNAME=	SQLAlchemy-${PORTVERSION}
+
+MAINTAINER=	dryice@dryice.name
+COMMENT=	A Python SQL toolkit and Object Relational Mapper
+
+USE_PYTHON=	2.3+
+PLIST_SUB+=	PORTVERSION=${PORTVERSION} \
+		PYTHONVERSION=${_PYTHON_VERSION} \
+		EXAMPLEDIR=share/examples/${PORTNAME}
+USE_PYDISTUTILS=	yes
+
+BUILD_DEPENDS+=		easy_install:${PORTSDIR}/devel/py-setuptools
+
+OPTIONS=	FIREBIRD "support FireBird" off
+OPTIONS+=	MSSQL "support MS SQL Server" off
+OPTIONS+=	MYSQL "support MySql" on
+OPTIONS+=	POSTGRE "support PostGreSQL" on
+OPTIONS+=	SQLITE "support Sqlite" on
+
+.if !defined(NOPORTDOCS)
+PORTDOCS=	adv_datamapping.html alphaapi.html \
+		alphaimplementation.html datamapping.html \
+		dbengine.html docs.css docstrings.html \
+		documentation.html index.html metadata.html \
+		plugins.html pooling.html scripts.js \
+		sqlconstruction.html style.css syntaxhighlight.css \
+		tutorial.html types.html unitofwork.html
+.endif
+
+.include <bsd.port.pre.mk>
+
+.if defined(WITH_FIREBIRD)
+RUN_DEPENDS+=	${PYTHON_SITELIBDIR}/kinterbasdb/__init__.py:${PORTSDIR}/databases/kinterbasdb
+.endif
+
+.if defined(WITH_MSSQL)
+RUN_DEPENDS+=	${PYTHON_SITELIBDIR}/pymssql.py:${PORTSDIR}/databases/py-mssql
+.endif
+
+.if !defined(WITHOUT_MYSQL)
+RUN_DEPENDS+=	${PYTHON_SITELIBDIR}/MySQLdb/__init__.py:${PORTSDIR}/databases/py-MySQLdb
+.endif
+
+.if !defined(WITHOUT_POSTGRE)
+RUN_DEPENDS+=	${PYTHON_SITELIBDIR}/psycopg2/__init__.py:${PORTSDIR}/databases/py-psycopg2
+.endif
+
+.if !defined(WITHOUT_SQLITE)
+RUN_DEPENDS+=	${PYTHON_SITELIBDIR}/pysqlite2/__init__.py:${PORTSDIR}/databases/py-pysqlite23
+.endif
+
+post-install:
+.if !defined(NOPORTDOCS)
+	${MKDIR} ${DOCSDIR}
+.for i in ${PORTDOCS}
+	${INSTALL_DATA} ${WRKSRC}/doc/${i} ${DOCSDIR}
+.endfor
+.endif
+
+	${MKDIR} ${EXAMPLESDIR}
+.for i in adjacencytree backref polymorph vertical
+	${CP} -r ${WRKSRC}/examples/${i} ${EXAMPLESDIR}
+.endfor
+
+.include <bsd.port.post.mk>
diff --git a/databases/py-sqlalchemy/distinfo b/databases/py-sqlalchemy/distinfo
new file mode 100644
index 000000000000..35a4227ea3d7
--- /dev/null
+++ b/databases/py-sqlalchemy/distinfo
@@ -0,0 +1,3 @@
+MD5 (SQLAlchemy-0.2.7.tar.gz) = d1c4e9f4c512d6d68e3e453f10df896e
+SHA256 (SQLAlchemy-0.2.7.tar.gz) = d12ff098ae9206114d0d024469b3f93cc4c9dc5febfd92390391c6155642f19e
+SIZE (SQLAlchemy-0.2.7.tar.gz) = 626974
diff --git a/databases/py-sqlalchemy/pkg-descr b/databases/py-sqlalchemy/pkg-descr
new file mode 100644
index 000000000000..84d56454ff4e
--- /dev/null
+++ b/databases/py-sqlalchemy/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-sqlalchemy/pkg-plist b/databases/py-sqlalchemy/pkg-plist
new file mode 100644
index 000000000000..19a9ef170800
--- /dev/null
+++ b/databases/py-sqlalchemy/pkg-plist
@@ -0,0 +1,13 @@
+%%PYTHON_SITELIBDIR%%/SQLAlchemy-%%PORTVERSION%%-py%%PYTHONVERSION%%.egg
+%%EXAMPLEDIR%%/adjacencytree/basic_tree.py
+%%EXAMPLEDIR%%/adjacencytree/byroot_tree.py
+%%EXAMPLEDIR%%/backref/backref_tree.py
+%%EXAMPLEDIR%%/polymorph/concrete.py
+%%EXAMPLEDIR%%/polymorph/polymorph.py
+%%EXAMPLEDIR%%/polymorph/single.py
+%%EXAMPLEDIR%%/vertical/vertical.py
+@dirrm %%EXAMPLEDIR%%/adjacencytree
+@dirrm %%EXAMPLEDIR%%/backref
+@dirrm %%EXAMPLEDIR%%/polymorph
+@dirrm %%EXAMPLEDIR%%/vertical
+@dirrm %%EXAMPLEDIR%%
diff --git a/databases/py-sqlalchemy06/.pkg-descr.swp b/databases/py-sqlalchemy06/.pkg-descr.swp
new file mode 100644
index 000000000000..169d7de3cdbb
--- /dev/null
+++ b/databases/py-sqlalchemy06/.pkg-descr.swp
diff --git a/databases/py-sqlalchemy06/Makefile b/databases/py-sqlalchemy06/Makefile
new file mode 100644
index 000000000000..08db1ab89bc8
--- /dev/null
+++ b/databases/py-sqlalchemy06/Makefile
@@ -0,0 +1,78 @@
+# Ports collection makefile for:	py-sqlalchemy
+# Date created:				12 Auguest 2004
+# Whom:					Dryice Dong Liu <dryice@dryice.name>
+#
+# $FreeBSD$
+#
+
+PORTNAME=	sqlalchemy
+PORTVERSION=	0.2.7
+CATEGORIES=	databases python
+MASTER_SITES=	${MASTER_SITE_SOURCEFORGE} \
+		http://cheeseshop.python.org/packages/source/S/SQLAlchemy/ \
+		http://dryice.name/computer/FreeBSD/distfiles/
+DISTNAME=	SQLAlchemy-${PORTVERSION}
+
+MAINTAINER=	dryice@dryice.name
+COMMENT=	A Python SQL toolkit and Object Relational Mapper
+
+USE_PYTHON=	2.3+
+PLIST_SUB+=	PORTVERSION=${PORTVERSION} \
+		PYTHONVERSION=${_PYTHON_VERSION} \
+		EXAMPLEDIR=share/examples/${PORTNAME}
+USE_PYDISTUTILS=	yes
+
+BUILD_DEPENDS+=		easy_install:${PORTSDIR}/devel/py-setuptools
+
+OPTIONS=	FIREBIRD "support FireBird" off
+OPTIONS+=	MSSQL "support MS SQL Server" off
+OPTIONS+=	MYSQL "support MySql" on
+OPTIONS+=	POSTGRE "support PostGreSQL" on
+OPTIONS+=	SQLITE "support Sqlite" on
+
+.if !defined(NOPORTDOCS)
+PORTDOCS=	adv_datamapping.html alphaapi.html \
+		alphaimplementation.html datamapping.html \
+		dbengine.html docs.css docstrings.html \
+		documentation.html index.html metadata.html \
+		plugins.html pooling.html scripts.js \
+		sqlconstruction.html style.css syntaxhighlight.css \
+		tutorial.html types.html unitofwork.html
+.endif
+
+.include <bsd.port.pre.mk>
+
+.if defined(WITH_FIREBIRD)
+RUN_DEPENDS+=	${PYTHON_SITELIBDIR}/kinterbasdb/__init__.py:${PORTSDIR}/databases/kinterbasdb
+.endif
+
+.if defined(WITH_MSSQL)
+RUN_DEPENDS+=	${PYTHON_SITELIBDIR}/pymssql.py:${PORTSDIR}/databases/py-mssql
+.endif
+
+.if !defined(WITHOUT_MYSQL)
+RUN_DEPENDS+=	${PYTHON_SITELIBDIR}/MySQLdb/__init__.py:${PORTSDIR}/databases/py-MySQLdb
+.endif
+
+.if !defined(WITHOUT_POSTGRE)
+RUN_DEPENDS+=	${PYTHON_SITELIBDIR}/psycopg2/__init__.py:${PORTSDIR}/databases/py-psycopg2
+.endif
+
+.if !defined(WITHOUT_SQLITE)
+RUN_DEPENDS+=	${PYTHON_SITELIBDIR}/pysqlite2/__init__.py:${PORTSDIR}/databases/py-pysqlite23
+.endif
+
+post-install:
+.if !defined(NOPORTDOCS)
+	${MKDIR} ${DOCSDIR}
+.for i in ${PORTDOCS}
+	${INSTALL_DATA} ${WRKSRC}/doc/${i} ${DOCSDIR}
+.endfor
+.endif
+
+	${MKDIR} ${EXAMPLESDIR}
+.for i in adjacencytree backref polymorph vertical
+	${CP} -r ${WRKSRC}/examples/${i} ${EXAMPLESDIR}
+.endfor
+
+.include <bsd.port.post.mk>
diff --git a/databases/py-sqlalchemy06/distinfo b/databases/py-sqlalchemy06/distinfo
new file mode 100644
index 000000000000..35a4227ea3d7
--- /dev/null
+++ b/databases/py-sqlalchemy06/distinfo
@@ -0,0 +1,3 @@
+MD5 (SQLAlchemy-0.2.7.tar.gz) = d1c4e9f4c512d6d68e3e453f10df896e
+SHA256 (SQLAlchemy-0.2.7.tar.gz) = d12ff098ae9206114d0d024469b3f93cc4c9dc5febfd92390391c6155642f19e
+SIZE (SQLAlchemy-0.2.7.tar.gz) = 626974
diff --git a/databases/py-sqlalchemy06/pkg-descr b/databases/py-sqlalchemy06/pkg-descr
new file mode 100644
index 000000000000..84d56454ff4e
--- /dev/null
+++ b/databases/py-sqlalchemy06/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-sqlalchemy06/pkg-plist b/databases/py-sqlalchemy06/pkg-plist
new file mode 100644
index 000000000000..19a9ef170800
--- /dev/null
+++ b/databases/py-sqlalchemy06/pkg-plist
@@ -0,0 +1,13 @@
+%%PYTHON_SITELIBDIR%%/SQLAlchemy-%%PORTVERSION%%-py%%PYTHONVERSION%%.egg
+%%EXAMPLEDIR%%/adjacencytree/basic_tree.py
+%%EXAMPLEDIR%%/adjacencytree/byroot_tree.py
+%%EXAMPLEDIR%%/backref/backref_tree.py
+%%EXAMPLEDIR%%/polymorph/concrete.py
+%%EXAMPLEDIR%%/polymorph/polymorph.py
+%%EXAMPLEDIR%%/polymorph/single.py
+%%EXAMPLEDIR%%/vertical/vertical.py
+@dirrm %%EXAMPLEDIR%%/adjacencytree
+@dirrm %%EXAMPLEDIR%%/backref
+@dirrm %%EXAMPLEDIR%%/polymorph
+@dirrm %%EXAMPLEDIR%%/vertical
+@dirrm %%EXAMPLEDIR%%