5 files changed, 104 insertions, 0 deletions

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%%