diff options
author | sno <sno@pkgsrc.org> | 2010-03-16 17:30:08 +0000 |
---|---|---|
committer | sno <sno@pkgsrc.org> | 2010-03-16 17:30:08 +0000 |
commit | bb6dd3334c790ef82b615ef57bd18a3b71d07ffd (patch) | |
tree | 90c65d6f2db8c91cd5e28b204801c2079c846bdf /databases | |
parent | 3220236f05ad429aafab4632d310b8a3ae66a269 (diff) | |
download | pkgsrc-bb6dd3334c790ef82b615ef57bd18a3b71d07ffd.tar.gz |
Updating databases/p5-SQL-Statement from 1.22 to 1.25
pkgsrc changes:
- Adjust dependencies (mark fullfilled by perl CORE)
Upstream changes:
Version 1.25, release March 15th, 2010
----------------------------------------------
[Bug fixes]
* Keep org_table_names with schema information to allow derived
table classes to handle as it seems reasonable there
* Separate columns with "\0" in multi-column aggregation to be able to
difference between ('1','1foo') and ('11','foo')
[Misc]
* More resources added to META.yml
Version 1.24, release March 15th, 2010
----------------------------------------------
[Misc]
* Ignore *.rej in MANIFEST.SKIP (fixes RT #52081 reported by
Lars Thegler)
[Bug fixes]
* Add missing import of _INSTANCE in SQL::Statement::Function::NumericEval
fixes RT #52356 - reported by Detlef Pilzecker)
* Fix wrongly discarded DISTINCT clause (RT#53186)
[Improvements]
* Fix parsing errors of plain numbers (RT#16931)
* Fix parsing errors of nested calculation / functions (RT#16931, RT#52356)
* Rewrite result calculation of aggregation functions (simplify code,
speed up)
* Upgrade Makefile.PL (patch from Alexandr Ciornii) to handle different
EU::MM versions and abilities properly
* Update documentation to show how 'column_defs' and SQL::Statement::Term
instances shall be used
* Introduce SQL::Dialect::Role providing ini-style data access to
SQL::Dialects (patch from Michael Schwern)
[Things that may break your code]
* SQL::Parser now didn't deliver a struct containing 'column_names',
'computed_columns' and 'set_functions' - it's combined into one member
'column_defs'.
* Minimum required perl version is now 5.8 - upcoming next version of DBI
requires perl 5.8, too - and I could simplify some code that's why
Version 1.23, release November 20th, 2009
----------------------------------------------
[Misc]
* Applied patch from Marc Espie which fixes several orthographic
errors in SQL::Statement::Syntax documentation.
* Added a fixed version of test reported via RT #34121
[Bug fixes]
* Fix an issue in UPDATE command which 'shift's the values from
the list of parameters which causes there're no more parameters
left after first row get's updated (Fixes RT #50788)
* Fix aggregate function handling of new code since 1.21_01
* Correct handling of DISTINCT in aggregate functions
[Improvements]
* Add support for tables/columns starting with '_' for CSV and AnyData,
which is usually forbidden by ANSI SQL
* Add support for inserting multiple lines with one statement
(fixes RT #31730)
* Handle ANSI 'IS NULL' and CVS/AnyData 'IS NULL' different
[Things that may break your code]
* row_value now expects up to two arguments
Diffstat (limited to 'databases')
-rw-r--r-- | databases/p5-SQL-Statement/DESCR | 21 | ||||
-rw-r--r-- | databases/p5-SQL-Statement/Makefile | 10 | ||||
-rw-r--r-- | databases/p5-SQL-Statement/distinfo | 8 |
3 files changed, 28 insertions, 11 deletions
diff --git a/databases/p5-SQL-Statement/DESCR b/databases/p5-SQL-Statement/DESCR index bf947832d67..48fceedd113 100644 --- a/databases/p5-SQL-Statement/DESCR +++ b/databases/p5-SQL-Statement/DESCR @@ -1,3 +1,18 @@ -The SQL::Statement module implements a small, abstract SQL engine. This -module is not usefull itself, but as a base class for deriving concrete -SQL engines. +The SQL::Statement module implements a pure Perl SQL parsing and execution +engine. While it by no means implements full ANSI standard, it does support +many features including column and table aliases, built-in and user-defined +functions, implicit and explicit joins, complexly nested search conditions, +and other features. + +SQL::Statement is a small embeddable Database Management System (DBMS), +this means that it provides all of the services of a simple DBMS except that +instead of a persistant storage mechanism, it has two things: +1) an in-memory storage mechanism that allows you to prepare, execute, and + fetch from SQL statements using temporary tables and +2) a set of software sockets where any author can plug in any storage + mechanism. + +There are three main uses for SQL::Statement. +1) to access and manipulate data in CSV, XML, and other formats +2) to build a DBD for a new data source +3) to parse and examine the structure of SQL statements. diff --git a/databases/p5-SQL-Statement/Makefile b/databases/p5-SQL-Statement/Makefile index 0f20f586377..e5d53c0c5c6 100644 --- a/databases/p5-SQL-Statement/Makefile +++ b/databases/p5-SQL-Statement/Makefile @@ -1,12 +1,11 @@ -# $NetBSD: Makefile,v 1.28 2009/10/17 14:25:04 sno Exp $ +# $NetBSD: Makefile,v 1.29 2010/03/16 17:30:08 sno Exp $ # -DISTNAME= SQL-Statement-1.22 +DISTNAME= SQL-Statement-1.25 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/ @@ -15,7 +14,7 @@ LICENSE= ${PERL5_LICENSE} PKG_DESTDIR_SUPPORT= user-destdir -BUILD_DEPENDS+= p5-Test-Simple>=0.86:../../devel/p5-Test-Simple +BUILD_DEPENDS+= {perl>=5.10.1,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 @@ -26,6 +25,9 @@ MAKE_ENV+= SQL_STATEMENT_WARN_UPDATE=sure #pre-configure: # cd ${WRKSRC} && find `pwd` -name "*.orig" -type f | xargs rm +post-extract: + ${FIND} ${WRKSRC} -name "*.pm" -type f -exec ${CHMOD} -x {} \; + .include "../../lang/perl5/module.mk" .include "../../databases/p5-DBI/buildlink3.mk" BUILDLINK_API_DEPENDS.p5-DBI+= p5-DBI>=1.609 diff --git a/databases/p5-SQL-Statement/distinfo b/databases/p5-SQL-Statement/distinfo index edf679ffdbd..decc4183f6b 100644 --- a/databases/p5-SQL-Statement/distinfo +++ b/databases/p5-SQL-Statement/distinfo @@ -1,5 +1,5 @@ -$NetBSD: distinfo,v 1.13 2009/10/17 14:25:04 sno Exp $ +$NetBSD: distinfo,v 1.14 2010/03/16 17:30:08 sno Exp $ -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 +SHA1 (SQL-Statement-1.25.tar.gz) = 0221e6577be83d6375ee81e504cac6d6ecc6e99d +RMD160 (SQL-Statement-1.25.tar.gz) = 532f63034799055be1b3f7f560978f4c885d1a00 +Size (SQL-Statement-1.25.tar.gz) = 108314 bytes |