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