Add p5-SQLite-Work 0.03, report on and update an SQLite database.

PR:		88068
Submitted by:	Chris Larsen <darth@vader.dk>

4 files changed, 66 insertions, 0 deletions

diff --git a/databases/p5-SQLite-Work/Makefile b/databases/p5-SQLite-Work/Makefile
new file mode 100644
index 000000000000..3dba86ceb268
--- /dev/null
+++ b/databases/p5-SQLite-Work/Makefile
@@ -0,0 +1,39 @@
+# New ports collection makefile for:	p5-SQLite-Work
+# Date created:				2005-10-27
+# Whom:					Chris Larsen <darth@vader.dk>
+#
+# $FreeBSD$
+#
+
+PORTNAME=	SQLite-Work
+PORTVERSION=	0.03
+CATEGORIES=	databases www perl5
+MASTER_SITES=	http://www.cpan.org/authors/id/R/RU/RUBYKAT/
+PKGNAMEPREFIX=	p5-
+
+MAINTAINER=	darth@vader.dk
+COMMENT=	Report on and update an SQLite database
+
+BUILD_DEPENDS=	${SITE_PERL}/${PERL_ARCH}/DBD/SQLite.pm:${PORTSDIR}/databases/p5-DBD-SQLite \
+		${SITE_PERL}/Getopt/Long.pm:${PORTSDIR}/devel/p5-Getopt-Long \
+		${SITE_PERL}/Getopt/ArgvFile.pm:${PORTSDIR}/devel/p5-Getopt-ArgvFile
+RUN_DEPENDS=	${BUILD_DEPENDS}
+
+PERL_MODBUILD=	yes
+
+MAN3=		SQLite::Work::Mail.3 \
+		SQLite::Work.3 \
+		SQLite::Work::Template.3 \
+		SQLite::Work::CGI.3
+
+MAN1=		sqlw_mail.1 \
+		sqlw_import.1 \
+		sqlreport.1
+
+.include <bsd.port.pre.mk>
+
+.if ${PERL_LEVEL} < 500600
+IGNORE=		requires perl 5.6.0 or later. Install lang/perl5.8 and try again
+.endif
+
+.include <bsd.port.post.mk>
diff --git a/databases/p5-SQLite-Work/distinfo b/databases/p5-SQLite-Work/distinfo
new file mode 100644
index 000000000000..60b069a82375
--- /dev/null
+++ b/databases/p5-SQLite-Work/distinfo
@@ -0,0 +1,2 @@
+MD5 (SQLite-Work-0.03.tar.gz) = bbd27a5389f0e3f0fa8fdb6c1bcb5a58
+SIZE (SQLite-Work-0.03.tar.gz) = 172504
diff --git a/databases/p5-SQLite-Work/pkg-descr b/databases/p5-SQLite-Work/pkg-descr
new file mode 100644
index 000000000000..f5dccc8d0a3a
--- /dev/null
+++ b/databases/p5-SQLite-Work/pkg-descr
@@ -0,0 +1,16 @@
+This generates HTML (and non-HTML) reports from an SQLite database, taking
+care of the query-building and the report formatting. This also has methods
+for adding and updating the database.
+
+Reports can have nested headers which depend on the sort-order given. One can
+select the columns and order in which the values are displayed. The HTML page
+generated can be customized with templates.
+
+The SQLite::Work::CGI module has extra methods which deal with CGI using the
+CGI module.
+
+The sqlreport script uses SQLite::Work to generate reports from the
+command-line.
+
+Author: Kathryn Andersen (RUBYKAT), perlkat AT katspace dot com
+WWW: http://www.katspace.com
diff --git a/databases/p5-SQLite-Work/pkg-plist b/databases/p5-SQLite-Work/pkg-plist
new file mode 100644
index 000000000000..d735f408918a
--- /dev/null
+++ b/databases/p5-SQLite-Work/pkg-plist
@@ -0,0 +1,9 @@
+bin/sqlreport
+bin/sqlw_mail
+bin/sqlw_import
+%%SITE_PERL%%/SQLite/Work.pm
+%%SITE_PERL%%/SQLite/Work/Template.pm
+%%SITE_PERL%%/SQLite/Work/CGI.pm
+%%SITE_PERL%%/SQLite/Work/Mail.pm
+@unexec rmdir %D/%%SITE_PERL%%/SQLite/Work 2>/dev/null || true
+@unexec rmdir %D/%%SITE_PERL%%/SQLite 2>/dev/null || true