Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 2 Nov 2001 05:04:04 -0800 (PST)
From:      Gerhard Häring <gerhard@bigfoot.de>
To:        freebsd-gnats-submit@FreeBSD.org
Subject:   ports/31705: new port: py-pyPgSQL
Message-ID:  <200111021304.fA2D44Q02146@freefall.freebsd.org>

next in thread | raw e-mail | index | archive | help

>Number:         31705
>Category:       ports
>Synopsis:       new port: py-pyPgSQL
>Confidential:   no
>Severity:       non-critical
>Priority:       medium
>Responsible:    freebsd-ports
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          change-request
>Submitter-Id:   current-users
>Arrival-Date:   Fri Nov 02 05:10:00 PST 2001
>Closed-Date:
>Last-Modified:
>Originator:     Gerhard Häring
>Release:        4.4-RELEASE
>Organization:
>Environment:
FreeBSD lilith.hqd-internal 4.4-RELEASE FreeBSD 4.4-RELEASE #1: Thu Nov  1 17:25:05 CET 2001     gerhard@lilith.hqd-internal:/usr/src/sys/compile/GH  i386
>Description:
This is my first FreeBSD port: It's a Python database interface library for PostgreSQL databases (I'm aware of the py-PyGreSQL port, but PyGreSQL has several issues).

pyPgSQL is a DB-API 2 compliant Python (2.0+) interface for PostgreSQL dabases (7.0+). I'm one of the developers.
>How-To-Repeat:

