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

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


Branch: CURRENT, Version: 1.31nb1, Package name: p5-SQL-Statement-1.31nb1, 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]

Required to build:
[databases/p5-DBI] [devel/p5-Test-Simple]

Master sites: (Expand)

SHA1: 4a73ce319c239f81bf2d8e5a973dda4c1a7e7c81
RMD160: fcf3d3a7f587b4ba7968b66528dc7f5996223739
Filesize: 116.479 KB

Version history: (Expand)


CVS history: (Expand)


   2010-08-21 18:37:14 by Stoned Elipot | Files touched by this commit (1724) | Package updated
Log message:
Bump the PKGREVISION for all packages which depend directly on perl,
to trigger/signal a rebuild for the transition 5.10.1 -> 5.12.1.

The list of packages is computed by finding all packages which end
up having either of PERL5_USE_PACKLIST, BUILDLINK_API_DEPENDS.perl,
or PERL5_PACKLIST defined in their make setup (tested via
"make show-vars VARNAMES=..."), minus the packages updated after
the perl package update.

sno@ was right after all, obache@ kindly asked and he@ led the
way. Thanks!
   2010-08-17 08:33:28 by Jens Rehsack | Files touched by this commit (2) | Package updated
Log message:
Updating databases/p5-SQL-Statement from 1.30 to 1.31

Upstream changes:
Version 1.31, released August 16th, 2010
----------------------------------------------

[Bug fixes]
* Fix misbehaviour of DELETE/UPDATE for tables with only basic capabilities
  and no matching where clause (reported by H.Merijn Brand and Drew ...)
* Fix some column identifier splits to respect quoted tables

[Improvements]
* Optimized some core routines between 25% and 50%.
   2010-08-04 17:05:20 by Jens Rehsack | Files touched by this commit (2)
Log message:
Updating databases/p5-SQL-Statement from 1.28 to 1.30

Upstream changes:
Version 1.30, released August 1st, 2010
----------------------------------------------

[Bug fixes]
* remove blib directory from distfile

Version 1.29, released August 1st, 2010
----------------------------------------------

[Bug fixes]
* add some getters as documented in SQL::Statement::Structure
  (fixes RT#59834, thanks John Wiersba)
* add missing import of function croak to SQL::Statement::Term::ColumnValue
* fix assignment of parser result (doesn't run with perl-5.13.3)
   2010-07-17 10:20:52 by Jens Rehsack | Files touched by this commit (2) | Package updated
Log message:
Updating databases/p5-SQL-Statement from 1.27 to 1.28

pkgsrc changes:
- require DBI-1.612 for testing
- add conflict for DBI<=1.612

Upstream changes:
Version 1.28, release July 15th, 2010
----------------------------------------------

[Improvements]
* Introduce new "capability" method for SQL::Statement and SQL::Eval::Table
  + Add capability for "insert_new_row" to allow DBD::DBM to fix PK
    constrain on INSERT statements.
* Performance of IMPORT feature improved (thanks to Sven Probst, RT#57322)

[Bug fixes]
* expect every table object being derived from SQL::Eval::Table
* rewrite DELETE and UPDATE command based on table capabilities
* add abstract methods for all methods derived classes must override
  (this means, open_table for SQL::Statement deriveds must be overridden
   and all data access methods of tables - see SQL::Eval::Table for details)
* Tests are fixed to use TEMP TABLES explicitely when required
* check for invalid column names fixed
* Don't let depreciated parser structures stay alive in SQL::Statement when
  reusing the Parser

[Documentation]
* Method documentation of SQL::Statement and SQL::Eval::Table are improved
* Add a Roadmap describing future plans for SQL::Statement (in addition to
  DBD::File::Roadmap).
* POD spelling fixes provided by H.Merijn Brand and Pod::Spell::CommonMistakes
  (thanks Tux)
* POD grammar fixes and reasonable sentences created by Martin Evans

[Things that may break your code]
* SQL::Statement 1.28 is expected not to work proper in combination with
  DBI 1.611 and below
* SQL::Statement::ColumnValue expects now every table being derived from
  SQL::Eval::Table
   2010-05-07 17:17:02 by Jens Rehsack | Files touched by this commit (2) | Package updated
Log message:
Updating databases/p5-SQL-Statement from 1.26 to 1.27

Upstream changes:
Version 1.27, release May 06th, 2010
----------------------------------------------

[Bug fixes]
* use originally given table name for open_table() on SELECT, too
  (all other command still use the originally given name)
* warn/die -> carp/croak
* fix delete_one_row & update_one_row ability using

[Documentation]
* Apply spelling fix patch from Ansgar Burchardt (RT#56475)
   2010-03-16 18:30:08 by Jens Rehsack | Files touched by this commit (3) | Package updated
Log message:
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
   2009-10-17 16:25:05 by Jens Rehsack | Files touched by this commit (2) | Package updated
Log message:
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
   2009-03-10 18:38:24 by Jens Rehsack | Files touched by this commit (2) | Package updated
Log message:
PkgSrc changes:

- Updating module to 1.20

Upstream changes:

Version 1.20, released March 5th, 2009
------------------------------------------

* Fixed Makefile in MANIFEST (reported by Havard Eidnes in RT #43586)
* Fixed invalid label FETCHROW used (reported by Michael in RT #42982)
* separated update_one_row and update_specific_row method names for tables
  to avoid confusion

Auto-Oked by rhaen@, because I maintain the CPAN module