search

easy-swoole / orm

31 stars 27 forks source link

How to WHERE ' IS NULL'. 'IS NOT NULL' ? #49

Closed AhmedAsser closed 4 years ago

xuanyanwow commented 4 years ago 

        $model7 = TestUserListModel::create();
        $test7 = $model7->where('name', null, 'is')->get();
        $this->assertEquals("SELECT  * FROM user_test_list WHERE  name is NULL LIMIT 1", $model7->lastQuery()->getLastQuery());
        $test7 = $model7->where('name', null, 'not')->get();
        $this->assertEquals("SELECT  * FROM user_test_list WHERE  name not NULL LIMIT 1", $model7->lastQuery()->getLastQuery());