/ 
DBIx-SearchBuilder-1.46
River stage one • 3 direct dependents • 3 total dependents

Changes for version 1.46 - 2007-02-25

  • when doing a union, we need to actually search, rather than just doing a count
  • add support for testing with Oracle backend
  • Use CROSS JOIN instead of ',' as SQL parsers in Pg and some mysql are buggy and cannot parse "FROM X, Y JOIN Z ON Z.f = X.f"
  • deprecate DEBUG method, it's still there but produce warning
  • fix CleanSlate method that was missing several keys
  • fix a long standing bug we had, we didn't write depends_on data about a join, so we could build queries with incorrect parens around join conditions
  • fix default values for ALIAS1 argument in the Join method, istead of defaulting FIELD1 to 'main' value
  • fix a TODO test
  • internal refactoring of a storage for query's conditions, instead of building query strings right after the limit or join, we now build a perl structure
  • don't clone attributes that don't exists in the Clone method
  • we use Encode module without perl version check for a long time, so we can get rid of all checks for the version and load the module at compile time everywhere we need it
  • implement MayBeNull method in the handler that checks if applied conditions allow NULLs in the result set
  • implement cascaded LEFT JOINs optimization
  • additional tests for CleanSlate and Clone methods, ENTRY_AGGREGATOR argument, different types of joins and LEFT JOIN optimizer

Modules

DBIx::SearchBuilder
Encapsulate SQL queries and rows in simple perl objects
DBIx::SearchBuilder::Handle
Perl extension which is a generic DBI handle
DBIx::SearchBuilder::Handle::Informix
An Informix specific Handle object
DBIx::SearchBuilder::Handle::ODBC
An ODBC specific Handle object
DBIx::SearchBuilder::Handle::Oracle
An oracle specific Handle object
DBIx::SearchBuilder::Handle::Pg
A Postgres specific Handle object
DBIx::SearchBuilder::Handle::SQLite
A SQLite specific Handle object
DBIx::SearchBuilder::Handle::Sybase
a Sybase specific Handle object
DBIx::SearchBuilder::Handle::mysql
A mysql specific Handle object
DBIx::SearchBuilder::Handle::mysqlPP
A mysql specific Handle object
DBIx::SearchBuilder::Record
Superclass for records loaded by SearchBuilder
DBIx::SearchBuilder::Record::Cachable
Records with caching behavior
DBIx::SearchBuilder::SchemaGenerator
Generate table schemas from DBIx::SearchBuilder records
DBIx::SearchBuilder::Union
Deal with multiple SearchBuilder result sets as one
DBIx::SearchBuilder::Unique
Ensure uniqueness of records in a collection

Provides

Example::Model::Address
in ex/Example/Model/Address.pm
Example::Model::Employee
in ex/Example/Model/Employee.pm

Examples

Other files