NAME

DBIx::Cookbook::Recipe::Searching::get_column - get all values in a column

DESCRIPTION

SELECT title FROM film_text

Sample Usage:

shell> ${orm}_cmd get_column  # orm = dbic, skinny, rose, etc

RECIPES

DBIx::Class

package DBIx::Cookbook::DBIC::Command::get_column;
use Moose;
extends qw(MooseX::App::Cmd::Command);

use Data::Dump;

# http://search.cpan.org/~ribasushi/DBIx-Class-0.08120/lib/DBIx/Class/ResultSetColumn.pm
sub execute {
  my ($self, $opt, $args) = @_;

  my @data = 
    $self->app->schema->resultset('FilmText')->get_column('title')->all;

  warn Data::Dump::dump(\@data);

}

1;