__PACKAGE__->config( dsn => 'dbi:Oracle:DUMMY', username => 'dummyuser', password => 'dummypass', options => { AutoCommit => 1 }, ); #### sub dummyMethod { my ( $self, $id ) = @_; my $r = $self->dbh->selectrow_hashref("SELECT id, name FROM users WHERE id = $id"); return $r; } #### sub index :Path :Args(0) { my ( $self, $c ) = @_; my $data = $c->model("DB")->dummyMethod(12); $c->stash->{data} = Data::Dump::pp($data); $c->stash->{template} = 'homepage.tt2'; }