我做了一个有很多关联的大表格hasMany/HABTM。一切都在创造(!)。当更新所有工作也很好,但在关联是hasMany的表中,数据不会更新或替换,而只是插入。这将带来许多带有垃圾数据的行。我如何使saveAll()做更新/替换在hasMany字段:
模型:
class MainModel extends AppModel {
var $hasAndBelongsToMany = array(
'HABTMModel1',
...
'HABTMModeln',
);
var $hasMany = array(
'Model1' => array(
'dependent' => true
),
...
'Modeln' => array(
'dependent' => true
),
);
}
问题之一是许多模型看起来像:
class Model1 extends AppModel {
var $belongsTo = array(
'MainModel'
);
}
和他的表有:
id <- Primary key, auto increment, int (11)
main_model_id <- Foreign_key int (11)
name <- text field, string
$this->数据如下:
array(
[MainModel] => array(
'id' => 123
*** aditional data named identicaly to table fields (working great)***
),
[Model1] => array(
[0] => array(
[name] => Test1
),
[2] => array(
[name] => Test2
),
),
*** all other models ***
);
第一次创建和更新后的Model1表结果:
id main_model_id name
--------------------------------------------------------------
11 306 Test1
12 306 Test2
13 306 Test1 (Thease are dublicates)
14 306 Test2 (Thease are dublicates)
我能做些什么来更新/替换hasMany中的数据,而不是使用saveAll在编辑中插入新值?
谢谢。
在视图中,只需为所有Model1、Model2 id添加隐藏输入
echo $form->create('MainModel'); echo $form->hidden('Model1.0.id'); // more stuffs... echo $form->end('Save');
您可能指定Model1, Model2的'fields'只有'name'。这就是$this->data看起来像这样的原因。所以只要加上" id "
所以我做得不那么漂亮,但很好用:
// If edit, then delete data from hasMany tables based on main_model_id
if(isset($this->data['MainModel']['id']) && !empty($this->data['MainModel']['id'])) {
$conditions = array('main_model_id' => $this->data['MainModel']['id']);
// Delete Model1
$this->MainModel->Model1->deleteAll($conditions, false);
...
all other models
...
}
$this->MainModel->saveAll($this->data);
您需要为您的hasMany模型设置id
字段,例如
array(
[MainModel] => array(
[id] => 123
*** aditional data named identicaly to table fields (working great)*** ),
[Model1] => array(
[0] => array(
[id] => 1,
[name] => Test1
),
[2] => array(
[id] => 2
[name] => Test2
), ), *** all other models *** );