コード例 #1
0
ファイル: LikeTest.php プロジェクト: titounnes/CodeIgniter4
 public function testNotLike()
 {
     $builder = new BaseBuilder('job', $this->db);
     $builder->notLike('name', 'veloper');
     $expectedSQL = "SELECT * FROM \"job\" WHERE \"name\" NOT LIKE :name ESCAPE '!'";
     $expectedBinds = ['name' => '%veloper%'];
     $this->assertEquals($expectedSQL, str_replace("\n", ' ', $builder->getCompiledSelect()));
     $this->assertSame($expectedBinds, $builder->getBinds());
 }