Tangram::Cursor - traverse a result set
$cursor = $storage->cursor($remote, $filter); while (my $obj = $cursor->current()) { # process $obj $cursor->next(); } $cursor->execute(); while (my $obj = $cursor->current()) { # process $obj $cursor->next(); }
A Cursor makes it possible to iterate over a result set without loading all the objects in memory.
$obj = $cursor->current();
Returns the current object, or undef() if the result set is exhausted.
$obj = $cursor->next(); @obj = $cursor->next();
Moves to the next object in the result set, if any. Returns the new current object, or undef() if the result set is exhausted. In list context, return all the remaining objects.
$cursor->execute();
Moves the cursor to the first object in the result set, and return it. Note that preparing Cursors is an expensive operation, you should reuse them if possible. execute() allows just that.
execute() may be called several times in a row, or on a Cursor that has just been obtained from a Storage, without ill effects.
my @vals = $cursor->residue();
Returns the values of the Expr that were passed to the retrieve directive of the Storage::select() or Storage::cursor() statement.
retrieve
Each Cursor opens its own connection to the database.
Tangram::Storage
To install Tangram, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Tangram
CPAN shell
perl -MCPAN -e shell install Tangram
For more information on module installation, please visit the detailed CPAN module installation guide.