ports/88068: [NEW PORT] databases/p5-SQLite-Work: Report on and update an SQLite database

[Chris Larsen]

>Number:         88068
>Category:       ports
>Synopsis:       [NEW PORT] databases/p5-SQLite-Work: Report on and update an SQLite database
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          change-request
>Submitter-Id:   current-users
>Arrival-Date:   Wed Oct 26 23:30:12 GMT 2005
>Closed-Date:
>Last-Modified:
>Originator:     Chris Larsen
>Release:        FreeBSD 5.4-RELEASE-p6 i386
>Organization:
The Empire
>Environment:
System: FreeBSD 5.4-RELEASE-p6 i386
>Description:
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

Generated with FreeBSD Port Tools 0.63
>How-To-Repeat:
>Fix:

--- p5-SQLite-Work-0.03.shar begins here ---
# 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:
#
#	p5-SQLite-Work
#	p5-SQLite-Work/Makefile
#	p5-SQLite-Work/distinfo
#	p5-SQLite-Work/pkg-descr
#	p5-SQLite-Work/pkg-plist
#
echo c - p5-SQLite-Work
mkdir -p p5-SQLite-Work > /dev/null 2>&1
echo x - p5-SQLite-Work/Makefile
sed 's/^X//' >p5-SQLite-Work/Makefile << 'END-of-p5-SQLite-Work/Makefile'
X# New ports collection makefile for:	p5-SQLite-Work
X# Date created:				2005-10-27
X# Whom:					Chris Larsen <darth at vader.dk>
X#
X# $FreeBSD$
X#
X
XPORTNAME=	SQLite-Work
XPORTVERSION=	0.03
XCATEGORIES=	databases www perl5
XMASTER_SITES=	http://www.cpan.org/authors/id/R/RU/RUBYKAT/
XPKGNAMEPREFIX=	p5-
X
XMAINTAINER=	ports at FreeBSD.org
XCOMMENT=	Report on and update an SQLite database
X
XRUN_DEPENDS=	${SITE_PERL}/${PERL_ARCH}/DBD/SQLite.pm:${PORTSDIR}/databases/p5-DBD-SQLite \
X		${SITE_PERL}/Getopt/Long.pm:${PORTSDIR}/devel/p5-Getopt-Long \
X		${SITE_PERL}/Getopt/ArgvFile.pm:${PORTSDIR}/devel/p5-Getopt-ArgvFile
X
XPERL_MODBUILD=	yes
X
XMAN3=		SQLite::Work::Mail.3 \
X		SQLite::Work.3 \
X		SQLite::Work::Template.3 \
X		SQLite::Work::CGI.3
X
XMAN1=		sqlw_mail.1 \
X		sqlw_import.1 \
X		sqlreport.1
X
X.include <bsd.port.mk>
END-of-p5-SQLite-Work/Makefile
echo x - p5-SQLite-Work/distinfo
sed 's/^X//' >p5-SQLite-Work/distinfo << 'END-of-p5-SQLite-Work/distinfo'
XMD5 (SQLite-Work-0.03.tar.gz) = bbd27a5389f0e3f0fa8fdb6c1bcb5a58
XSIZE (SQLite-Work-0.03.tar.gz) = 172504
END-of-p5-SQLite-Work/distinfo
echo x - p5-SQLite-Work/pkg-descr
sed 's/^X//' >p5-SQLite-Work/pkg-descr << 'END-of-p5-SQLite-Work/pkg-descr'
XThis generates HTML (and non-HTML) reports from an SQLite database, taking
Xcare of the query-building and the report formatting. This also has methods
Xfor adding and updating the database.
X
XReports can have nested headers which depend on the sort-order given. One can
Xselect the columns and order in which the values are displayed. The HTML page
Xgenerated can be customized with templates.
X
XThe SQLite::Work::CGI module has extra methods which deal with CGI using the
XCGI module.
X
XThe sqlreport script uses SQLite::Work to generate reports from the
Xcommand-line.
X
XAuthor: Kathryn Andersen (RUBYKAT), perlkat AT katspace dot com
XWWW: http://www.katspace.com
END-of-p5-SQLite-Work/pkg-descr
echo x - p5-SQLite-Work/pkg-plist
sed 's/^X//' >p5-SQLite-Work/pkg-plist << 'END-of-p5-SQLite-Work/pkg-plist'
Xbin/sqlreport
Xbin/sqlw_mail
Xbin/sqlw_import
X%%SITE_PERL%%/SQLite/Work.pm
X%%SITE_PERL%%/SQLite/Work/Template.pm
X%%SITE_PERL%%/SQLite/Work/CGI.pm
X%%SITE_PERL%%/SQLite/Work/Mail.pm
X at unexec rmdir %D/%%SITE_PERL%%/SQLite/Work 2>/dev/null || true
X at unexec rmdir %D/%%SITE_PERL%%/SQLite 2>/dev/null || true
END-of-p5-SQLite-Work/pkg-plist
exit
--- p5-SQLite-Work-0.03.shar ends here ---

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