Terrence Brannon

NAME

DBIx::Cookbook::Recipe::Searching::db_func - execute a db function on a column

DESCRIPTION

Execute the following query:

  SELECT first_name, LENGTH(first_name) FROM actor

Sample Usage:

  ${orm}_cmd db_func     # orm = dbic, skinny, rose, etc

RECIPES

DBIx::Class

    package DBIx::Cookbook::DBIC::Command::db_func;
    use Moose;
    extends qw(MooseX::App::Cmd::Command);
    
    =for NOTE
    
      the as attribute has absolutely *NOTHING* to do with 
      the SQL syntax  SELECT foo AS bar
    
      it is used to specify how the columns will be accessed
    
    =cut
    
    sub execute {
      my ($self, $opt, $args) = @_;
    
      
    
      my $rs = do {
    
        my $where = {};
        my $attr = {
                select => [ 'first_name', { LENGTH => 'first_name' } ],
                as     => [ qw/first_name first_name_length/ ]
               };
    
        $self->app->schema->resultset('Actor')->search($where, $attr);
    
      } ;
    
      while (my $row = $rs->next) {
        use Data::Dumper;
        my %data = $row->get_columns;
        warn Dumper(\%data);
        
      }
    }
    
    1;