MDL-63724 messaging: Prefix field with the table alias
[moodle.git] / grade / tests / querylib_test.php
blob28e6cde2caac9ac0802b4207e3a1511c3a985833
1 <?php
2 // This file is part of Moodle - http://moodle.org/
3 //
4 // Moodle is free software: you can redistribute it and/or modify
5 // it under the terms of the GNU General Public License as published by
6 // the Free Software Foundation, either version 3 of the License, or
7 // (at your option) any later version.
8 //
9 // Moodle is distributed in the hope that it will be useful,
10 // but WITHOUT ANY WARRANTY; without even the implied warranty of
11 // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 // GNU General Public License for more details.
14 // You should have received a copy of the GNU General Public License
15 // along with Moodle. If not, see <http://www.gnu.org/licenses/>.
17 /**
18 * Unit tests for grade quering
20 * @package core_grades
21 * @category phpunit
22 * @copyright 2011 Petr Skoda {@link http://skodak.org}
23 * @license http://www.gnu.org/copyleft/gpl.html GNU Public License
26 defined('MOODLE_INTERNAL') || die();
28 global $CFG;
29 require_once($CFG->libdir.'/gradelib.php');
30 require_once($CFG->dirroot.'/grade/querylib.php');
33 class core_grade_querylib_testcase extends advanced_testcase {
35 public function test_grade_get_gradable_activities() {
36 $this->resetAfterTest(true);
38 $course = $this->getDataGenerator()->create_course();
39 $data1 = $this->getDataGenerator()->create_module('data', array('assessed'=>1, 'scale'=>100, 'course'=>$course->id));
40 $data2 = $this->getDataGenerator()->create_module('data', array('assessed'=>0, 'course'=>$course->id));
41 $forum1 = $this->getDataGenerator()->create_module('forum', array('assessed'=>1, 'scale'=>100, 'course'=>$course->id));
42 $forum2 = $this->getDataGenerator()->create_module('forum', array('assessed'=>0, 'course'=>$course->id));
44 $cms = grade_get_gradable_activities($course->id);
45 $this->assertEquals(2, count($cms));
46 $this->assertTrue(isset($cms[$data1->cmid]));
47 $this->assertTrue(isset($cms[$forum1->cmid]));
49 $cms = grade_get_gradable_activities($course->id, 'forum');
50 $this->assertEquals(1, count($cms));
51 $this->assertTrue(isset($cms[$forum1->cmid]));
54 public function test_grade_get_grade_items_for_activity() {
55 $this->resetAfterTest(true);
57 $course = $this->getDataGenerator()->create_course();
58 $forum = $this->getDataGenerator()->create_module('forum', array('course'=>$course->id));
59 $cm = get_coursemodule_from_id('forum', $forum->cmid, $forum->course);
60 unset($cm->modname);
61 $grade = grade_get_grade_items_for_activity($cm);