Add p5-DBD-PgSPI 0.01

Provides access to PostgreSQL db through DBI within pl/perl functions.

PR:		51097
Submitted by:	myself

5 files changed, 69 insertions, 0 deletions

diff --git a/databases/p5-DBD-PgSPI/Makefile b/databases/p5-DBD-PgSPI/Makefile
new file mode 100644
index 000000000000..febaf067bedd
--- /dev/null
+++ b/databases/p5-DBD-PgSPI/Makefile
@@ -0,0 +1,46 @@
+# New ports collection makefile for:    p5-DBD-PgSPI
+# Date created:				17 April 2003
+# Whom:	      				mat
+#
+# $FreeBSD$
+#
+
+PORTNAME=	DBD-PgSPI
+PORTVERSION=	0.01
+CATEGORIES=	databases perl5
+MASTER_SITES=	${MASTER_SITE_PERL_CPAN}
+MASTER_SITE_SUBDIR=	DBD
+PKGNAMEPREFIX=	p5-
+
+MAINTAINER=	mat@FreeBSD.org
+COMMENT=	Provides access to PostgreSQL db through DBI within pl/perl functions
+
+BUILD_DEPENDS=	${RUN_DEPENDS} \
+		${NONEXISTENT}:${PORTSDIR}/${POSTGRESQL_PORT}:configure
+RUN_DEPENDS=	${LOCALBASE}/lib/postgresql/plperl.so:${PORTSDIR}/databases/p5-postgresql-plperl \
+		${SITE_PERL}/${PERL_ARCH}/DBD/Pg.pm:${PORTSDIR}/databases/p5-DBD-Pg
+LIB_DEPENDS=	pq.3:${PORTSDIR}/${POSTGRESQL_PORT}
+
+PERL_CONFIGURE=	yes
+
+MAN3=		DBD::PgSPI.3
+
+.include <bsd.port.pre.mk>
+
+.if ${PERL_LEVEL} < 500600
+RUN_DEPENDS+=	${SITE_PERL}/${PERL_ARCH}/DBI.pm:${PORTSDIR}/databases/p5-DBI-137
+.else
+RUN_DEPENDS+=	${SITE_PERL}/${PERL_ARCH}/DBI.pm:${PORTSDIR}/databases/p5-DBI
+.endif
+
+POSTGRESQL_PORT?=	databases/postgresql7
+PGSQL_PORTDIR?=		${PORTSDIR}/${POSTGRESQL_PORT}
+PGSQL_WRKSRC!=		cd ${PGSQL_PORTDIR} && ${MAKE} -V WRKSRC
+
+CONFIGURE_ENV=	POSTGRES_HOME="${PGSQL_WRKSRC}/src" \
+	        LOCALBASE="${LOCALBASE}"
+
+post-clean:
+	@cd ${PGSQL_PORTDIR} && ${MAKE} clean
+
+.include <bsd.port.post.mk>
diff --git a/databases/p5-DBD-PgSPI/distinfo b/databases/p5-DBD-PgSPI/distinfo
new file mode 100644
index 000000000000..3b142efcd3cd
--- /dev/null
+++ b/databases/p5-DBD-PgSPI/distinfo
@@ -0,0 +1 @@
+MD5 (DBD-PgSPI-0.01.tar.gz) = 6880316532bd262cb2c9c7a07d407e91
diff --git a/databases/p5-DBD-PgSPI/files/patch-Makefile.PL b/databases/p5-DBD-PgSPI/files/patch-Makefile.PL
new file mode 100644
index 000000000000..bfb15b7c7e2d
--- /dev/null
+++ b/databases/p5-DBD-PgSPI/files/patch-Makefile.PL
@@ -0,0 +1,11 @@
+--- Makefile.PL.orig	Fri Jun 22 04:18:50 2001
++++ Makefile.PL	Thu Apr 17 17:51:40 2003
+@@ -28,7 +28,7 @@
+ my %opts = (
+     NAME         => 'DBD::PgSPI',
+     VERSION_FROM => 'PgSPI.pm',
+-    INC          => "-I$POSTGRES_HOME/include -I$POSTGRES_HOME/backend -I$POSTGRES_HOME/interfaces/libpq -I$dbi_arch_dir",
++    INC          => "-I$POSTGRES_HOME/include -I$POSTGRES_HOME/backend -I$POSTGRES_HOME/interfaces/libpq -I$ENV{LOCALBASE}/include -I$dbi_arch_dir",
+     OBJECT       => "PgSPI\$(OBJ_EXT) dbdimp\$(OBJ_EXT)",
+     LIBS         => [],
+     AUTHOR       => 'Alex Pilosov (alex@pilosov.com)',
diff --git a/databases/p5-DBD-PgSPI/pkg-descr b/databases/p5-DBD-PgSPI/pkg-descr
new file mode 100644
index 000000000000..d92eaf47abfe
--- /dev/null
+++ b/databases/p5-DBD-PgSPI/pkg-descr
@@ -0,0 +1,5 @@
+DBD::PgSPI is a Perl module which works with the DBI module to provide
+access to PostgreSQL database from within pl/perl functions inside the
+database.
+
+WWW: http://search.cpan.org/dist/DBD-PgSPI/
diff --git a/databases/p5-DBD-PgSPI/pkg-plist b/databases/p5-DBD-PgSPI/pkg-plist
new file mode 100644
index 000000000000..8469ee30b34d
--- /dev/null
+++ b/databases/p5-DBD-PgSPI/pkg-plist
@@ -0,0 +1,6 @@
+%%SITE_PERL%%/%%PERL_ARCH%%/DBD/PgSPI.pm
+%%SITE_PERL%%/%%PERL_ARCH%%/auto/DBD/PgSPI/.packlist
+%%SITE_PERL%%/%%PERL_ARCH%%/auto/DBD/PgSPI/PgSPI.bs
+%%SITE_PERL%%/%%PERL_ARCH%%/auto/DBD/PgSPI/PgSPI.so
+@dirrm %%SITE_PERL%%/%%PERL_ARCH%%/auto/DBD/PgSPI
+@unexec rmdir %D/%%SITE_PERL%%/%%PERL_ARCH%%/auto/DBD 2>/dev/null || true