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());
}
public function testUpdateWithSet()
{
$builder = new BaseBuilder('jobs', $this->db);
$builder->set('name', 'Programmer')->where('id', 1)->update(null, null, null, true);
$expectedSQL = "UPDATE \"jobs\" SET \"name\" = :name WHERE \"id\" = :id";
$expectedBinds = ['id' => 1, 'name' => 'Programmer'];
$this->assertEquals($expectedSQL, str_replace("\n", ' ', $builder->getCompiledUpdate()));
$this->assertEquals($expectedBinds, $builder->getBinds());
}
