logo
Free, unlimited AI code reviews that run on commit
git-lrc git-lrc GitHub Install Now We'd appreciate a star git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt

DBIx::Class::Storage::DBI::Cursor - Object representing a query cursor on a resultset.

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.

Further Questions?

       Check the list of additional DBIC resources.

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.

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;

See Also