在PHP 7.1 、Yii 2 中，AR 活动记录事务，需要同时操作多个模型的实现

Post Views: 140

1、在PHP 7.1 、Yii 2 中，AR 活动记录事务，需要同时操作多个模型的实现，如图1



	$transaction = $this->db->beginTransaction();
	try {
		if (!$this->save()) {
			throw new ServerErrorHttpException('Failed to create the object for unknown reason.');
		}

		/* 创建MySQL模型(内容详情) */
		$contentDetail = new ContentDetail();
		$contentDetail->tenantid = $this->tenantid;
		$contentDetail->content_audit_id = $this->id;
		$contentDetail->content = $this->content;
		if (!$contentDetail->save()) {
			throw new ServerErrorHttpException('Failed to create the object for unknown reason.');
		}
		$transaction->commit();
	} catch(\Throwable $e) {
		$transaction->rollBack();
		throw $e;
	}

2、测试事务是否支持，特意让$this->save()操作失败、让$contentDetail->save()操作成功，响应如下，如图2



{
    "name": "Database Exception",
    "message": "SQLSTATE[HY000]: General error: 1364 Field 'updated_at' doesn't have a default value\nThe SQL being executed was: INSERT INTO `ca_content_audit` (`code`, `data_source_detail_id`, `source`, `source_tenantid`, `data_source_code`, `content_type`, `logo`, `title`, `publish_date`, `tenantid`, `audit_process_id`, `step`, `uid`, `uid_all`, `audit_status`, `call_back`, `created_at`) VALUES ('shuangliu', '1', '双流', 'shuangliu', 'share', 1, 'logo', 'title', '2017-03-03 12:05:54', 'default', 1, 0, '', '', 2, '', '2018-03-07 13:38:29')",
    "code": 0,
    "type": "yii\\db\\Exception",
    "file": "E:\\wwwroot\\cmcp-api\\vendor\\yiisoft\\yii2\\db\\Schema.php",
    "line": 595,
    "stack-trace": [
        "#0 E:\\wwwroot\\cmcp-api\\vendor\\yiisoft\\yii2\\db\\Command.php(1004): yii\\db\\Schema->convertException(Object(PDOException), 'INSERT INTO `ca...')",
        "#1 E:\\wwwroot\\cmcp-api\\vendor\\yiisoft\\yii2\\db\\Schema.php(412): yii\\db\\Command->execute()",
        "#2 E:\\wwwroot\\cmcp-api\\vendor\\yiisoft\\yii2\\db\\ActiveRecord.php(511): yii\\db\\Schema->insert('{{%content_audi...', Array)",
        "#3 E:\\wwwroot\\cmcp-api\\vendor\\yiisoft\\yii2\\db\\ActiveRecord.php(477): yii\\db\\ActiveRecord->insertInternal(NULL)",
        "#4 E:\\wwwroot\\cmcp-api\\vendor\\yiisoft\\yii2\\db\\BaseActiveRecord.php(646): yii\\db\\ActiveRecord->insert(true, NULL)",
        "#5 E:\\wwwroot\\cmcp-api\\api\\models\\ContentAudit.php(121): yii\\db\\BaseActiveRecord->save()",
        "#6 E:\\wwwroot\\cmcp-api\\api\\rests\\content_audit\\CreateAction.php(55): api\\models\\ContentAudit->create()",
        "#7 [internal function]: api\\rests\\content_audit\\CreateAction->run()",
        "#8 E:\\wwwroot\\cmcp-api\\vendor\\yiisoft\\yii2\\base\\Action.php(94): call_user_func_array(Array, Array)",
        "#9 E:\\wwwroot\\cmcp-api\\vendor\\yiisoft\\yii2\\base\\Controller.php(157): yii\\base\\Action->runWithParams(Array)",
        "#10 E:\\wwwroot\\cmcp-api\\vendor\\yiisoft\\yii2\\base\\Module.php(528): yii\\base\\Controller->runAction('create', Array)",
        "#11 E:\\wwwroot\\cmcp-api\\vendor\\yiisoft\\yii2\\web\\Application.php(103): yii\\base\\Module->runAction('v1/content-audi...', Array)",
        "#12 E:\\wwwroot\\cmcp-api\\vendor\\yiisoft\\yii2\\base\\Application.php(386): yii\\web\\Application->handleRequest(Object(yii\\web\\Request))",
        "#13 E:\\wwwroot\\cmcp-api\\api\\web\\index.php(23): yii\\base\\Application->run()",
        "#14 {main}"
    ],
    "error-info": [
        "HY000",
        1364,
        "Field 'updated_at' doesn't have a default value"
    ],
    "previous": {
        "name": "Exception",
        "message": "SQLSTATE[HY000]: General error: 1364 Field 'updated_at' doesn't have a default value",
        "code": "HY000",
        "type": "PDOException",
        "file": "E:\\wwwroot\\cmcp-api\\vendor\\yiisoft\\yii2\\db\\Command.php",
        "line": 994,
        "stack-trace": [
            "#0 E:\\wwwroot\\cmcp-api\\vendor\\yiisoft\\yii2\\db\\Command.php(994): PDOStatement->execute()",
            "#1 E:\\wwwroot\\cmcp-api\\vendor\\yiisoft\\yii2\\db\\Schema.php(412): yii\\db\\Command->execute()",
            "#2 E:\\wwwroot\\cmcp-api\\vendor\\yiisoft\\yii2\\db\\ActiveRecord.php(511): yii\\db\\Schema->insert('{{%content_audi...', Array)",
            "#3 E:\\wwwroot\\cmcp-api\\vendor\\yiisoft\\yii2\\db\\ActiveRecord.php(477): yii\\db\\ActiveRecord->insertInternal(NULL)",
            "#4 E:\\wwwroot\\cmcp-api\\vendor\\yiisoft\\yii2\\db\\BaseActiveRecord.php(646): yii\\db\\ActiveRecord->insert(true, NULL)",
            "#5 E:\\wwwroot\\cmcp-api\\api\\models\\ContentAudit.php(121): yii\\db\\BaseActiveRecord->save()",
            "#6 E:\\wwwroot\\cmcp-api\\api\\rests\\content_audit\\CreateAction.php(55): api\\models\\ContentAudit->create()",
            "#7 [internal function]: api\\rests\\content_audit\\CreateAction->run()",
            "#8 E:\\wwwroot\\cmcp-api\\vendor\\yiisoft\\yii2\\base\\Action.php(94): call_user_func_array(Array, Array)",
            "#9 E:\\wwwroot\\cmcp-api\\vendor\\yiisoft\\yii2\\base\\Controller.php(157): yii\\base\\Action->runWithParams(Array)",
            "#10 E:\\wwwroot\\cmcp-api\\vendor\\yiisoft\\yii2\\base\\Module.php(528): yii\\base\\Controller->runAction('create', Array)",
            "#11 E:\\wwwroot\\cmcp-api\\vendor\\yiisoft\\yii2\\web\\Application.php(103): yii\\base\\Module->runAction('v1/content-audi...', Array)",
            "#12 E:\\wwwroot\\cmcp-api\\vendor\\yiisoft\\yii2\\base\\Application.php(386): yii\\web\\Application->handleRequest(Object(yii\\web\\Request))",
            "#13 E:\\wwwroot\\cmcp-api\\api\\web\\index.php(23): yii\\base\\Application->run()",
            "#14 {main}"
        ]
    }
}

