DBIx::Custom::Result - Result of select statement

    # Result
    my $result = $dbi->select(table => 'book');

    # Fetch a row and put it into array reference
    while (my $row = $result->fetch) {
        my $author = $row->[0];
        my $title  = $row->[1];
    }

    # Fetch only a first row and put it into array reference
    my $row = $result->fetch_first;

    # Fetch all rows and put them into array of array reference
    my $rows = $result->fetch_all;

    # Fetch a row and put it into hash reference
    while (my $row = $result->fetch_hash) {
        my $title  = $row->{title};
        my $author = $row->{author};
    }

    # Fetch only a first row and put it into hash reference
    my $row = $result->fetch_hash_first;
    my $row = $result->one; # Same as fetch_hash_first

    # Fetch all rows and put them into array of hash reference
    my $rows = $result->fetch_hash_all;
    my $rows = $result->all; # Same as fetch_hash_all

    my $filters = $result->filters;
    $result = $result->filters(\%filters);

Filters.

    my $sth = $reuslt->sth
    $result = $result->sth($sth);

Statement handle of DBI.

DBIx::Custom::Result inherits all methods from Object::Simple and implements the following new ones.

    my $rows = $result->all;

Same as fetch_hash_all.

    my $row = $result->fetch;

Fetch a row and put it into array reference.

    my $rows = $result->fetch_all;

Fetch all rows and put them into array of array reference.

    my $row = $result->fetch_first;

Fetch only a first row and put it into array reference, and finish statment handle.

    my $row = $result->fetch_hash;

Fetch a row and put it into hash reference.

    my $rows = $result->fetch_hash_all;

Fetch all rows and put them into array of hash reference.

    my $row = $result->fetch_hash_first;

Fetch only a first row and put it into hash reference, and finish statment handle.

    my $rows = $result->fetch_hash_multi(5);

Fetch multiple rows and put them into array of hash reference.

    my $rows = $result->fetch_multi(5);

Fetch multiple rows and put them into array of array reference.

    $result->filter(title  => sub { uc $_[0] }, author => 'to_upper');
    $result->filter([qw/title author/] => 'to_upper');

Set filter for column. You can use subroutine or filter name as filter. This filter is executed after type_rule filter.

    $result = $result->filter_off;

Turn filtering by filter method off. By default, filterin is on.

    $result = $resutl->filter_on;

Turn filtering by filter method on. By default, filterin is on.

    my $row = $result->one;

Same as fetch_hash_first.

    my $stash = $result->stash;
    my $foo = $result->stash->{foo};
    $result->stash->{foo} = $foo;

Stash is hash reference for data.

    # Merge type rule
    $result->type_rule(
        # DATE
        9 => sub { ... },
        # DATETIME or TIMESTAMP
        11 => sub { ... }
    );

    # Replace type rule(by reference)
    $result->type_rule([
        # DATE
        9 => sub { ... },
        # DATETIME or TIMESTAMP
        11 => sub { ... }
    ]);

This is same as DBIx::Custom's type_rule's <from>.

    $result = $result->type_rule_off;

Turn from1 and from2 type rule off. By default, type rule is on.

    $result = $result->type_rule_on;

Turn from1 and from2 type rule on. By default, type rule is on.

    $result = $result->type_rule1_off;

Turn from1 type rule off. By default, type rule is on.

    $result = $result->type_rule1_on;

Turn from1 type rule on. By default, type rule is on.

    $result = $result->type_rule2_off;

Turn from2 type rule off. By default, type rule is on.

    $result = $result->type_rule2_on;

Turn from2 type rule on. By default, type rule is on.