diff options
author | Jamie Matthews <[email protected]> | 2010-09-14 04:03:39 +0100 |
---|---|---|
committer | Jamie Matthews <[email protected]> | 2010-09-14 04:03:39 +0100 |
commit | 674d83234273ee9cf263c1278b96272a0f71e758 (patch) | |
tree | edb6c1f317879e970036793a316c32b6cb171596 /test/test_queries.php | |
parent | 80c5136a539050896aa2901abcd91766d622f1e6 (diff) |
Add code, tests and docs for inequality operators: where_gt, where_lt, where_gte, where_lte
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 7670df6..bc716d1 100644 --- a/test/test_queries.php +++ b/test/test_queries.php @@ -62,6 +62,14 @@ $expected = 'SELECT * FROM widget WHERE name = "Fred" ORDER BY name ASC LIMIT 5 OFFSET 5'; Tester::check_equal("Complex query", $expected); + ORM::for_table('widget')->where_lt('age', 10)->where_gt('age', 5)->find_many(); + $expected = 'SELECT * FROM widget WHERE age < "10" AND age > "5"'; + Tester::check_equal("Less than and greater than", $expected); + + ORM::for_table('widget')->where_lte('age', 10)->where_gte('age', 5)->find_many(); + $expected = 'SELECT * FROM widget WHERE age <= "10" AND age >= "5"'; + Tester::check_equal("Less than or equal and greater than or equal", $expected); + ORM::for_table('widget')->where_raw('name = ? AND (age = ? OR age = ?)', array('Fred', 5, 10))->find_many(); $expected = 'SELECT * FROM widget WHERE name = "Fred" AND (age = "5" OR age = "10")'; Tester::check_equal("Raw WHERE clause", $expected); |