Date: Fri, 14 Aug 2009 23:23:41 GMT From: Volodymyr Kostyrko <c.kworr@gmail.com> To: freebsd-gnats-submit@FreeBSD.org Subject: ports/137782: databases/py-postgresql (new port) postgresql driver for python, works with python>=3.0 Message-ID: <200908142323.n7ENNfId087862@www.freebsd.org> Resent-Message-ID: <200908142330.n7ENU5MU003653@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>Number: 137782 >Category: ports >Synopsis: databases/py-postgresql (new port) postgresql driver for python, works with python>=3.0 >Confidential: no >Severity: non-critical >Priority: low >Responsible: freebsd-ports-bugs >State: open >Quarter: >Keywords: >Date-Required: >Class: update >Submitter-Id: current-users >Arrival-Date: Fri Aug 14 23:30:05 UTC 2009 >Closed-Date: >Last-Modified: >Originator: Volodymyr Kostyrko >Release: 8-CURRENT >Organization: >Environment: FreeBSD limbo.lan 8.0-BETA2 FreeBSD 8.0-BETA2 #0: Fri Aug 14 02:13:53 EEST 2009 arcade@limbo.lan:/usr/obj/usr/src/sys/MINIMAL_8 i386 >Description: databases/py-postgresql is pure python/optimized python driver for postgresql database access wich can be used at almost any platform you can stick python3.0+ on. Currently other drivers (py-pg8000, py-psycopg, py-psycopg2, py-PyGreSql, py-pyPgSQL, py-sqlalchemy) doesn't work with python3.0 or later. PS: My first port ever guys, have mercy. :) >How-To-Repeat: Try to use postgresql from python3.0 or later. >Fix: Patch attached with submission follows: --- py-postgresql/Makefile 1970-01-01 03:00:00.000000000 +0300 +++ py-postgresql/Makefile 2009-08-15 01:48:32.659982588 +0300 @@ -0,0 +1,30 @@ +# New ports collection makefile for: py-postgresql +# Date created: 15 August 2009 +# Whom: Volodymyr Kostyrko <c.kworr@gmail.com> +# +# $FreeBSD$ +# + +PORTNAME= postgresql +PORTVERSION= 0.9.1 +CATEGORIES= databases python +MASTER_SITES= http://pgfoundry.org/frs/download.php/2332/ +PKGNAMEPREFIX= ${PYTHON_PKGNAMEPREFIX} +DISTNAME= py-postgresql-${PORTVERSION} +DIST_SUBDIR= postgresql + +MAINTAINER= c.kworr@gmail.com +COMMENT= py-postgresql provides a driver, cluster management tools, client \ + development tools, and API specifications + +USE_PGSQL= yes +USE_PYTHON= 3.0+ +USE_PYDISTUTILS= yes + +do-build: + @(cd ${WRKSRC}; ${PYTHON_CMD} setup.py build) + +do-install: + @(cd ${WRKSRC}; ${PYTHON_CMD} setup.py install) + +.include <bsd.port.mk> --- py-postgresql/distinfo 1970-01-01 03:00:00.000000000 +0300 +++ py-postgresql/distinfo 2009-08-15 01:49:43.723279965 +0300 @@ -0,0 +1,3 @@ +MD5 (postgresql/py-postgresql-0.9.1.tar.gz) = c9239b83d5055058b993076f9c92fd6d +SHA256 (postgresql/py-postgresql-0.9.1.tar.gz) = f5195b132a697be4224a2f9bc988ab9e25be16920948c907c3cae0fda09c9d07 +SIZE (postgresql/py-postgresql-0.9.1.tar.gz) = 206798 --- py-postgresql/pkg-descr 1970-01-01 03:00:00.000000000 +0300 +++ py-postgresql/pkg-descr 2009-08-15 01:42:17.678152006 +0300 @@ -0,0 +1,22 @@ +Pure Python +All code, at first, is written in pure Python so that py-postgresql will work +anywhere that you can install Python 3. Optimizations in C are made where +needed, but are always optional. + +Prepared Statements +Using the PG-API interface, protocol-level prepared statements may be created +and used multiple times. db.prepare(sql)(*args) + +COPY Support +Use the convenient COPY interface to directly copy data from one connection to +another. No intermediate files or tricks are necessary. + +Arrays and Composite Typescw +Arrays and composites are fully supported. Queries requesting them will returns +objects that provide access to the elements within. + +"pg_python" Quick Console +Get a Python console with a connection to PostgreSQL for quick tests and simple +scripts. + +WWW: http://python.projects.postgresql.org/ --- py-postgresql/pkg-plist 1970-01-01 03:00:00.000000000 +0300 +++ py-postgresql/pkg-plist 2009-08-15 02:04:00.277059831 +0300 @@ -0,0 +1,178 @@ +lib/%%PYTHON_VERSION%%/site-packages/postgresql/__init__.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/__init__.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/api.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/api.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/bin/__init__.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/bin/__init__.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/bin/pg_dotconf.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/bin/pg_dotconf.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/bin/pg_python.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/bin/pg_python.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/clientparameters.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/clientparameters.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/cluster.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/cluster.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/configfile.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/configfile.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/documentation/__init__.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/documentation/__init__.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/documentation/admin.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/documentation/admin.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/documentation/admin.txt +lib/%%PYTHON_VERSION%%/site-packages/postgresql/documentation/bin.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/documentation/bin.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/documentation/bin.txt +lib/%%PYTHON_VERSION%%/site-packages/postgresql/documentation/changes.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/documentation/changes.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/documentation/changes.txt +lib/%%PYTHON_VERSION%%/site-packages/postgresql/documentation/clientparameters.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/documentation/clientparameters.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/documentation/clientparameters.txt +lib/%%PYTHON_VERSION%%/site-packages/postgresql/documentation/driver.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/documentation/driver.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/documentation/driver.txt +lib/%%PYTHON_VERSION%%/site-packages/postgresql/documentation/gotchas.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/documentation/gotchas.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/documentation/gotchas.txt +lib/%%PYTHON_VERSION%%/site-packages/postgresql/documentation/index.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/documentation/index.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/documentation/index.txt +lib/%%PYTHON_VERSION%%/site-packages/postgresql/documentation/lib.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/documentation/lib.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/documentation/lib.txt +lib/%%PYTHON_VERSION%%/site-packages/postgresql/driver/__init__.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/driver/__init__.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/driver/dbapi20.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/driver/dbapi20.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/driver/pq3.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/driver/pq3.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/encodings/__init__.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/encodings/__init__.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/encodings/aliases.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/encodings/aliases.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/encodings/bytea.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/encodings/bytea.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/exceptions.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/exceptions.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/installation.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/installation.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/iri.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/iri.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/lib/__init__.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/lib/__init__.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/lib/libsys.sql +lib/%%PYTHON_VERSION%%/site-packages/postgresql/pgpassfile.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/pgpassfile.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/protocol/__init__.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/protocol/__init__.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/protocol/buffer.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/protocol/buffer.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/protocol/client3.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/protocol/client3.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/protocol/element3.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/protocol/element3.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/protocol/message_types.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/protocol/message_types.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/protocol/optimized.so +lib/%%PYTHON_VERSION%%/site-packages/postgresql/protocol/pbuffer.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/protocol/pbuffer.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/protocol/typio.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/protocol/typio.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/protocol/typstruct.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/protocol/typstruct.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/protocol/version.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/protocol/version.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/protocol/xact3.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/protocol/xact3.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/python/__init__.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/python/__init__.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/python/command.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/python/command.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/python/contextlib.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/python/contextlib.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/python/datetime.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/python/datetime.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/python/decorlib.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/python/decorlib.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/python/doc.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/python/doc.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/python/element.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/python/element.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/python/functools.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/python/functools.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/python/itertools.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/python/itertools.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/python/optimized.so +lib/%%PYTHON_VERSION%%/site-packages/postgresql/python/socket.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/python/socket.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/python/string.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/python/string.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/release/__init__.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/release/__init__.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/release/distutils.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/release/distutils.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/resolved/__init__.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/resolved/__init__.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/resolved/crypt.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/resolved/crypt.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/resolved/riparse.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/resolved/riparse.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/string.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/string.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/sys.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/sys.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/__init__.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/__init__.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/cursor_integrity.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/cursor_integrity.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/perf_copy_io.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/perf_copy_io.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/perf_query_io.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/perf_query_io.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/test_bytea_codec.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/test_bytea_codec.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/test_cluster.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/test_cluster.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/test_configfile.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/test_configfile.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/test_connect.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/test_connect.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/test_dbapi20.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/test_dbapi20.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/test_driver.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/test_driver.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/test_exceptions.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/test_exceptions.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/test_iri.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/test_iri.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/test_lib.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/test_lib.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/test_pgpassfile.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/test_pgpassfile.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/test_protocol.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/test_protocol.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/test_python.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/test_python.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/test_ssl_connect.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/test_ssl_connect.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/test_string.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/test_string.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/testall.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/test/testall.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/types.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/types.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/unittest.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/unittest.pyc +lib/%%PYTHON_VERSION%%/site-packages/postgresql/versionstring.py +lib/%%PYTHON_VERSION%%/site-packages/postgresql/versionstring.pyc +@dirrm lib/%%PYTHON_VERSION%%/site-packages/postgresql/bin +@dirrm lib/%%PYTHON_VERSION%%/site-packages/postgresql/documentation +@dirrm lib/%%PYTHON_VERSION%%/site-packages/postgresql/driver +@dirrm lib/%%PYTHON_VERSION%%/site-packages/postgresql/encodings +@dirrm lib/%%PYTHON_VERSION%%/site-packages/postgresql/lib +@dirrm lib/%%PYTHON_VERSION%%/site-packages/postgresql/protocol +@dirrm lib/%%PYTHON_VERSION%%/site-packages/postgresql/python +@dirrm lib/%%PYTHON_VERSION%%/site-packages/postgresql/release +@dirrm lib/%%PYTHON_VERSION%%/site-packages/postgresql/resolved +@dirrm lib/%%PYTHON_VERSION%%/site-packages/postgresql/test +@dirrm lib/%%PYTHON_VERSION%%/site-packages/postgresql >Release-Note: >Audit-Trail: >Unformatted:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200908142323.n7ENNfId087862>