Encapsulate SQL queries and rows in simple perl objects
http://search.cpan.org/perldoc?DBIx::SearchBuilder
This module provides an object-oriented mechanism for retrieving and updating data in a DBI-accesible database.
In order to use this module, you should create a subclass of DBIx::SearchBuilder and a subclass of DBIx::SearchBuilder::Record for each table that you wish to access. (See the documentation of DBIx::SearchBuilder::Record for more information on subclassing it.)
Your DBIx::SearchBuilder subclass must override NewItem, and probably should override at least _Init also; at the very least, _Init should probably call _Handle and _Table to set the database handle (a DBIx::SearchBuilder::Handle object) and table name for the class. You can try to override just about every other method here, as long as you think you know what you are doing.
- Download package
-
Checkout Package
osc -A https://api.opensuse.org checkout devel:languages:perl/perl-DBIx-SearchBuilder && cd $_ - Create Badge
Refresh
Refresh
Source Files
| Filename | Size | Changed |
|---|---|---|
| DBIx-SearchBuilder-1.59.tar.gz | 0000095460 93.2 KB | |
| perl-DBIx-SearchBuilder-Makefile.patch | 0000001015 1015 Bytes | |
| perl-DBIx-SearchBuilder.changes | 0000001936 1.89 KB | |
| perl-DBIx-SearchBuilder.spec | 0000003087 3.01 KB |
Revision 5 (latest revision is 26)
Stephan Kulow (coolo)
committed
(revision 5)
- updated to 1.59
* DBIx::SearchBuilder->DistinctFieldValues method
* SIGNATURE fix
* delete obsolete cvs metadata from a module
* INCOMPATIBLE CHANGE: NextPage and PrevPage were adding rows from
the previous page. Jesse claims that when he wrote this code, he
was 20 years old and it seemed like a good idea at the time.
* When logging queries, include full stack trace
* support $sb->NewAlias( 'table' => 'LEFT' );
* allow join to depend on nothing
* catch cases when there are more closing parens then should be
* Oracle: Use ROW_NUMBER() to propagate row ordering from inside the DISTINCT
* Various performance improvements through small internal refactorings
* Implemented 'sub Fields' on Oracle
* unify case insensitive characters to avoid using LOWER() in some
cases
* We now RedoSearch when RowsPerPage is changed
* No longer RedoSearch if FirstRow is called, but is not actually changed
* Document all paging functions and test them
* handle LOWER() in redundant LEFT joins optimizer,
for Oracle and may be Pg
* Make debugging problems easier by passing errors back
https://rt.cpan.org/Ticket/Display.html?id=55203
* fix Record->PrimaryKeys, field names in values hash are lc'ed
https://rt.cpan.org/Ticket/Display.html?id=18280
* doc updates and cleanups
Comments 0