CakePHP保存三模型关系关联

发布于 2024-10-30 20:01:38 字数 787 浏览 4 评论 0原文

我有以下输出，需要将其插入数据库中：

Array
(
[Test] => Array
    (
    )

[Question] => Array
    (
        [0] => Array
            (
                [category_id] => 3
                [answer_style_id] => 2
                [Answer] => Array
                    (
                        [0] => Array
                            (
                                [capital_category_id] => 14
                                [correct] => 1
                            )

                       ...
         ...

简而言之，每个测试都有许多问题，每个问题都有许多答案，每个关联的模型都有一个需要由 Cake 设置的外键（每个问题都有一个 test_id，每个答案都有一个 Question_id）。

问题是，当我 $this->Test->saveAll($data); 时，仅保存测试和问题，而不保存答案。

如何保存所有数据，并让 Cake 自动为每个关联模型设置外键？

谢谢你！

原文

I have the following output which I need to be inserted in the database:

Array
(
[Test] => Array
    (
    )

[Question] => Array
    (
        [0] => Array
            (
                [category_id] => 3
                [answer_style_id] => 2
                [Answer] => Array
                    (
                        [0] => Array
                            (
                                [capital_category_id] => 14
                                [correct] => 1
                            )

                       ...
         ...

Briefly, each Test hasMany Questions, and each Question hasMany Answer, with each associated model having a foreign key which need to be set by Cake (each Question has a test_id, and each Answer has a question_id).

The problem is that when I $this->Test->saveAll($data);, only the Test and the Questions get saved, not the answers.

How can I save all data, with Cake automagically setting the foreign key for each associated model?

Thank you!

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

素罗衫 2024-11-06 20:01:38

我不确定，但我认为不可能保存第三层关系。

来自 Cakephp：

使用saveAll()保存相关数据
仅适用于直接关联的
模型。

您必须检索第三级数据并将其与它们分开保存。

回复收藏 0 原文

无所的.畏惧 2024-11-06 20:01:38

是的，从 CakePHP 2.1 开始，您可以通过这种方式保存深层模型树

$this->SomeModel->saveAll($data, array('deep' => true));

参考此处> http://book.cakephp.org/2.0/en/appendices/new-features-in-cakephp-2-1.html#model-saveall-model-save Associated-model-validate Associate

Yes, you can save deep model trees since CakePHP 2.1 this way

$this->SomeModel->saveAll($data, array('deep' => true));

Reference here > http://book.cakephp.org/2.0/en/appendices/new-features-in-cakephp-2-1.html#model-saveall-model-saveassociated-model-validateassociated

回复收藏 0 原文

木落 2024-11-06 20:01:38

我有三个模型 A、B 和 C

A 有很多 B
B hasMany C

$A->saveAll() 将保存模型 A & B 但不是 C

这是我使用的一个解决方法：

在模型 B 中重写 afterSave 像这样

function afterSave($created) {
    if ($created) { // check if we are in save not update
        $this->data['B']['id'] = $this->id;
        $this->data['C'] = $this->data['B']['C'];
        $this->saveAll($this->data);
    }
}

I have three models A, B and C

A hasMany B
B hasMany C

$A->saveAll() will save model A & B but not C

Here is a playaround I use:

in model B override afterSave like this

function afterSave($created) {
    if ($created) { // check if we are in save not update
        $this->data['B']['id'] = $this->id;
        $this->data['C'] = $this->data['B']['C'];
        $this->saveAll($this->data);
    }
}

回复收藏 0 原文

~没有更多了~