Changeset 2459 for branches/release-39/lib/MT/ObjectDriver/Driver/DBI.pm

Timestamp:

05/29/08 17:22:32 (18 months ago)

Author:

bchoate

Message:

Adding support for a max_group_by method. BugId:79914

Files:

• branches/release-39/lib/MT/ObjectDriver/Driver/DBI.pm (modified) (1 diff)

branches/release-39/lib/MT/ObjectDriver/Driver/DBI.pm

@@ -116 +116 @@
     $args->{direction} = 'descend' unless exists $args->{direction};
     $driver->_do_group_by("AVG($avg_column) AS avg_$avg_column", @_);
+}
+
+sub max_group_by {
+    my $driver = shift;
+    my ($class, $terms, $args) = @_;
+
+    my $max_column = delete $args->{max};
+    return unless $max_column;
+    $max_column = $driver->_decorate_column_name($class, $max_column);
+    $args->{sort} = "max_$max_column" unless exists $args->{sort};
+    $args->{direction} = 'descend' unless exists $args->{direction};
+    $driver->_do_group_by("MAX($max_column) AS max_$max_column", @_);
 }