The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.
 / 
DBIx-Cookbook-0.09
River stage zero No dependents
++
/ DBIx::Cookbook::Recipe::Searching::get_column

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;