GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages
DBIx::Class::ResultSetColumn(3) User Contributed Perl Documentation DBIx::Class::ResultSetColumn(3)

  DBIx::Class::ResultSetColumn - helpful methods for messing
  with a single column of the resultset

  $rs = $schema->resultset('CD')->search({ artist => 'Tool' });
  $rs_column = $rs->get_column('year');
  $max_year = $rs_column->max; #returns latest year

A convenience class used to perform operations on a specific column of a resultset.

  my $obj = DBIx::Class::ResultSetColumn->new($rs, $column);

Creates a new resultset column object from the resultset and column passed as params. Used internally by "get_column" in DBIx::Class::ResultSet.

Arguments: none
Return Value: \[ $sql, @bind_values ]

Returns the SQL query and bind vars associated with the invocant.

This is generally used as the RHS for a subquery.

Arguments: none
Return Value: $value

Returns the next value of the column in the resultset (or "undef" if there is none).

Much like "next" in DBIx::Class::ResultSet but just returning the one value.

Arguments: none
Return Value: @values

Returns all values of the column in the resultset (or "undef" if there are none).

Much like "all" in DBIx::Class::ResultSet but returns values rather than result objects.

Arguments: none
Return Value: $self

Resets the underlying resultset's cursor, so you can iterate through the elements of the column again.

Much like "reset" in DBIx::Class::ResultSet.

Arguments: none
Return Value: $value

Resets the underlying resultset and returns the next value of the column in the resultset (or "undef" if there is none).

Much like "first" in DBIx::Class::ResultSet but just returning the one value.

Arguments: none
Return Value: $value

Much like "single" in DBIx::Class::ResultSet fetches one and only one column value using the cursor directly. If additional rows are present a warning is issued before discarding the cursor.

Arguments: none
Return Value: $lowest_value

  my $first_year = $year_col->min();

Wrapper for ->func. Returns the lowest value of the column in the resultset (or "undef" if there are none).

Arguments: none
Return Value: $resultset

  my $rs = $year_col->min_rs();

Wrapper for ->func_rs for function MIN().

Arguments: none
Return Value: $highest_value

  my $last_year = $year_col->max();

Wrapper for ->func. Returns the highest value of the column in the resultset (or "undef" if there are none).

Arguments: none
Return Value: $resultset

  my $rs = $year_col->max_rs();

Wrapper for ->func_rs for function MAX().

Arguments: none
Return Value: $sum_of_values

  my $total = $prices_col->sum();

Wrapper for ->func. Returns the sum of all the values in the column of the resultset. Use on varchar-like columns at your own risk.

Arguments: none
Return Value: $resultset

  my $rs = $year_col->sum_rs();

Wrapper for ->func_rs for function SUM().

Arguments: $function
Return Value: $function_return_value

  $rs = $schema->resultset("CD")->search({});
  $length = $rs->get_column('title')->func('LENGTH');

Runs a query using the function on the column and returns the value. Produces the following SQL:

  SELECT LENGTH( title ) FROM cd me

Arguments: $function
Return Value: $resultset

Creates the resultset that "func()" uses to run its query.

See "throw_exception" in DBIx::Class::Schema for details.

Check the list of additional DBIC resources.

This module is free software copyright by the DBIx::Class (DBIC) authors. You can redistribute it and/or modify it under the same terms as the DBIx::Class library.
2020-03-29 perl v5.32.1

Search for    or go to Top of page |  Section 3 |  Main Index

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with ManDoc.