From owner-freebsd-ports-bugs Mon Feb 17 23:10:15 2003 Delivered-To: freebsd-ports-bugs@hub.freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 350AA37B401 for ; Mon, 17 Feb 2003 23:10:12 -0800 (PST) Received: from freefall.freebsd.org (freefall.freebsd.org [216.136.204.21]) by mx1.FreeBSD.org (Postfix) with ESMTP id 4BFFF43FA3 for ; Mon, 17 Feb 2003 23:10:11 -0800 (PST) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (gnats@localhost [127.0.0.1]) by freefall.freebsd.org (8.12.6/8.12.6) with ESMTP id h1I7ABNS088757 for ; Mon, 17 Feb 2003 23:10:11 -0800 (PST) (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.12.6/8.12.6/Submit) id h1I7ABN6088756; Mon, 17 Feb 2003 23:10:11 -0800 (PST) Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id C56E837B401 for ; Mon, 17 Feb 2003 23:09:13 -0800 (PST) Received: from happygiraffe.net (happygiraffe.net [81.6.215.59]) by mx1.FreeBSD.org (Postfix) with ESMTP id F0D4E43F85 for ; Mon, 17 Feb 2003 23:09:12 -0800 (PST) (envelope-from dom@happygiraffe.net) Received: by happygiraffe.net (Postfix, from userid 1001) id D7F6E5C20; Tue, 18 Feb 2003 07:09:10 +0000 (GMT) Message-Id: <20030218070910.D7F6E5C20@happygiraffe.net> Date: Tue, 18 Feb 2003 07:09:10 +0000 (GMT) From: Dominic Mitchell Reply-To: Dominic Mitchell To: FreeBSD-gnats-submit@FreeBSD.org X-Send-Pr-Version: 3.113 Subject: ports/48411: New port: databases/p5-SQL-Abstract Sender: owner-freebsd-ports-bugs@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.org >Number: 48411 >Category: ports >Synopsis: New port: databases/p5-SQL-Abstract >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: Mon Feb 17 23:10:10 PST 2003 >Closed-Date: >Last-Modified: >Originator: Dominic Mitchell >Release: FreeBSD 5.0-RELEASE i386 >Organization: >Environment: System: FreeBSD ppe.happygiraffe.net 5.0-RELEASE FreeBSD 5.0-RELEASE #0: Thu Jan 16 22:16:53 GMT 2003 root@hollin.btc.adaptec.com:/usr/obj/usr/src/sys/GENERIC i386 perl 5.8.0 >Description: This module allows building of SQL in a dynamic fashion from Perl data structures. >How-To-Repeat: n/a >Fix: Here's the shar file. # 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-SQL-Abstract # p5-SQL-Abstract/Makefile # p5-SQL-Abstract/distinfo # p5-SQL-Abstract/pkg-descr # p5-SQL-Abstract/pkg-plist # echo c - p5-SQL-Abstract mkdir -p p5-SQL-Abstract > /dev/null 2>&1 echo x - p5-SQL-Abstract/Makefile sed 's/^X//' >p5-SQL-Abstract/Makefile << 'END-of-p5-SQL-Abstract/Makefile' X# New ports collection makefile for: SQL-Abstract X# Date created: 18 Feb 2003 X# Whom: Dominic Mitchell X# X# $FreeBSD$ X# X XPORTNAME= SQL-Abstract XPORTVERSION= 1.10 XCATEGORIES= databases perl5 XMASTER_SITES= ${MASTER_SITE_PERL_CPAN} XMASTER_SITE_SUBDIR= SQL XPKGNAMEPREFIX= p5- X XMAINTAINER= dom@happygiraffe.net XCOMMENT= Perl extension to generate SQL from Perl data structures X XPERL_CONFIGURE= yes X XMANPREFIX= ${PREFIX}/lib/perl5/${PERL_VERSION} XMAN3= SQL::Abstract.3 X X.include END-of-p5-SQL-Abstract/Makefile echo x - p5-SQL-Abstract/distinfo sed 's/^X//' >p5-SQL-Abstract/distinfo << 'END-of-p5-SQL-Abstract/distinfo' XMD5 (SQL-Abstract-1.10.tar.gz) = 4f6ec9ae01de6811f4d3c15ffd4c0a11 END-of-p5-SQL-Abstract/distinfo echo x - p5-SQL-Abstract/pkg-descr sed 's/^X//' >p5-SQL-Abstract/pkg-descr << 'END-of-p5-SQL-Abstract/pkg-descr' XThis module was inspired by the excellent DBIx::Abstract. However, in Xusing the module I found that what I wanted to do was generate SQL, but Xstill retain complete control over my statement handles and use the DBI Xinterface. So, I set out to create an abstract SQL generation module. X XThis module is based largely on DBIx::Abstract. However, there are Xseveral important differences, especially when it comes to WHERE Xclauses. I have modified the concepts used to make the SQL easier to Xgenerate from Perl data structures and, IMO, more intuitive. X XWWW: http://search.cpan.org/search?dist=SQL-Abstract END-of-p5-SQL-Abstract/pkg-descr echo x - p5-SQL-Abstract/pkg-plist sed 's/^X//' >p5-SQL-Abstract/pkg-plist << 'END-of-p5-SQL-Abstract/pkg-plist' Xlib/perl5/site_perl/%%PERL_VER%%/%%PERL_ARCH%%/auto/SQL/Abstract/.packlist Xlib/perl5/site_perl/%%PERL_VER%%/SQL/Abstract.pm X@dirrm lib/perl5/site_perl/%%PERL_VER%%/%%PERL_ARCH%%/auto/SQL/Abstract X@unexec rmdir %D/lib/perl5/site_perl/%%PERL_VER%%/SQL 2>/dev/null || true X@unexec rmdir %D/lib/perl5/site_perl/%%PERL_VER%%/%%PERL_ARCH%%/auto/SQL 2>/dev/null || true END-of-p5-SQL-Abstract/pkg-plist exit >Release-Note: >Audit-Trail: >Unformatted: To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-ports-bugs" in the body of the message