Gecko [ fernandoquevedodop.com ]

Name	Size	Permission
Path	[ DIR ]	drwxr-xr-x
Array.pm	2.56 KB	-rw-r--r--
Callback.pm	1.53 KB	-rw-r--r--
Cat.pm	1.79 KB	-rw-r--r--
Chunked.pm	2.01 KB	-rw-r--r--
DBI.pm	2.31 KB	-rw-r--r--
DBIC.pm	1.72 KB	-rw-r--r--
DoneFlag.pm	2.15 KB	-rw-r--r--
FileHandle.pm	1.51 KB	-rw-r--r--
Filter.pm	1.87 KB	-rw-r--r--
Nil.pm	1.41 KB	-rw-r--r--
Util.pm	2.45 KB	-rw-r--r--

Code Editor : DBI.pm

package Data::Stream::Bulk::DBI;
BEGIN {
  $Data::Stream::Bulk::DBI::AUTHORITY = 'cpan:NUFFIN';
}
{
  $Data::Stream::Bulk::DBI::VERSION = '0.11';
}
use Moose;
# ABSTRACT: N-at-a-time iteration of L<DBI> statement results.

use namespace::clean -except => 'meta';

with qw(Data::Stream::Bulk::DoneFlag) => { -excludes => [qw/is_done all finished/] };

has sth => (
	isa => "Object",
	is  => "ro",
	required => 1,
	handles => [qw(fetchall_arrayref)],
	clearer => "finished",
);

has slice => (
	is  => "ro",
);

has max_rows => (
	isa => "Int",
	is  => "rw",
	default => 500,
);

sub get_more {
	my $self = shift;
	$self->fetchall_arrayref( $self->slice, $self->max_rows );
}

sub all {
	my $self = shift;

my $all = $self->fetchall_arrayref( $self->slice );

$self->_set_done;

return @$all;
}

__PACKAGE__->meta->make_immutable;

__PACKAGE__;

=pod

=head1 NAME

Data::Stream::Bulk::DBI - N-at-a-time iteration of L<DBI> statement results.

=head1 VERSION

version 0.11

=head1 SYNOPSIS

use Data::Stream::Bulk::DBI;

my $sth = $dbh->prepare("SELECT hate FROM sql"); # very big resultset
	$sth->execute;

return Data::Stream::Bulk::DBI->new(
		sth => $sth,
		max_rows => $n, # how many at a time
		slice => [ ... ], # if you want to pass the first param to fetchall_arrayref
	);

=head1 DESCRIPTION

This implementation of L<Data::Stream::Bulk> api works with DBI statement
handles, using L<DBI/fetchall_arrayref>.

It fetches C<max_rows> at a time (defaults to 500).

=head1 ATTRIBUTES

=over 4

=item sth

The statement handle to call C<fetchall_arrayref> on.

=item slice

Passed verbatim as the first param to C<fetchall_arrayref>. Should usually be
C<undef>, provided for completetness.

=item max_rows

The second param to C<fetchall_arrayref>. Controls the size of each buffer.

Defaults to 500.

=back

=head1 METHODS

=over 4

=item get_more

See L<Data::Stream::Bulk::DoneFlag>.

Calls C<fetchall_arrayref> to get the next chunk of rows.

=item all

Calls C<fetchall_arrayref> to get the raminder of the data (without specifying
C<max_rows>).

=back

=head1 AUTHOR

Yuval Kogman <nothingmuch@woobling.org>

=head1 COPYRIGHT AND LICENSE

This is free software; you can redistribute it and/or modify it under
the same terms as the Perl 5 programming language system itself.

=cut

__END__

${this.title}

Code Editor : DBI.pm