Updating databases/p5-SQL-Statement from 1.20 to 1.22

pkgsrc changes:
  - Adding license definition
  - Adjusting dependencies
  - Ensure build
  - remove *.orig removal (may break some SunOS builds)

Upstream changes:
Version 1.22, release October 10th, 2009
----------------------------------------------

[Misc]
* Add missing changelog - no code changes

Version 1.21, release October 10th, 2009
----------------------------------------------

[Misc]
* remove version dependency to check previously installed version
* add DBD::File as "Test" requirement

Version 1.21_8, release October 5th, 2009
----------------------------------------------

[Bug fixes]
* Add additional test for bug-fix in 1.21_7 to t/18bigjoin.t

[Misc]
* Correct some typo's in POD

Version 1.21_7, not public released
----------------------------------------------

[Bug fixes]
* Don't fail for non-existent columns introduced by functions
  in joins

Version 1.21_6, release September 24th, 2009
----------------------------------------------

[Bug fixes]
* Don't abort Makefile.PL when in automated smoke tests

Version 1.21_5, release September 23th, 2009
----------------------------------------------

[Bug fixes]
* table order isn't wrongly used in order of appearance when SQL::Parser
  couldn't determine an order
* Some internal fixes

[Misc]
* Updated dependency to Params::Util to non-leaking 1.00
* Note dependency to Carp and Data::Dumper
* rely on version to compare versions
* Update POD for terms
* Update

Version 1.21_4, release September 21th, 2009
----------------------------------------------

[Bug fixes]
* modify regex to match types to fix problems with Perl 5.6.2
* add DESTROY methods to ensure clean up
* fix lower casing internal table names when joining tables
* replace parameter shifting by assigning @_ to the list of parameters

Version 1.21_3, release September 17th, 2009
----------------------------------------------

[Things that may break your code]
* When someone accesses the where_clause attribute of the SQL::Statement
  instance - be aware that now IN and BETWEEN can be native entries

[Bug fixes]
* convert operation to upper case when surely initialized

[Improvements]
* IN and BETWEEN are now native operations - they are not expanded
  to OR'ed equalize operations anymore

Version 1.21_2, release September 15th, 2009
----------------------------------------------

[Things that may break your code]
* modify behavior for unquoted identifiers - they're converted and
  returned lower cased now (instead upper cased as in 1.21_1)
  Fixes bug RT #48502

Version 1.21_1, release July 30th, 2009
------------------------------------------

[Things that may break your code]
* removed SQL::Statement::Column
* don't instantiate SQL::Statement::Functions objects
* Reworked internal column and function handling to reduce code complexity
* rows and columns aren't setable from outside a table or eval object
  anymore

[Bug fixes and other changes]
* Fixed bugs:
  + RT #47292: Test failures with recent DBI
  + RT #44512: Patch for CREATE TABLE parsing
  + RT #42676: tests 16 failed

2 files changed, 18 insertions, 10 deletions

diff --git a/databases/p5-SQL-Statement/Makefile b/databases/p5-SQL-Statement/Makefile
index e8022fc92b2..0f20f586377 100644
--- a/databases/p5-SQL-Statement/Makefile
+++ b/databases/p5-SQL-Statement/Makefile
@@ -1,26 +1,34 @@
-# $NetBSD: Makefile,v 1.27 2009/03/10 17:38:24 sno Exp $
+# $NetBSD: Makefile,v 1.28 2009/10/17 14:25:04 sno Exp $
 #
 
-DISTNAME=	SQL-Statement-1.20
+DISTNAME=	SQL-Statement-1.22
 PKGNAME=	p5-${DISTNAME}
 SVR4_PKGNAME=	p5sqs
 CATEGORIES=	databases perl5
 MASTER_SITES=	${MASTER_SITE_PERL_CPAN:=SQL/}
+MASTER_SITES+=	${MASTER_SITE_PERL_CPAN:=../../authors/id/R/RE/REHSACK/}
 
 MAINTAINER=	pkgsrc-users@NetBSD.org
 HOMEPAGE=	http://search.cpan.org/dist/SQL-Statement/
 COMMENT=	Small, abstract SQL engine
+LICENSE=	${PERL5_LICENSE}
 
 PKG_DESTDIR_SUPPORT=	user-destdir
 
-DEPENDS+=	p5-Test-Simple>=0.86:../../devel/p5-Test-Simple
-DEPENDS+=	p5-Params-Util>=0.35:../../devel/p5-Params-Util
+BUILD_DEPENDS+=	p5-Test-Simple>=0.86:../../devel/p5-Test-Simple
+
 DEPENDS+=	p5-Clone>=0.30:../../devel/p5-Clone
+DEPENDS+=	p5-Params-Util>=1.00:../../devel/p5-Params-Util
 
 PERL5_PACKLIST=		auto/SQL/Statement/.packlist
+MAKE_ENV+=		SQL_STATEMENT_WARN_UPDATE=sure
 
-pre-configure:
-	cd ${WRKSRC} && find `pwd` -name "*.orig" -type f | xargs rm
+#pre-configure:
+#	cd ${WRKSRC} && find `pwd` -name "*.orig" -type f | xargs rm
 
 .include "../../lang/perl5/module.mk"
+.include "../../databases/p5-DBI/buildlink3.mk"
+BUILDLINK_API_DEPENDS.p5-DBI+=	p5-DBI>=1.609
+BUILDLINK_DEPMETHOD.p5-DBI=	build
+
 .include "../../mk/bsd.pkg.mk"
diff --git a/databases/p5-SQL-Statement/distinfo b/databases/p5-SQL-Statement/distinfo
index 2f4e6a6511e..edf679ffdbd 100644
--- a/databases/p5-SQL-Statement/distinfo
+++ b/databases/p5-SQL-Statement/distinfo
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.12 2009/03/10 17:38:24 sno Exp $
+$NetBSD: distinfo,v 1.13 2009/10/17 14:25:04 sno Exp $
 
-SHA1 (SQL-Statement-1.20.tar.gz) = 795585cc075fd9e128c951a636c94a41333656b2
-RMD160 (SQL-Statement-1.20.tar.gz) = 7864d380001e18e3d7dbca2309aab9e84d7e1179
-Size (SQL-Statement-1.20.tar.gz) = 92966 bytes
+SHA1 (SQL-Statement-1.22.tar.gz) = fbab6660699617cc0c21102e08e6e88cbe02dae0
+RMD160 (SQL-Statement-1.22.tar.gz) = f29962aca874642581a9c055e46552d6f8f3323c
+Size (SQL-Statement-1.22.tar.gz) = 100115 bytes