NAME
Mojo::PgX::Cursor::Results
DESCRIPTION
Mojo::PgX::Cursor::Results is a container for a Mojo::PgX::Cursor::Cursor like Mojo::Pg::Results is for a statement handle. Therefore it tries to mimic the API of Mojo::Pg::Results whereever it makes sense to do do.
This container should behave like Mojo::Pg::Results for array, columns, hash, and expand. It intentionally does not support hashes or arrays since if you wish to use those you should just use query instead. One difference in behavior is rows returns the number of rows in the current iteration not the total rows for the query.
ATTRIBUTES
cursor
my $cursor = $results->cursor;
$results = $results->cursor($cursor);The Mojo::PgX::Cursor::Cursor rows are fetched from.
seconds_blocked
my $time_wasted = $results->seconds_blocked;The cumulative time the cursor has spent waiting for rows.
METHODS
array
my $row = $results->array;Return next row from "cursor" as an array reference.
columns
my $columns = $results->columns;Return column names as an array reference.
expand
$results = $results->expand;Decode json and jsonb fields automatically for all rows.
hash
my $row = $results->hash;Return next row from "cursor" as a hash reference.
new
my $results = Mojo::PgX::Cursor::Results->new(cursor => $cursor);Construct a new Mojo::PgX::Cursor::Results object.
rows
my $num = $results->rows;Number of rows in current iteration; not the total for the original query.
$results->rows(1000);Set the number of rows to fetch in each iteration. Since the next iteration is always pre-fetched up to twice this many rows will be in memory at any given time. Set this to optimize for time or memory in your specific use case.
If not set then the Mojo::PgX::Cursor::Cursor default fetch size is used.
wait
$results->wait;Wait for background query to finish. This would be used to block before making another background query on the same database handle.
LICENSE
Copyright (C) Nathaniel Nutter.
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
AUTHOR
Nathaniel Nutter nnutter@cpan.org
SEE ALSO
Mojo::PgX::Cursor, Mojo::PgX::Cursor::Cursor, Mojo::PgX::Cursor::Database