./databases/p5-SQL-Statement, Small, abstract SQL engine

[ CVSweb ] [ Homepage ] [ RSS ] [ Required by ] [ Add to tracker ]


Branch: CURRENT, Version: 1.410nb1, Package name: p5-SQL-Statement-1.410nb1, Maintainer: pkgsrc-users

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.


Required to run:
[lang/perl5] [devel/p5-Params-Util] [devel/p5-Clone] [math/p5-Math-Base-Convert]

Required to build:
[devel/p5-Test-Deep]

Master sites: (Expand)

SHA1: a9b2eeaa28e3c9aac5ae9da1ebbf13c03d6c39b5
RMD160: c75a1da826558682d89224105b00a0ce02881820
Filesize: 149.679 KB

Version history: (Expand)


CVS history: (Expand)


   2016-06-08 21:25:20 by Thomas Klausner | Files touched by this commit (2236) | Package updated
Log message:
Bump PKGREVISION for perl-5.24.
   2016-04-16 15:48:54 by Wen Heping | Files touched by this commit (2) | Package updated
Log message:
Update to 1.410

Upstream changes:
1.410 2016-04-11
    [Bug fixes]
    * Fix RT#113625 - Unnecessary x-bits (Kent Fredric)

    [Documentation]
    * pod2markdown README.md from lib/SQL/Statement.pm

1.409 2016-04-06
    * Release 1.408_001 without further changes as 1.409

1.408_001 2016-03-07
    [Bug fixes]
    * Fix RT#112530 - t/06virtual.t fails with -Duselongdouble (thanks
      Slaven Rezic)
    * Fix RT#105852 - dependency installation isn't triggered properly in
      cpan (thanks Mithaldu)
    * Fix RT#99349 - bind variables are not bound to placeholders in the
      correct order (thanks vulpeculus@gmx.de)

    [Documentation]
    * Update Copyright statements, add where missing (according to records)
    * Add license conditions where missing
    * bundle copy of license conditions to distribution
   2015-11-03 02:56:36 by Alistair G. Crooks | Files touched by this commit (368)
Log message:
Add SHA512 digests for distfiles for databases category

Problems found with existing distfiles:
	distfiles/D6.data.ros.gz
	distfiles/cstore0.2.tar.gz
	distfiles/data4.tar.gz
	distfiles/sphinx-2.2.7-release.tar.gz
No changes made to the cstore or mariadb55-client distinfo files.

Otherwise, existing SHA1 digests verified and found to be the same on
the machine holding the existing distfiles (morden).  All existing
SHA1 digests retained for now as an audit trail.
   2015-08-06 03:44:40 by Wen Heping | Files touched by this commit (2) | Package updated
Log message:
Update to 1.407
Add missing DEPENDS

Upstream changes:
1.407 2015-05-26
    * Release 1.406_002 without further changes as 1.407

1.406_002 2015-05-22
    [Bug fixes]
    * Fix RT#104579: Redundant argument in sprintf
      submitted by Slaven Rezi
    * Fix RT#104589: t/14parse.t fails if Test::Deep is not installed
      submitted by Slaven Rezi

1.406_001 2015-05-20
    [Misc]
    * clean up Makefile.PL, meta-data and requirements

    [Bug fixes]
    * Fix SQL function CONV to use limited number of sane character sets
      for conversion and rely on Math::Base::Convert instead of own code
      (suggested by Tom Wyant in RT#100551, thanks Tom)
    * fix handling of literal identifiers and for every IMPORT rely on
      literal identifiers to avoid parser errors for column names starting
      with numbers or similar
    * fix capability cache: "$class->can(...)" might return undef and
      therefore inexistent capabilities are queried to often
    * Fix COUNT(DISTINCT col) without GROUP BY clause (patch submitted
      by Grant Mathews, thanks Grant)
    * Fix "parse insert with functions" submitted via GitHub PR#6 by
      fecundf and RT#96628
    * Fix RT#93320: SQL-style comment can not begin inside quotes by
      Tom Wyant - thanks Tom

    [Improvements]
    * reduce blocks and rewrite some inner statements to increase speed
      of sql command processing
   2015-06-12 12:52:19 by Thomas Klausner | Files touched by this commit (3152)
Log message:
Recursive PKGREVISION bump for all packages mentioning 'perl',
having a PKGNAME of p5-*, or depending such a package,
for perl-5.22.0.
   2014-10-09 15:45:06 by Thomas Klausner | Files touched by this commit (456)
Log message:
Remove SVR4_PKGNAME, per discussion on tech-pkg.
   2014-05-30 01:38:20 by Thomas Klausner | Files touched by this commit (3049)
Log message:
Bump for perl-5.20.0.
Do it for all packages that
* mention perl, or
* have a directory name starting with p5-*, or
* depend on a package starting with p5-
like last time, for 5.18, where this didn't lead to complaints.
Let me know if you have any this time.
   2013-06-22 11:21:22 by Jens Rehsack | Files touched by this commit (2)
Log message:
Updating package for CPAN distribution SQL-Statement, providing pure Perl
implementation of an SQL engine.

pkgsrc changes:
- killing DBI build dependency - was an error introduced by the author
  for better test coverage, leads easily to circular dependency, bad stuff
  ==> kicking
- since 5.10.1 a suitable test framework is distributed with Perl5 core
  ==> no reason to mention it explicitely
- Bumping conflict DBI version to 1.622 (with 1.623 DBI::DBD::SqlEngine
  received great improve - and forces a lot of fixes in SQL::Statement
  and vice versa)

Upstream changes since 1.402:
Version 1.405, released June 17, 2013
-------------------------------------------------
[Bug fixes]
* INSERT now expands incomplete rows (Thanks to H.Merijn Brand)

Version 1.404, released May 23, 2013
-------------------------------------------------
[Bug fixes]
* re-enable cleanup test_output* after test done
* recommend Text::Soundex and do soundex-test only when have it,
  because it's going to be removed from core for Perl 5.19 (thank Merijn)

Version 1.403, released May 22, 2013
-------------------------------------------------
[Bug fixes]
* fix documentation (rt#84889 - thanks Xavier Guimard and Florian,
  rt#85257 - thanks Andreas Koenig)