/usr/share/perl5/Data/Stream/Bulk/DBI.pm is in libdata-stream-bulk-perl 0.11-1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 | 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 software is copyright (c) 2012 by Yuval Kogman.
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__
|