尝试将 saveall() 放入两个具有多个条目的单独表中

Question

嘿大家。我似乎一辈子都无法让这个该死的 saveall() 函数发挥作用。我告诉过它很神奇，但我一定没有足够的纤原体或任何花哨的东西来让它闪闪发光。

所以我有四个不同的表——问题、评论、员工和答案。问题有多种答案，答案有一条评论。答案属于员工。以下是我的模型中的设置：

应答模型

var $hasOne = array(
    'Comment' => array(
        'className' => 'Comment',
        'foreignKey' => 'answer_id',
        'conditions' => '',
        'fields' => '',
        'order' => ''
    )
);

var $belongsTo = array(
    'Question' => array(
        'className' => 'Question',
        'foreignKey' => 'question_id',
        'conditions' => '',
        'fields' => '',
        'order' => ''
    ),
    'Employee' => array(
        'className' => 'Employee',
        'foreignKey' => 'employee_id',
        'conditions' => '',
        'fields' => '',
        'order' => ''
    )
);

评论模型

var $validate = array(
    'answer_id' => array(
        'numeric' => array(
            'rule' => array('numeric'),
        ),
    ),
);

var $belongsTo = array(
    'Answer' => array(
        'className' => 'Answer',
        'foreignKey' => 'answer_id',
        'conditions' => '',
        'fields' => '',
        'order' => ''
    )
);

当我为数据运行 saveall() 时，我收到一条错误消息我的评论的answer_id 不是数字。这是我的数据树的设置，就像我试图保存的那样（使用 $this->Answer->saveall($this->data);：

[Answer] => Array
        (
            [1] => Array
                (
                    [question_id] => 1
                    [employee_id] => 14
                    [result] => 7
                    [unique_hash] => t9279kn7vh
                )

            [3] => Array
                (
                    [question_id] => 3
                    [employee_id] => 14
                    [result] => 6
                    [unique_hash] => t9279kn7vh
                )

            [4] => Array
                (
                    [question_id] => 4
                    [employee_id] => 14
                    [result] => 3
                    [unique_hash] => t9279kn7vh
                )

            [5] => Array
                (
                    [question_id] => 5
                    [employee_id] => 14
                    [result] => 2
                    [unique_hash] => t9279kn7vh
                )

            [6] => Array
                (
                    [question_id] => 6
                    [employee_id] => 14
                    [result] => 7
                    [unique_hash] => t9279kn7vh
                )

        )

    [Comment] => Array
        (
            [1] => Array
                (
                    [user_id] => 14
                    [text] => test1
                )

            [3] => Array
                (
                    [user_id] => 14
                    [text] => test2
                )

            [4] => Array
                (
                    [user_id] => 14
                    [text] => test3
                )

            [5] => Array
                (
                    [user_id] => 14
                    [text] => test4
                )

            [6] => Array
                (
                    [user_id] => 14
                    [text] => test5
                )

        )

任何人都可以帮我弄清楚这里出了什么问题？我感谢您的帮助。

编辑：我已更新 $data 数组，使其键从零开始，增量为 1（即， array(0=>array(),1=>array(),2=>array()); 等) 这已经消除了验证错误，但数据仍然没有节省。

Answer 1

尝试这个：

$this->Answer->saveall($this->data['Answer']);
$this->Comment->saveall($this->data['Comment']);

由于某种原因，cakephp 有时不会自动保存相关表的所有记录，即使您定义了它们的关系。我仍在试图找出原因。

Answer 2

SaveAll 只是不保存其他相关表。我们完全按照您所说的去做，我们自己定义它们，我们甚至手动链接 id。虽然有点痛苦，但这是最好的选择。