add py-psycopg 1.0.6

The high perfomance Python adapter for PostgreSQL

PR:		36207
Submitted by:	Alex Rodioukov <simuran@shaw.ca>

6 files changed, 121 insertions, 0 deletions

diff --git a/databases/Makefile b/databases/Makefile
index cbba01aed1b3..e5fcf39c41ad 100644
--- a/databases/Makefile
+++ b/databases/Makefile
@@ -108,6 +108,7 @@
     SUBDIR += py-bsddb3
     SUBDIR += py-cdb
     SUBDIR += py-gdbm
+    SUBDIR += py-psycopg
     SUBDIR += py-pyPgSQL
     SUBDIR += py-sqlrelay
     SUBDIR += rdb
diff --git a/databases/py-psycopg/Makefile b/databases/py-psycopg/Makefile
new file mode 100644
index 000000000000..2bef467f9c69
--- /dev/null
+++ b/databases/py-psycopg/Makefile
@@ -0,0 +1,73 @@
+# New ports collection makefile for:	py-psycopg
+# Date created:		22 March 2002
+# Whom:			Alex Rodioukov <simuran@shaw.ca>
+#
+# $FreeBSD$
+#
+
+PORTNAME=	psycopg
+PORTVERSION=	1.0.6
+CATEGORIES=	databases python
+MASTER_SITES=	http://initd.org/pub/software/psycopg/
+PKGNAMEPREFIX=	${PYTHON_PKGNAMEPREFIX}
+DISTNAME=	psycopg-${PORTVERSION}
+
+MAINTAINER=	simuran@shaw.ca
+
+RUN_DEPENDS=	${DATETIME_DEP}:${PORTSDIR}/lang/py-mx-base
+BUILD_DEPENDS=	${DATETIME_DEP}:${PORTSDIR}/lang/py-mx-base
+LIB_DEPENDS=	pq.2:${PORTSDIR}/databases/postgresql7
+
+USE_GMAKE=	yes
+USE_PYTHON=	yes
+GNU_CONFIGURE=	yes
+
+ALL_TARGET=	sharedmods
+
+CONFIGURE_ARGS=	--with-python=${PYTHON_CMD} \
+		--with-postgres-libraries=${LOCALBASE}/lib \
+		--with-postgres-includes=${LOCALBASE}/include/pgsql \
+		--with-postgres-includes=${LOCALBASE}/include \
+		--with-mxdatetime-includes=${DATETIME_INC}
+
+DATETIME_DEP=	${PYTHON_SITELIBDIR}/mx/DateTime/__init__.py
+DATETIME_INC=	${PYTHON_SITELIBDIR}/mx/DateTime/mxDateTime/
+
+DOCSDIR=	${PREFIX}/share/doc/py-psycopg
+EXAMPLESDIR=	${PREFIX}/share/examples/py-psycopg
+
+EXAMPLES=	binary.py commit.py dictfetch.py dt.py first.py oid.py \
+		somehackers.jpg threads.py usercast.py whereareyou.jpg \
+		work.py
+
+DOCS=		AUTHORS COPYING CREDITS ChangeLog FAQ NEWS README \
+		RELEASE-1.0 SUCCESS TODO
+
+TEXDOCS=	dbapi20programming.tex dbapiext.tex psycopg-guide.tex
+
+do-install:
+	${INSTALL_PROGRAM} ${WRKSRC}/psycopgmodule.so \
+		${PYTHON_SITELIBDIR}
+
+.if !defined(NOPORTDOCS)
+post-install:
+	${MKDIR} ${EXAMPLESDIR}
+.for file in ${EXAMPLES}
+	${INSTALL_DATA} ${WRKSRC}/doc/examples/${file} ${EXAMPLESDIR}
+.endfor
+	${MKDIR} ${DOCSDIR}
+.for file in ${DOCS}
+	${INSTALL_MAN} ${WRKSRC}/${file} ${DOCSDIR}
+.endfor
+.for file in ${TEXDOCS}
+	${INSTALL_MAN} ${WRKSRC}/doc/${file} ${DOCSDIR}
+.endfor
+.else
+PLIST=	${WRKDIR}/PLIST.nodocs
+pre-install:
+	${RM} -f ${PLIST}
+	${GREP} -E -v '^(@dirrm )?(share/examples/)|(share/doc/)' \
+		${PKGDIR}/pkg-plist > ${PLIST}
+.endif
+
+.include <bsd.port.mk>
diff --git a/databases/py-psycopg/distinfo b/databases/py-psycopg/distinfo
new file mode 100644
index 000000000000..e8bf83bdd1de
--- /dev/null
+++ b/databases/py-psycopg/distinfo
@@ -0,0 +1 @@
+MD5 (psycopg-1.0.6.tar.gz) = 6f74be8734fec439f4f87440503aeb4e
diff --git a/databases/py-psycopg/pkg-comment b/databases/py-psycopg/pkg-comment
new file mode 100644
index 000000000000..d643a9a1a170
--- /dev/null
+++ b/databases/py-psycopg/pkg-comment
@@ -0,0 +1 @@
+The high perfomance Python adapter for PostgreSQL
diff --git a/databases/py-psycopg/pkg-descr b/databases/py-psycopg/pkg-descr
new file mode 100644
index 000000000000..89896794c063
--- /dev/null
+++ b/databases/py-psycopg/pkg-descr
@@ -0,0 +1,18 @@
+psycopg is a PostgreSQL database adapter for the Python programming
+language. It was written from scratch with the aim of being very small and
+fast, and stable as a rock. The main advantages of psycopg are that it
+supports the full Python DBAPI-2.0 and being thread safe at level 2.
+
+psycopg is different from the other database adapter because it was designed
+for heavily multi-threaded applications that create and destroy lots of
+cursors and make a conspicuous number of concurrent INSERTs or UPDATEs.
+Every open Python connection keeps a pool of real (UNIX or TCP/IP)
+connections to the database. Every time a new cursor is created, a new
+connection does not need to be opened; instead one of the unused connections
+from the pool is used. That makes psycopg very fast in typical client-server
+applications that create a servicing thread every time a client request
+arrives.
+
+WWW: http://initd.org/software/psycopg
+
+- Alex Rodioukov <simuran@shaw.ca>
diff --git a/databases/py-psycopg/pkg-plist b/databases/py-psycopg/pkg-plist
new file mode 100644
index 000000000000..b21fed1ffa07
--- /dev/null
+++ b/databases/py-psycopg/pkg-plist
@@ -0,0 +1,27 @@
+%%PORTDOCS%%share/doc/py-psycopg/AUTHORS
+%%PORTDOCS%%share/doc/py-psycopg/COPYING
+%%PORTDOCS%%share/doc/py-psycopg/CREDITS
+%%PORTDOCS%%share/doc/py-psycopg/ChangeLog
+%%PORTDOCS%%share/doc/py-psycopg/FAQ
+%%PORTDOCS%%share/doc/py-psycopg/NEWS
+%%PORTDOCS%%share/doc/py-psycopg/README
+%%PORTDOCS%%share/doc/py-psycopg/RELEASE-1.0
+%%PORTDOCS%%share/doc/py-psycopg/SUCCESS
+%%PORTDOCS%%share/doc/py-psycopg/TODO
+%%PORTDOCS%%share/doc/py-psycopg/dbapi20programming.tex
+%%PORTDOCS%%share/doc/py-psycopg/dbapiext.tex
+%%PORTDOCS%%share/doc/py-psycopg/psycopg-guide.tex
+%%PORTDOCS%%share/examples/py-psycopg/binary.py
+%%PORTDOCS%%share/examples/py-psycopg/commit.py
+%%PORTDOCS%%share/examples/py-psycopg/dictfetch.py
+%%PORTDOCS%%share/examples/py-psycopg/dt.py
+%%PORTDOCS%%share/examples/py-psycopg/first.py
+%%PORTDOCS%%share/examples/py-psycopg/oid.py
+%%PORTDOCS%%share/examples/py-psycopg/somehackers.jpg
+%%PORTDOCS%%share/examples/py-psycopg/threads.py
+%%PORTDOCS%%share/examples/py-psycopg/usercast.py
+%%PORTDOCS%%share/examples/py-psycopg/whereareyou.jpg
+%%PORTDOCS%%share/examples/py-psycopg/work.py
+lib/%%PYTHON_VERSION%%/site-packages/psycopgmodule.so
+%%PORTDOCS%%@dirrm share/examples/py-psycopg
+%%PORTDOCS%%@dirrm share/doc/py-psycopg