ports/173079: [NEW PORT] databases/pyspatialite Python interface to SQLite 3 + Spatialite

[lbartoletti]

>Number:         173079
>Category:       ports
>Synopsis:       [NEW PORT] databases/pyspatialite Python interface to SQLite 3 + Spatialite
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          sw-bug
>Submitter-Id:   current-users
>Arrival-Date:   Thu Oct 25 19:10:00 UTC 2012
>Closed-Date:
>Last-Modified:
>Originator:     lbartoletti
>Release:        
>Organization:
>Environment:
FreeBSD bart 9.0-RELEASE-p3 FreeBSD 9.0-RELEASE-p3 #0: Tue Jun 12 02:52:29 UTC 2012     root at amd64-builder.daemonology.net:/usr/obj/usr/src/sys/GENERIC  amd64

>Description:
pyspatialite is an interface to the SQLite 3.x embedded relational database engine with spatialite extensions. It is almost fully compliant with the Python database API version 2.0 also exposes the unique features of SQLite and spatialite.

WWW : https://code.google.com/p/pyspatialite/

Python PyPi : http://pypi.python.org/pypi/pyspatialite/3.0.1

>How-To-Repeat:
portlint -Nabt : OK
port test : OK
>Fix:


Patch attached with submission follows:

# 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:
#
#	pyspatialite
#	pyspatialite/Makefile
#	pyspatialite/pkg-descr
#	pyspatialite/distinfo
#	pyspatialite/files
#	pyspatialite/files/patch-src-connection.h
#	pyspatialite/files/patch-setup.py
#
echo c - pyspatialite
mkdir -p pyspatialite > /dev/null 2>&1
echo x - pyspatialite/Makefile
sed 's/^X//' >pyspatialite/Makefile << 'c8f61545834f46a27810b327eed201be'
X# New ports collection makefile for:	py-spatialite
X# Date created:		21 October 2012
X# Whom:				lbartoletti <coder at tuxfamily.org>
X#
X# $FreeBSD$
X#
X
XPORTNAME=	pyspatialite
XPORTVERSION=	3.0.1
XCATEGORIES=	databases python
XMASTER_SITES=	CHEESESHOP
XPKGNAMEPREFIX=	${PYTHON_PKGNAMEPREFIX}
X
XMAINTAINER=	coder at tuxfamily.org
XCOMMENT=	DB-API 2.0 interface for SQLite 3.x with Spatialite 3.x
X
XUSE_PYTHON=	yes
XUSE_PYDISTUTILS=yes
XPYDISTUTILS_PKGNAME=	pyspatialite
X
X.include <bsd.port.mk>
c8f61545834f46a27810b327eed201be
echo x - pyspatialite/pkg-descr
sed 's/^X//' >pyspatialite/pkg-descr << 'e2d548cd801202fe7b6f151deefc4c85'
Xpyspatialite is an interface to the SQLite 3.x embedded relational database
X engine with spatialite extensions.
XIt is almost fully compliant with the Python database API version 2.0 also
X exposes the unique features of SQLite and spatialite.
e2d548cd801202fe7b6f151deefc4c85
echo x - pyspatialite/distinfo
sed 's/^X//' >pyspatialite/distinfo << '3f2001ebdb4728d5e19c7966dde49369'
XSHA256 (pyspatialite-3.0.1.tar.gz) = 81a3e4966fb6348802a985486cbf62e019a0fcb0a1e006b9522e8b02dc08f238
XSIZE (pyspatialite-3.0.1.tar.gz) = 75099
3f2001ebdb4728d5e19c7966dde49369
echo c - pyspatialite/files
mkdir -p pyspatialite/files > /dev/null 2>&1
echo x - pyspatialite/files/patch-src-connection.h
sed 's/^X//' >pyspatialite/files/patch-src-connection.h << 'e6d93c9d9acd9abda60fa19c608fde34'
X--- src/connection.h.bak	2012-10-25 19:40:06.000000000 +0200
X+++ src/connection.h	2012-10-25 19:40:25.000000000 +0200
X@@ -33,8 +33,6 @@
X #include "sqlite3.h"
X #include "spatialite.h"
X 
X-int spatialite_init(int verbose);
X-
X typedef struct
X {
X     PyObject_HEAD
e6d93c9d9acd9abda60fa19c608fde34
echo x - pyspatialite/files/patch-setup.py
sed 's/^X//' >pyspatialite/files/patch-setup.py << 'f502e05c4f459b87ab8b37ff0dabc525'
X--- setup.py.bak	2012-10-25 19:41:58.000000000 +0200
X+++ setup.py	2012-10-25 19:43:09.000000000 +0200
X@@ -119,8 +119,10 @@
X           ext.libraries.append("iconv")
X 
X         #Default locations for Mac
X+        ext.include_dirs.append("/usr/local/include/")
X         ext.include_dirs.append("/Library/Frameworks/GEOS.framework/unix/include/")
X         ext.include_dirs.append("/Library/Frameworks/PROJ.framework/unix/include/")
X+        ext.library_dirs.append("/usr/local/lib")
X         ext.library_dirs.append("/Library/Frameworks/GEOS.framework/unix/lib")
X         ext.library_dirs.append("/Library/Frameworks/PROJ.framework/unix/lib")
X 
X@@ -132,7 +134,7 @@
X         ext.sources.append(os.path.join(AMALGAMATION_ROOT, "spatialite.c"))
X         ext.include_dirs.append(AMALGAMATION_ROOT)
X         build_ext.build_extension(self, ext)
X-        
X+
X 
X #    def __setattr__(self, k, v):
X #        # Make sure we don't link against the SQLite library, no matter what setup.cfg says
f502e05c4f459b87ab8b37ff0dabc525
exit



>Release-Note:
>Audit-Trail:
>Unformatted: