Data::Stream::Bulk::DBI - phpMan

Data::Stream::Bulk::DBI(3pm)   User Contributed Perl Documentation   Data::Stream::Bulk::DBI(3pm)

NAME
       Data::Stream::Bulk::DBI - N-at-a-time iteration of DBI statement results.

VERSION
       version 0.11

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
               );

DESCRIPTION
       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).

ATTRIBUTES
       sth The statement handle to call "fetchall_arrayref" on.

       slice
           Passed verbatim as the first param to "fetchall_arrayref". Should usually be "undef",
           provided for completetness.

       max_rows
           The second param to "fetchall_arrayref". Controls the size of each buffer.

           Defaults to 500.

METHODS
       get_more
           See Data::Stream::Bulk::DoneFlag.

           Calls "fetchall_arrayref" to get the next chunk of rows.

       all Calls "fetchall_arrayref" to get the raminder of the data (without specifying
           "max_rows").

AUTHOR
       Yuval Kogman <nothingmuch AT woobling.org>

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.

perl v5.32.0                                2021-01-01               Data::Stream::Bulk::DBI(3pm)

Generated by $Id: phpMan.php,v 4.55 2007/09/05 04:42:51 chedong Exp $ Author: Che Dong
On Apache
Under GNU General Public License
2024-12-12 19:45 @3.139.104.9 CrawledBy Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)