Merge pull request #29 from nicjansma/master

Documentation update with an example for .execute('array')
xavierlacot · Aug 8, 2012 · 931bea4 · 931bea4
2 parents 74496d2 + 3fe97a2
commit 931bea4
Showing 1 changed file with 18 additions and 0 deletions.
diff --git a/README.markdown b/README.markdown
@@ -239,6 +239,24 @@ In some cases however, you will find this way of querying your models just too l
       order: ['last_name desc', 'first_name asc']
     });
 
+### Data retrieval for queries with no specific model (eg, GROUP BY)
+
+Some query results can't be mapped back to a Joli model.  For example, when using a `GROUP BY` statement:
+
+    SELECT city, COUNT(*) as count
+    FROM human
+    GROUP BY city
+
+The rows returned by the above query are not Joli models, but simple `[city, count]` tuples.
+
+To avoid having Joli try to map the query results to a model, you can pass a string parameter `"array"` to the 
+`.execute()` function to have the results returned as an array of simple objects:
+
+    var q = new joli.query()
+        .select('city, COUNT(*) as count')
+        .from('human')
+        .groupBy('city')
+        .execute("array");
 
 ## Internals
 joli.js is made of several classes: