[Dbix-class] select sum count group by conversion?

Ulrich Leodolter ulrich.leodolter at univie.ac.at
Sat Feb 10 10:13:56 GMT 2007


Hi, 

i wrote a simple personal training diary,
actually i convert my perl CGI DBI script to Catalyst DBIx::Class.

what is the best way to convert sql querys like this:

SELECT YEAR( datum ) jahr, SUM( km ) summe_km, COUNT( km ) anzahl, 
SUM( time_to_sec( dauer ) ) summe_dauer, SUM( hm ) summe_hm FROM data
WHERE 1 GROUP  BY jahr';

i it possible without literal sql ?




More information about the Dbix-class mailing list