[Dbix-class] min/max/etc methods?

Matt S Trout dbix-class at trout.me.uk
Wed Nov 16 01:48:33 CET 2005


On Wed, Nov 16, 2005 at 12:27:39AM +0000, Jules Bean wrote:
> Brandon Black wrote:
> >It would be nice if DBIx::Class::Table had more aggregate-style
> >methods than just "->count".  max and min are probably the most
> >important/widely-used.  There's also other aggregates like: avg,
> >stddev, sum, variance, etc.
> >  
> 
> (Do they really call it stddev? how un-mathematical of them :P)
> 
> Not just aggregates either. Can we call DB functions at all?

Not properly yet.

I've been pondering something along the lines of

$rs->get_column('foo')->func('MAX') or similar

More importantly, I want records to be inflatable from any resultset,
not just 'SELECT * FROM table'. But I need to get C3 working first ...

-- 
     Matt S Trout       Specialists in Perl consulting, web development, and
  Technical Director    UNIX/Linux systems architecture and automation. Mail
Shadowcat Systems Ltd.  mst (at) shadowcatsystems.co.uk for more information

 + Help us build a better perl ORM: http://dbix-class.shadowcatsystems.co.uk/ +



More information about the Dbix-class mailing list