Data::Stream::Bulk::DBI - N-at-a-time iteration of DBI statement results.
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 );
This implementation of Data::Stream::Bulk api works with DBI statement handles, using "fetchall_arrayref" in DBI.
It fetches max_rows at a time (defaults to 500).
max_rows
The statement handle to call fetchall_arrayref on.
fetchall_arrayref
Passed verbatim as the first param to fetchall_arrayref. Should usually be undef, provided for completetness.
undef
The second param to fetchall_arrayref. Controls the size of each buffer.
Defaults to 500.
See Data::Stream::Bulk::DoneFlag.
Calls fetchall_arrayref to get the next chunk of rows.
Calls fetchall_arrayref to get the raminder of the data (without specifying max_rows).
To install Data::Stream::Bulk, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Data::Stream::Bulk
CPAN shell
perl -MCPAN -e shell install Data::Stream::Bulk
For more information on module installation, please visit the detailed CPAN module installation guide.