Merged pull request #6 from karb/patch-1.

added groupBy function
xavierlacot · Apr 28, 2011 · e53bdd2 · e53bdd2
2 parents 8cb13db + 80b55d3
commit e53bdd2
Showing 1 changed file with 13 additions and 0 deletions.
diff --git a/joli.js b/joli.js
@@ -494,6 +494,10 @@ joli.query.prototype = {
       query += ' where ' + this.data.where;
     }
 
+    if (this.data.groupBy) {
+      query += ' group by ' + this.data.groupBy.join(', ');
+    }
+
     if (this.data.order.length > 0) {
       query += ' order by ' + this.data.order.join(', ');
     }
@@ -505,6 +509,15 @@ joli.query.prototype = {
     return query;
   },
 
+  groupBy: function(group) {
+    if ('string' == joli.getType(group)) {
+      group = [group];
+    }
+
+    this.data.groupBy = group;
+    return this;
+  },
+
   hydrate: function(rows) {
     var result = [];