diff options
author | Jamie Matthews <[email protected]> | 2010-11-03 23:09:28 +0000 |
---|---|---|
committer | Jamie Matthews <[email protected]> | 2010-11-03 23:09:28 +0000 |
commit | 9a639619d80c9b0d640a3a79fd8779a375c5b28b (patch) | |
tree | bb35f23ebe6d5d10112f8edecd502b718286a754 /test/test_queries.php | |
parent | da6d31366f809720d0cd411ddc02249c518ce9f5 (diff) |
Add where_null and where_not_null methods. Thanks for the suggestion, artcijsg
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 879a086..68223c6 100644 --- a/test/test_queries.php +++ b/test/test_queries.php @@ -96,6 +96,14 @@ $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_null('name')->find_many(); + $expected = "SELECT * FROM `widget` WHERE `name` IS NULL"; + Tester::check_equal("where_null method", $expected); + + ORM::for_table('widget')->where_not_null('name')->find_many(); + $expected = "SELECT * FROM `widget` WHERE `name` IS NOT NULL"; + Tester::check_equal("where_not_null method", $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); |