summaryrefslogtreecommitdiff
path: root/test/test_queries.php
diff options
context:
space:
mode:
authorSimon Holywell <[email protected]>2013-01-18 17:27:53 +0000
committerSimon Holywell <[email protected]>2013-01-18 17:27:53 +0000
commit5b11534bd506974d2377b80e24891b248eea319b (patch)
tree46cf7f2bbfcf145f125f8eb13e8a55b9c7df6701 /test/test_queries.php
parentdee4dd8166d47c69fe982b701cee40c44f9aabea (diff)
Add more tests to suite
Diffstat (limited to 'test/test_queries.php')
-rwxr-xr-xtest/test_queries.php4
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);