PHP CodeIgniter\Database BaseBuilder::setの例

コード例 #1

ファイル: UpdateTest.php プロジェクト: titounnes/CodeIgniter4

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