Changes for version 0.25
- 2003-12-07 U-MOKSHA\metaperl <metaperl@urth.org>
- Recordset.pm : added support for direct Query input.
- 2003-12-02 U-MOKSHA\metaperl <metaperl@urth.org>
- test.pl (DoTest): all tests now pass successfully for Postgres and SQLite
- 2003-11-26 U-MOKSHA\metaperl <metaperl@urth.org>
- Recordset.pm (BuildFields): when building the FROM clause for LEFT JOINs Recordset placed parentheses around it, like this:
- SELECT dbixrs1.id,dbixrs1.name,dbixrs1.value1,dbixrs1.addon,dbixrs2.value2 FROM (dbixrs1 left join dbixrs2 on dbixrs1.id = dbixrs2.id) WHERE dbixrs1.id IN (2, 5, 10);
- but this caused a syntax error in sqlite, so a new leftjoin type of 4 was introduced to support LEFT JOIN with no parentheses around the join
- added support to DBIx::Database so that it would accept a DBI database handle. the entire test suite for DBD::Pg now passes.
- added the '$makesql' flag to Search() so that generated SQL can be returned instead of executed. It will remain undocumented until it is supported for Update(), Delete(), and Insert(). It was added in order that the SQL generated for the test "Order, Group, Append" would pass on Postgres which finds the generated SQL invalid.
- Make sure filters given by name override filters given by type.
- t0.24 10. July 2001
- Added Code to DBIx::Database to Create/Modify/Drop tables See CreateTables/DropTables
- *fieldname can take an array ref, to specify different operators for multiple values which should compared to the same field. This is handy for selecting a range.
- Filters are correctly apply if a arrayref with multiple value are passed to a SELECT.
- Reset error code and string in DBIx::Database -> new
- If an array of values id passed in for one field and the operator is '=' now the IN sql operator is used, instead of a set of '='.
- Set Postgres type 1005 to not numeric. Spotted by Michael Maruka.
- Ignore errors in ListFields when retrieving metadata for a table.
- Statement handle is closed as soon as possible, to avoid out of cursors situations.
- new parameter $expr allow to group multiple sub expressions in a sql where, therefore allowing more complex conditions.
- Added new parameter !MergeFunc which allow to specify a function that is called, when multiple records with the same key are found in a DBIx::Recordset::Hash object.
- Added some code to handle table- and fieldnames which include spaces and special charaters. This is still experimental.
- Fixed problem with !TableFilter setup
- Set correct brackets when creating an left outer join. This is necessary for some database to join more the two tables.
Documentation
Modules
Perl extension for Compatibility Infos about DBD Drivers
Perl extension for DBI recordsets
Sequence generator in DBI database
Sequence generator in Filesystem
Provides
in Database.pm
in Recordset.pm
in Recordset.pm
in Recordset.pm