Add where_null and where_not_null methods. Thanks for the suggestion, artcijsg

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);