submodule update (joli.js) + added one test for the HAVING clause

xavierlacot · Jul 11, 2012 · 96403d1 · 96403d1
1 parent 7fc6fe0
commit 96403d1
Show file tree

Hide file tree

Showing 2 changed files with 6 additions and 1 deletion.
diff --git a/Resources/lib/vendor/joli.js b/Resources/lib/vendor/joli.js
diff --git a/Resources/test/query.js b/Resources/test/query.js
@@ -31,6 +31,11 @@
       expect(q.getQuery()).toBe('select city_id, count(*) as total from human group by city_id, first_name');
     });
 
+    it('joli.query.having()', function() {
+      q = new joli.query().select('count(human.id) as nb_humans').from('human').groupBy('city_id').having('nb_humans > ?', 1);
+      expect(q.getQuery()).toBe('select count(human.id) as nb_humans from human group by city_id having nb_humans > "1"');
+    });
+
     it('joli.query.insertInto()', function() {
       q = new joli.query().insertInto('human').values({
         first_name: 'John',