Beispiel #1
0
 public function testOrNotLike()
 {
     $builder = new BaseBuilder('job', $this->db);
     $builder->like('name', 'veloper')->orNotLike('name', 'ian');
     $expectedSQL = "SELECT * FROM \"job\" WHERE \"name\" LIKE :name ESCAPE '!' OR  \"name\" NOT LIKE :name0 ESCAPE '!'";
     $expectedBinds = ['name' => '%veloper%', 'name0' => '%ian%'];
     $this->assertEquals($expectedSQL, str_replace("\n", ' ', $builder->getCompiledSelect()));
     $this->assertSame($expectedBinds, $builder->getBinds());
 }