kohana - 删除相关记录，有has_many关系

Question

我在两个表之间有 has_many 关系like : "questions"-< "options"[一个问题有很多选项]我的类(class)结构是:提问

class Model_Admin_sysQuestion extends ORM {

protected $_table_name = 'questions';

protected $_has_many = array(
    'options' => array(
        'model' => 'Admin_sysQuestionOption',
        'foreign_key' => 'question_id',
    ),
);... .

选项

Class Model_Admin_sysQuestionOption extends ORM {

protected $_table_name = 'questions_options';
protected $_belongs_to = array(
    'question' => array(
        'model' => 'Admin_sysSection',
        'foreign_key' => 'question_id',
    ),
); .... .

我正在尝试使用以下代码删除所有选项的问题:

 $question = ORM::factory('Admin_sysQuestion', 30);
        $question->options->delete($question->id);
        $question->delete();

但是报错

error":"Cannot delete admin_sysquestionoption model because it is not loaded."

有什么想法吗？怎么做？

Answer 1

加载多个关系时必须调用find_all:

foreach($question->options->find_all() as $option)
{
   $option->delete();
}

或者使用DB QBuilder进行多次删除:

DB::delete('questions_options')
    ->where('question_id', '=', 30)
    ->execute($this->_db);