diff options
author | Jamie Matthews <[email protected]> | 2011-01-22 11:22:43 +0000 |
---|---|---|
committer | Jamie Matthews <[email protected]> | 2011-01-22 11:22:43 +0000 |
commit | 46cad2491c4eadef1c4538b3a0afa9650a6e4c38 (patch) | |
tree | 7412aeff74b4d720bdab72cf8a4408104f0d8bbe /test/test_queries.php | |
parent | 8b92b3019821f5f619a95a0b58b62e3bb43dd455 (diff) |
Add support for GROUP BY - issue #13
Diffstat (limited to 'test/test_queries.php')
-rw-r--r-- | test/test_queries.php | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/test/test_queries.php b/test/test_queries.php index 2dca817..e227e27 100644 --- a/test/test_queries.php +++ b/test/test_queries.php @@ -84,6 +84,14 @@ $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); + + ORM::for_table('widget')->group_by('name')->group_by('age')->find_many(); + $expected = "SELECT * FROM `widget` GROUP BY `name`, `age`"; + Tester::check_equal("Multiple GROUP BY", $expected); + ORM::for_table('widget')->where('name', 'Fred')->limit(5)->offset(5)->order_by_asc('name')->find_many(); $expected = "SELECT * FROM `widget` WHERE `name` = 'Fred' ORDER BY `name` ASC LIMIT 5 OFFSET 5"; Tester::check_equal("Complex query", $expected); |