Trevor Phillips wrote:
2009/9/21 Андрей Костенко <[email protected]>:
You can create a view for this query. e.g.
CREATE VIEW stats AS SELECT MIN(a), MAX(a), AVG(a) FROM table1;
I could, but it's not the query I'm having a problem with - it's
mapping it to columns within the pre-existing DBIx::Class. I'd rather
not have to create a whole new class simply for this single query
against my data. I can see the data in the raw object - I just can't
access it through the normal methods.
Reading the manual, I should be able to get the value via get_column,
but Catalyst/TT uses the column methods instead.
Hmmm, I *can* use get_column within TT, but that seems to defeat the
purpose of abstracting data from presentation.
You could leave the accessor abstracted by creating the function within
the result class. Along the lines of
sub a_min { return shift->get_column('a_min'); };
When getting the search results, I can map the rows with
$_->get_columns(). That seems to be the easiest solution for now.
--
Trevor Phillips - http://dortamur.livejournal.com/
"On nights such as this, evil deeds are done. And good deeds, of
course. But mostly evil, on the whole."
-- (Terry Pratchett, Wyrd Sisters)
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[email protected]
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[email protected]
