psycopg2 is a PostgreSQL database adapter for the Python programming language.

It was written from scratch with the aim of being small, fast and stable. It
supports the full Python DBAPI-2.0 and is thread safe.

psycopg2 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/projects/psycopg2

Approved by:	krion (mentor)

1 files changed, 59 insertions, 0 deletions

diff --git a/databases/py-psycopg2/Makefile b/databases/py-psycopg2/Makefile
new file mode 100644
index 000000000000..066d5f767fd5
--- /dev/null
+++ b/databases/py-psycopg2/Makefile
@@ -0,0 +1,59 @@
+# New ports collection makefile for:	py-psycopg2
+# Date created:		1 August 2006
+# Whom:			Martin Wilke 	<miwi@FreeBSD.org>
+#
+# $FreeBSD$
+#
+
+PORTNAME=	psycopg2
+PORTVERSION=	2.0.4
+CATEGORIES=	databases python
+MASTER_SITES=	http://initd.org/pub/software/psycopg/
+PKGNAMEPREFIX=	${PYTHON_PKGNAMEPREFIX}
+DISTNAME=	psycopg2-${PORTVERSION}
+
+MAINTAINER=	miwi@FreeBSD.org
+COMMENT=	The high performance Python adapter for PostgreSQL
+
+RUN_DEPENDS=	${PYTHON_SITELIBDIR}/mx/DateTime:${PORTSDIR}/lang/py-mx-base
+
+USE_PGSQL=	yes
+USE_GMAKE=	yes
+USE_PYTHON=	yes
+USE_PYDISTUTILS=	yes
+
+.include <bsd.port.pre.mk>
+
+do-build:
+	@(cd ${WRKSRC}; ${PYTHON_CMD} setup.py build)
+
+do-install:
+	@(cd ${WRKSRC}; ${PYTHON_CMD} setup.py install)
+
+.if ${OSVERSION} < 500000
+BROKEN=		Does not compile on 4.x
+.endif
+
+DOCSDIR=	${TARGETDIR}/share/doc/py-psycopg2
+EXAMPLESDIR=	${TARGETDIR}/share/examples/py-psycopg2
+
+EXAMPLES=	binary.py cursor.py dt.py lastrowid.py notify.py threads.py \
+		whereareyou.jpg copy_from.py dialtone.py encoding.py \
+		mogrify.py simple.py tz.py copy_to.py dict.py fetch.py \
+		myfirstrecipe.py somehackers.jpg usercast.py
+
+DOCS=		AUTHORS ChangeLog INSTALL README PKG-INFO
+
+post-install:
+.if !defined(NOPORTDOCS)
+	@${MKDIR} ${EXAMPLESDIR}
+.for f in ${EXAMPLES}
+	@${INSTALL_DATA} ${WRKSRC}/examples/${f} ${EXAMPLESDIR}
+.endfor
+	@${MKDIR} ${DOCSDIR}
+.for f in ${DOCS}
+	@${INSTALL_MAN} ${WRKSRC}/${f} ${DOCSDIR}
+.endfor
+.endif
+
+.include <bsd.port.post.mk>