dbix::class::storage::dbi::cursor5.18(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::Manual::DocMap(3pm) User Contributed Perl Documentation DBIx::Class::Manual::DocMap(3pm)NAME
DBIx::Class::Manual::DocMap - What documentation do we have?
Manuals
DBIx::Class::Manual - User's Manual overview.
DBIx::Class::Manual::FAQ - Frequently Asked Questions, gathered from IRC and the mailing list.
DBIx::Class::Manual::Intro - Introduction to setting up and using DBIx::Class.
DBIx::Class::Manual::Example - Full example Schema.
DBIx::Class::Manual::Cookbook - Various short recipes on how to do things.
DBIx::Class::Manual::Troubleshooting - What to do if things go wrong (diagnostics of known error messages).
DBIx::Class::Manual::Component - How to write your own DBIx::Class components.
DBIx::Class::Manual::Glossary - What do all those terms mean?
Setting up
DBIx::Class::Schema - Overall schemas, and connection container.
DBIx::Class::ResultSource - Source/Table definition functions.
DBIx::Class::Relationship - Simple relationships.
DBIx::Class::Relationship::Base - Relationship details.
DBIx::Class::PK::Auto - Magically retrieve auto-incrementing fields.
DBIx::Class::Core - Set of standard components to load.
DBIx::Class::InflateColumn - Making objects out of your columns.
DBIx::Class::InflateColumn::DateTime - Magically turn your datetime or timestamp columns into DateTime objects.
DBIx::Class::PK - Dealing with primary keys.
DBIx::Class::ResultSourceProxy::Table - Turns the resultsource into a table.
DBIx::Class::AccessorGroup - Accessor grouping.
Retrieving and creating data
DBIx::Class::ResultSet - Selecting and manipulating sets.
DBIx::Class::ResultSetColumn - Perform operations on entire columns of a ResultSet.
DBIx::Class::Row - Dealing with actual data.
DBIx::Class::Storage - Basic Storage stuff.
DBIx::Class::Storage::DBI - Storage using DBI and SQL::Abstract.
perl v5.14.2 2010-06-03 DBIx::Class::Manual::DocMap(3pm)
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)
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)
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)