diff options
author | Simon Holywell <[email protected]> | 2013-01-18 17:27:53 +0000 |
---|---|---|
committer | Simon Holywell <[email protected]> | 2013-01-18 17:27:53 +0000 |
commit | 5b11534bd506974d2377b80e24891b248eea319b (patch) | |
tree | 46cf7f2bbfcf145f125f8eb13e8a55b9c7df6701 /test/test_queries.php | |
parent | dee4dd8166d47c69fe982b701cee40c44f9aabea (diff) |
Add more tests to suite
Diffstat (limited to 'test/test_queries.php')
-rwxr-xr-x | test/test_queries.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/test/test_queries.php b/test/test_queries.php index c9f5c84..db78ffe 100755 --- a/test/test_queries.php +++ b/test/test_queries.php @@ -104,8 +104,6 @@ $expected = "SELECT * FROM `widget` ORDER BY `name` ASC, `age` DESC LIMIT 1"; Tester::check_equal("Multiple ORDER BY", $expected); - /////////////////////////////////////////// - ORM::for_table('widget')->group_by('name')->find_many(); $expected = "SELECT * FROM `widget` GROUP BY `name`"; Tester::check_equal("GROUP BY", $expected); @@ -150,6 +148,8 @@ $expected = "SELECT * FROM `widget` GROUP BY `name` HAVING `age` < '10' AND `age` > '5'"; Tester::check_equal("HAVING less than and greater than", $expected); + /////////////////////////////////////////// + ORM::for_table('widget')->group_by('name')->having_lte('age', 10)->having_gte('age', 5)->find_many(); $expected = "SELECT * FROM `widget` GROUP BY `name` HAVING `age` <= '10' AND `age` >= '5'"; Tester::check_equal("HAVING less than or equal and greater than or equal", $expected); |