From 674d83234273ee9cf263c1278b96272a0f71e758 Mon Sep 17 00:00:00 2001 From: Jamie Matthews Date: Tue, 14 Sep 2010 04:03:39 +0100 Subject: Add code, tests and docs for inequality operators: where_gt, where_lt, where_gte, where_lte --- test/test_queries.php | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'test') 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); -- cgit v1.2.3