3、查看数据库，此时$this、$contentDetail皆未执行成功，如图3

4、测试事务是否支持，特意让$this->save()操作成功、让$contentDetail->save()操作失败，响应如下，如图4



{
    "name": "Internal Server Error",
    "message": "Failed to create the object for unknown reason.",
    "code": 0,
    "status": 500,
    "type": "yii\\web\\ServerErrorHttpException"
}

5、查看数据库，此时$this、$contentDetail皆未执行成功，如图5

6、测试事务是否支持，特意让$this->save()操作成功、让$contentDetail->save()操作成功，响应如下，如图6

7、查看数据库，此时$this、$contentDetail皆执行成功，如图7

8、可以继续新增模型



	$transaction = $this->db->beginTransaction();
	try {
		if (!$this->save()) {
			throw new ServerErrorHttpException(Yii::t('error', '20032'), 20032);
		}

		/* 创建MySQL模型(内容详情) */
		$contentDetail = new ContentDetail();
		$contentDetail->tenantid = $this->tenantid;
		$contentDetail->content_audit_id = $this->id;
		$contentDetail->content = $this->content;
		if (!$contentDetail->save()) {
			throw new ServerErrorHttpException(Yii::t('error', '20033'), 20033);
		}

		/* 创建MySQL模型(审核记录) */
		$auditLog = new AuditLog();
		$auditLog->tenantid = $this->tenantid;
		$auditLog->content_audit_id = $this->id;
		$auditLog->step = self::AUDIT_PROCESS_STEP_AIR;
		$auditLog->operation_user = '';
		$auditLog->operation_user_id = 0;
		$auditLog->cause = '';
		$auditLog->status = self::STATUS_ACTIVE;
		$auditLog->created_at = $time;
		if (!$auditLog->save()) {
			throw new ServerErrorHttpException(Yii::t('error', '20034'), 20034);
		}

		$transaction->commit();
	} catch(\Throwable $e) {
		$transaction->rollBack();
		throw $e;
	}

PHP / Laravel / Yii2 老项目维护与长期技术支持

如果你的 PHP / Laravel / Yii2 项目已经上线，但遇到原开发离职、Bug 长期无人修复、接口不稳定、性能下降、代码难以接手等问题，可以联系我做一次远程技术排查。

适合以下情况：
✅ 老旧 PHP 系统无人维护
✅ Laravel / Yii2 项目 Bug 修复
✅ 后台管理系统小功能迭代
✅ RESTful API 接口排查
✅ MySQL / Redis / Nginx 性能问题
✅ 长期远程兼职维护

可先从一次小问题开始：
✅ 线上报错排查
✅ 接口异常分析
✅ 慢查询与性能瓶颈定位
✅ 代码结构初步评估
✅ 部署环境与日志检查

如需咨询，请联系我，并注明：PHP 维护咨询。

联系方式：
Telegram：@shuijingwan
微信：13980074657
邮箱：shuijingwanwq@gmail.com

在PHP 7.1 、Yii 2 中，AR 活动记录事务，需要同时操作多个模型的实现

评论

发表回复 取消回复

更多文章

又一次 Web3 远程招聘面试：这次我在陌生会议平台前停了下来，避免重蹈木马事件的覆辙

WordPress 服务器 CPU 再次满载：从 Nginx 499、PHP-FPM、Redis 到 W3TC 冷缓存的完整排查

Cloudflare 526 排查实录：acme.sh 的 RSA / ECC 双证书自动续期，如何把英文站 SSL 覆盖坏了

Ubuntu 26.04 双屏突然黑屏排查：ThinkPad T570 从 i915、GNOME 到 HDMI→VGA 转换链路的实践

发表回复取消回复