更新另一个表cakephp 3中的相关行

// src/Model/Table/TableAModel.php

namespace App\Model\Table;

use Cake\ORM\Table;

class TableAModel extends Table
{
    public function initialize(array $config)
    {
        $this->hasMany('TableB');
    }
}

// src/Controller/YourController.php

namespace App\Controller;

use App\Model\Table\TableAModel;
use Cake\Datasource\ConnectionManager;

class YourController extends AppController
{
    public function updateRelatedRows()
    {
        $tableA = new TableAModel();
        $connection = ConnectionManager::get('default');
        
        // 开始一个事务
        $connection->begin();
        
        try {
            // 获取TableA的记录
            $tableARecord = $tableA->get($tableAId, ['contain' => 'TableB']);
            
            // 更新TableB的相关行
            foreach ($tableARecord->table_b as $tableBRecord) {
                $tableBRecord->field = $newValue;
                $tableA->TableB->save($tableBRecord);
            }
            
            // 提交事务
            $connection->commit();
            
            $this->Flash->success('相关行更新成功！');
            return $this->redirect(['action' => 'index']);
        } catch (\Exception $e) {
            // 回滚事务
            $connection->rollback();
            
            $this->Flash->error('相关行更新失败！');
            return $this->redirect(['action' => 'index']);
        }
    }
}