>Fix:
# This is a shell archive.  Save it in a file, remove anything before
# this line, and then unpack it by entering "sh file".  Note, it may
# create directories; files and directories will be owned by you and
# have default permissions.
#
# This archive contains:
#
#       /usr/ports/databases/py-pyPgSQL/
#       /usr/ports/databases/py-pyPgSQL/files
#       /usr/ports/databases/py-pyPgSQL/files/patch-setup
#       /usr/ports/databases/py-pyPgSQL/pkg-plist
#       /usr/ports/databases/py-pyPgSQL/pkg-descr
#       /usr/ports/databases/py-pyPgSQL/pkg-comment
#       /usr/ports/databases/py-pyPgSQL/Makefile
#       /usr/ports/databases/py-pyPgSQL/distinfo
#
echo c - /usr/ports/databases/py-pyPgSQL/
mkdir -p /usr/ports/databases/py-pyPgSQL/ > /dev/null 2>&1
echo c - /usr/ports/databases/py-pyPgSQL/files
mkdir -p /usr/ports/databases/py-pyPgSQL/files > /dev/null 2>&1
echo x - /usr/ports/databases/py-pyPgSQL/files/patch-setup
sed 's/^X//' >/usr/ports/databases/py-pyPgSQL/files/patch-setup << 'END-of-/usr/ports/databases/py-pyPgSQL/files/patch-setup'
Xdiff -r -C 3 ../pypgsql.orig/setup.py ./setup.py
X*** ../pypgsql.orig/setup.py   Thu Nov  1 15:06:34 2001
X--- ./setup.py Thu Nov  1 15:08:04 2001
X***************
X*** 77,89 ****
X  # You may have to adjust include_dirs and library_dirs if they are differant
X  # on your system
X
X! include_dirs  = [ "/usr/local/pgsql/include" ]
X! # include_dirs  = [ "/usr/local/include/pgsql" ]     # Common alternative
X! # include_dirs  = [ "/usr/include/pgsql" ]           # Common alternative
X!
X! library_dirs  = [ "/usr/local/pgsql/lib" ]           # Common alternative
X! # library_dirs  = [ "/usr/local/lib/pgsql" ]         # Common alternative
X! # library_dirs  = [ "/usr/lib/pgsql" ]
X
X  optional_libs = [ "pq" ]
X
X--- 77,84 ----
X  # You may have to adjust include_dirs and library_dirs if they are differant
X  # on your system
X
X! include_dirs = ["/usr/local/include/pgsql"]
X! library_dirs = ["/usr/local/lib"]
X
X  optional_libs = [ "pq" ]
X
END-of-/usr/ports/databases/py-pyPgSQL/files/patch-setup
echo x - /usr/ports/databases/py-pyPgSQL/pkg-plist
sed 's/^X//' >/usr/ports/databases/py-pyPgSQL/pkg-plist << 'END-of-/usr/ports/databases/py-pyPgSQL/pkg-plist'
X%%PYTHON_SITELIBDIR%%/libpqmodule.so
X%%PYTHON_SITELIBDIR%%/PgSQL.py
X%%PYTHON_SITELIBDIR%%/PgSQL.pyc
X%%PORTDOCS%%share/doc/py-pyPgSQL/README
X@dirrm %%PORTDOCS%%share/doc/py-pyPgSQL
X
END-of-/usr/ports/databases/py-pyPgSQL/pkg-plist
echo x - /usr/ports/databases/py-pyPgSQL/pkg-descr
sed 's/^X//' >/usr/ports/databases/py-pyPgSQL/pkg-descr << 'END-of-/usr/ports/databases/py-pyPgSQL/pkg-descr'
XpyPgSQL is a package of two modules that provide a Python DB-API 2.0 compliant
Xinterface to PostgreSQL databases. The first module, libpq, exports the
XPostgreSQL C API to Python. This module is written in C and can be compiled
Xinto Python or can be dynamically loaded on demand. The second module, PgSQL,
Xprovides the DB-API 2.0 compliant interface and support for various PostgreSQL
Xdata types, such as INT8, NUMERIC, MONEY, BOOL, ARRAYS, etc. This module is
Xwritten in Python.
X
XWWW: http://pypgsql.sourceforge.net/
Xdeveloped by Bill Allie et al
X
X- Gerhard Haering <gerhard@bigfoot.de>
END-of-/usr/ports/databases/py-pyPgSQL/pkg-descr
echo x - /usr/ports/databases/py-pyPgSQL/pkg-comment
sed 's/^X//' >/usr/ports/databases/py-pyPgSQL/pkg-comment << 'END-of-/usr/ports/databases/py-pyPgSQL/pkg-comment'
XA Python DB-API 2 compliant library for using PostgreSQL databases.
END-of-/usr/ports/databases/py-pyPgSQL/pkg-comment
echo x - /usr/ports/databases/py-pyPgSQL/Makefile
sed 's/^X//' >/usr/ports/databases/py-pyPgSQL/Makefile << 'END-of-/usr/ports/databases/py-pyPgSQL/Makefile'
X# New ports collection makefile for:   py-pypgsql
X# Date created:                                01 Nov 2001
X# Whom:                                        Gerhard Haering <gerhard@bigfoot.de>
X#
X# $FreeBSD$
X#
X
XPORTNAME=      py-pyPgSQL
XPORTVERSION=   1.6
XPORTREVISION=  1
XCATEGORIES=    databases python
XMASTER_SITES=  ${MASTER_SITE_SOURCEFORGE}
XMASTER_SITE_SUBDIR= pypgsql
XDISTNAME=      pypgsql-${PORTVERSION}
X
XMAINTAINER=    gerhard@bigfoot.de
X
XBUILD_DEPENDS= ${DATETIME_DEP}:${PORTSDIR}/lang/py-mx-base
XRUN_DEPENDS=   ${DATETIME_DEP}:${PORTSDIR}/lang/py-mx-base
XLIB_DEPENDS=   pq.2:${PORTSDIR}/databases/postgresql7
X
XWRKSRC=                ${WRKDIR}/pypgsql
XUSE_PYTHON=    yes
XSETUP_CMD=     cd ${WRKSRC} && ${PYTHON_CMD} setup.py
X
XDOCS=          README
X
XPLIST_SUB+=    PYTHON_SITELIBDIR=${PYTHON_SITELIBDIR:S/^${LOCALBASE}\///g}
X
Xdo-build:
X       ${SETUP_CMD} build_ext --inplace
X
Xdo-install:
X       ${SETUP_CMD} install
X.if !defined(NOPORTDOCS)
X       @${MKDIR} ${DOCSDIR}
X.for file in ${DOCS}
X       @${INSTALL_MAN} ${WRKSRC}/${file} ${DOCSDIR}
X.endfor
X.endif
X
X.include <bsd.port.mk>
END-of-/usr/ports/databases/py-pyPgSQL/Makefile
echo x - /usr/ports/databases/py-pyPgSQL/distinfo
sed 's/^X//' >/usr/ports/databases/py-pyPgSQL/distinfo << 'END-of-/usr/ports/databases/py-pyPgSQL/distinfo'
XMD5 (pypgsql-1.6.tar.gz) = 3804f543cbe6cb2805eecc4c44913aea
END-of-/usr/ports/databases/py-pyPgSQL/distinfo
exit
>Release-Note:
>Audit-Trail:
>Unformatted:

To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-ports" in the body of the message




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200111021304.fA2D44Q02146>