Terrence Brannon

NAME

DBIx::Cookbook::Recipe::Searching::specific_columns - retrieving specific columns

DESCRIPTION

Output the results of the query

  SELECT first_name, last_name FROM actor

Sample Usage:

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

RECIPES

DBIx::Class

    package DBIx::Cookbook::DBIC::Command::specific_columns;
    use Moose;
    extends qw(MooseX::App::Cmd::Command);
    
    use Data::Dump;
    
    sub execute {
      my ($self, $opt, $args) = @_;
    
      my $where = {};
      my $attr = { columns => [qw(first_name last_name)] };
      my $rs = $self->app->schema->resultset('Actor')->search($where, $attr);
    
      my $row = $rs->first;
    
      my %data = $row->get_columns;
      warn Data::Dump::dump(\%data);
    
    }
    
    1;