Tangram::Cursor(3pm) User Contributed Perl Documentation Tangram::Cursor(3pm)NAME
Tangram::Cursor - traverse a result set
SYNOPSIS
$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();
}
DESCRIPTION
A Cursor makes it possible to iterate over a result set without loading all the objects in memory.
See also the "limit" option to the select method of the Tangram::Storage class.
INSTANCE METHODS
current
$obj = $cursor->current();
Returns the current object, or undef() if the result set is exhausted.
next
$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 con-
text, return all the remaining objects.
execute
$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.
residue
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.
CURSORS AND CONNECTIONS
Each Cursor opens its own connection to the database.
SEE ALSO
Tangram::Storage
perl v5.8.8 2006-03-29 Tangram::Cursor(3pm)
Check Out this Related Man Page
DBIx::Class::Storage::DBI::Cursor(3) User Contributed Perl Documentation DBIx::Class::Storage::DBI::Cursor(3)NAME
DBIx::Class::Storage::DBI::Cursor - Object representing a query cursor on a resultset.
SYNOPSIS
my $cursor = $schema->resultset('CD')->cursor();
# raw values off the database handle in resultset columns/select order
my @next_cd_column_values = $cursor->next;
# list of all raw values as arrayrefs
my @all_cds_column_values = $cursor->all;
DESCRIPTION
A Cursor represents a query cursor on a DBIx::Class::ResultSet object. It allows for traversing the result set with "next", retrieving all
results with "all" and resetting the cursor with "reset".
Usually, you would use the cursor methods built into DBIx::Class::ResultSet to traverse it. See "next" in DBIx::Class::ResultSet, "reset"
in DBIx::Class::ResultSet and "all" in DBIx::Class::ResultSet for more information.
METHODS
new
Returns a new DBIx::Class::Storage::DBI::Cursor object.
next
Arguments: none
Return Value: @row_columns
Advances the cursor to the next row and returns an array of column values (the result of "fetchrow_array" in DBI method).
all
Arguments: none
Return Value: @row_columns+
Returns a list of arrayrefs of column values for all rows in the DBIx::Class::ResultSet.
reset
Resets the cursor to the beginning of the DBIx::Class::ResultSet.
perl v5.18.2 2014-01-22 DBIx::Class::Storage::DBI::Cursor(3)
Hi,
Somebody Knows why i have to execute $ cd ./<directory> instead only $ cd <directory>.
I get the error :
$ cd <directory>
sh: <directory>: not found.
else
$ cd ./<directory>
$
$ echo $PATH
.:/usr/local/bin
Thanks (1 Reply)
Hi all,
I am new to SQLPLUS, can anyone tell me what is the following codes doing?
DECLARE
cursor c1 is select bts_int_id,
max(ave_busy_tch/res_av_denom14) maxBusyTch
from p_nbsc_res_avail
where to_char(period_start_time,'yyyymmdd')=to_char((sysdate-1),'yyyymmdd')
group by... (4 Replies)
Hi,
I'm trying to execute a script which calls a SQR.
The SQR is throwing an error
SQR 5528-sybase ct_connect error in cursor 0
Login falied
SQR 4701-Cannot connect to the database
I'm not sure where is the id/password specified as this is an existing script.
Any idea as where is... (1 Reply)
Hi,
I was Googling to get info "How OS loads process into its memory to execute?" i mean when i execute ./<exename> , How OS exectes it?
It will be better if i tell my intention,
In my $LOGNAME saveral process are running, among all of these two process are my target process. Basically I... (1 Reply)
I am writing a cursor to select values from 3 tables. I want to store these values in a txt file which I will be sending via ftp. I am able to store the results of simple select queries to the txt file. but I am not sure how to store the values when using a cursor. I have given the sql query below.... (1 Reply)