Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

dbix::class::storage::dbi::cursor(3) [mojave 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)

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)
Man Page

7 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Cursor positioning thru VI Editor

Is there a way that I can position cursor at say line 23, column 2? Thank you in advance. (8 Replies)
Discussion started by: Latha Nair
8 Replies

2. Programming

Cursor Global Position

Hello all, How can i get the global position of the cursor? (i'm using c language, and suse 10.1 linux) Thanks. (3 Replies)
Discussion started by: boogy
3 Replies

3. Shell Programming and Scripting

Redirecting sql select query result to txt file

Hi Yogesh, Lucky that i caught you online. Yeah i read about DBI and the WriteExcel module. But the server is not supporting these modules. It said..."Cannot locate DBI"..."Cannot locate Spreadsheet::WriteExcel" I tried creating a simple text file to get the query output, but the... (1 Reply)
Discussion started by: dolphin123
1 Replies

4. UNIX for Dummies Questions & Answers

Cursor position

Is there a way of finding the current cursor position (line & column) within AIX (4 Replies)
Discussion started by: gefa
4 Replies

5. Shell Programming and Scripting

perl: fetchall_arrayref() question

Hi there, I wonder if somebody could help me out, i have a written a DBI perl snippet using fetchall_arrayref() that i want to use to populate a simple standard array with the results of a query #!/usr/bin/perl -w use DBI; my $dbh =... (3 Replies)
Discussion started by: hcclnoodles
3 Replies

6. Shell Programming and Scripting

Store output of DB Cursor to a txt file

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)
Discussion started by: naveensraj
1 Replies

7. Shell Programming and Scripting

Generating file from sqlplus

Hi Frndz, I have req in which i need to run the query stored in some file and then store the resultset of the query in some other file. PFB the code i have written: #----Start job log--- SQLLOG='/opt/app/vertica2/cdr_dev/logs/conn_orac_db.log' ORA_USER='abc' ORA_PASSWD='xyz' ... (7 Replies)
Discussion started by: gnnsprapa
7 Replies