PHP question_remove_stale_questions_from_category Examples

Example #1

File: questionlib_test.php Project: evltuma/moodle

 public function test_question_remove_stale_questions_from_category()
 {
     global $DB;
     $this->resetAfterTest(true);
     $dg = $this->getDataGenerator();
     $course = $dg->create_course();
     $quiz = $dg->create_module('quiz', ['course' => $course->id]);
     $qgen = $dg->get_plugin_generator('core_question');
     $context = context_system::instance();
     $qcat1 = $qgen->create_question_category(['contextid' => $context->id]);
     $q1a = $qgen->create_question('shortanswer', null, ['category' => $qcat1->id]);
     // Will be hidden.
     $q1b = $qgen->create_question('random', null, ['category' => $qcat1->id]);
     // Will not be used.
     $DB->set_field('question', 'hidden', 1, ['id' => $q1a->id]);
     $qcat2 = $qgen->create_question_category(['contextid' => $context->id]);
     $q2a = $qgen->create_question('shortanswer', null, ['category' => $qcat2->id]);
     // Will be hidden.
     $q2b = $qgen->create_question('shortanswer', null, ['category' => $qcat2->id]);
     // Will be hidden but used.
     $q2c = $qgen->create_question('random', null, ['category' => $qcat2->id]);
     // Will not be used.
     $q2d = $qgen->create_question('random', null, ['category' => $qcat2->id]);
     // Will be used.
     $DB->set_field('question', 'hidden', 1, ['id' => $q2a->id]);
     $DB->set_field('question', 'hidden', 1, ['id' => $q2b->id]);
     quiz_add_quiz_question($q2b->id, $quiz);
     quiz_add_quiz_question($q2d->id, $quiz);
     $this->assertEquals(2, $DB->count_records('question', ['category' => $qcat1->id]));
     $this->assertEquals(4, $DB->count_records('question', ['category' => $qcat2->id]));
     // Non-existing category, nothing will happen.
     question_remove_stale_questions_from_category(0);
     $this->assertEquals(2, $DB->count_records('question', ['category' => $qcat1->id]));
     $this->assertEquals(4, $DB->count_records('question', ['category' => $qcat2->id]));
     // First category, should be empty afterwards.
     question_remove_stale_questions_from_category($qcat1->id);
     $this->assertEquals(0, $DB->count_records('question', ['category' => $qcat1->id]));
     $this->assertEquals(4, $DB->count_records('question', ['category' => $qcat2->id]));
     $this->assertFalse($DB->record_exists('question', ['id' => $q1a->id]));
     $this->assertFalse($DB->record_exists('question', ['id' => $q1b->id]));
     // Second category, used questions should be left untouched.
     question_remove_stale_questions_from_category($qcat2->id);
     $this->assertEquals(0, $DB->count_records('question', ['category' => $qcat1->id]));
     $this->assertEquals(2, $DB->count_records('question', ['category' => $qcat2->id]));
     $this->assertFalse($DB->record_exists('question', ['id' => $q2a->id]));
     $this->assertTrue($DB->record_exists('question', ['id' => $q2b->id]));
     $this->assertFalse($DB->record_exists('question', ['id' => $q2c->id]));
     $this->assertTrue($DB->record_exists('question', ['id' => $q2d->id]));
 }

Example #2

File: category.php Project: evltuma/moodle

if ($param->moveupcontext || $param->movedowncontext) {
    require_sesskey();
    if ($param->moveupcontext) {
        $catid = $param->moveupcontext;
    } else {
        $catid = $param->movedowncontext;
    }
    $oldcat = $DB->get_record('question_categories', array('id' => $catid), '*', MUST_EXIST);
    $qcobject->update_category($catid, '0,' . $param->tocontext, $oldcat->name, $oldcat->info);
    // The previous line does a redirect().
}
if ($param->delete) {
    if (!($category = $DB->get_record("question_categories", array("id" => $param->delete)))) {
        print_error('nocate', 'question', $thispageurl->out(), $param->delete);
    }
    question_remove_stale_questions_from_category($param->delete);
    $questionstomove = $DB->count_records("question", array("category" => $param->delete));
    // Second pass, if we still have questions to move, setup the form.
    if ($questionstomove) {
        $categorycontext = context::instance_by_id($category->contextid);
        $qcobject->moveform = new question_move_form($thispageurl, array('contexts' => array($categorycontext), 'currentcat' => $param->delete));
        if ($qcobject->moveform->is_cancelled()) {
            redirect($thispageurl);
        } else {
            if ($formdata = $qcobject->moveform->get_data()) {
                list($tocategoryid, $tocontextid) = explode(',', $formdata->category);
                $qcobject->move_questions_and_delete_category($formdata->delete, $tocategoryid);
                $thispageurl->remove_params('cat', 'category');
                redirect($thispageurl);
            }
        }