NAME
DBIx::ReportBuilder::Search - Extended SearchBuilder
SYNOPSIS
my $sb = DBIx::ReportBuilder::Search->new(
Host => 'localhost',
Port => '3306',
User => 'root',
Driver => 'mysql',
Database => 'rt3',
);
$sb->SetTable('Queues');
$sb->GroupBy( FIELD => 'Disabled' );
my $col1 = $sb->Column( FIELD => 'Disabled' );
my $col2 = $sb->Column( FIELD => 'Id', FUNCTION => 'SUM' );
my $col3 = $sb->Column( FIELD => 'Id', FUNCTION => 'COUNT' );
$sb->UnLimit;
print join("\t", qw(Disabled SUM(id) COUNT(id))), "\n";
while (my $row = $sb->Next) {
print join(
"\t",
$row->{$col1}, $row->{$col2}, $row->{$col3}
), "\n";
};
DESCRIPTION
This module implements a subclass of DBIx::SearchBuilder. The main difference is that it defines a default LoadFromHash
and NewItem
, so is directly usable without needing to subclass it first.
It also implements GroupBy
, GroupByCols
, Column
and an assortment of other utility functions.
SEE ALSO
DBIx::ReportBuilder, DBIx::SearchBuilder
AUTHORS
Autrijus Tang <autrijus@autrijus.org>
COPYRIGHT
Copyright 2003 by Autrijus Tang <autrijus@autrijus.org>.
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.