NAME
Mojo::PgX::Cursor::Results
SYNOPSIS
DESCRIPTION
Mojo::PgX::Cursor::Results is a container for Mojo::PgX::Cursor cursor like Mojo::Pg::Results is for statement handles.
ATTRIBUTES
cursor
my $cursor = $results->cursor;
$results = $results->cursor($cursor);Mojo::PgX::Cursor::Cursor results are fetched from.
fetch
$results->fetch(10);The quantity of rows to fetch in each batch of rows. Smaller uses less memory. Since the next batch is always pre-fetched up to twice this many rows will be in memory at any given time. Defaults to 100.
seconds_blocked
my $time_wasted = $results->seconds_blocked;The cumulative time the cursor has spent blocking upon running out of rows.
METHODS
array
my $row = $results->array;Return next row from "cursor" as an array reference. If necessary, the next row will be fetched first.
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. If necessary, the next row will be fetched first.
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 batch; not total.
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