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

xavierlacot · Jul 11, 2012 · 17a07b5 · 17a07b5
1 parent 96403d1
commit 17a07b5
Show file tree

Hide file tree

Showing 2 changed files with 4 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
@@ -32,6 +32,9 @@
     });
 
     it('joli.query.having()', function() {
+      q = new joli.query().select('count(human.id) as nb_humans').from('human').where('first_name = ?', 'michel').groupBy('city_id').having('nb_humans > ?', 1);
+      expect(q.getQuery()).toBe('select count(human.id) as nb_humans from human where first_name="michel" group by city_id having nb_humans > "1"');
+
       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"');
     });