data::stream::bulk::dbi(3pm) [debian man page]

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@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.14.2							    2012-02-14					      Data::Stream::Bulk::DBI(3pm)

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

NAME

       Data::Stream::Bulk::Util - Utility functions for Data::Stream::Bulk

VERSION

       version 0.11

SYNOPSIS

	       use Data::Stream::Bulk::Util qw(array);

	       use namespace::clean;

	       # Wrap a list in L<Data::Stream::Bulk::Array>
	       return bulk(qw(foo bar gorch baz));

	       # return an empty resultset
	       return nil();

DESCRIPTION

       This module exports convenience functions for use with Data::Stream::Bulk.

EXPORTS

       Sub::Exporter is used to create the "import" routine, and all of its aliasing/currying goodness is of course supported.

       nil Creates a new Data::Stream::Bulk::Nil object.

	   Takes no arguments.

       bulk @items
	   Creates a new Data::Stream::Bulk::Array wrapping @items.

       cat @streams
	   Concatenate several streams together.

	   Returns "nil" if no arguments are provided.

       filter { ... } $stream
	   Calls "filter" on $stream with the provided filter.

       unique $stream
	   Filter the stream to remove duplicates.

	   Note that memory use may potentially scale to O(k) where k is the number of distinct items, because this is implemented in terms of a
	   seen hash.

	   In the future this will be optimized to be iterative for sorted streams.

	   References are keyed by their refaddr (see "id" in Hash::Util::FieldHash).

AUTHOR

       Yuval Kogman <nothingmuch@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.14.2							    2012-02-14					     Data::Stream::Bulk::Util(3pm)