enrol/database/tests/sync_test.php

   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.
  13 //
  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/>.
  16
  17 /**
  18  * External database enrolment sync tests, this also tests adodb drivers
  19  * that are matching our four supported Moodle database drivers.
  20  *
  21  * @package    enrol_database
  22  * @category   phpunit
  23  * @copyright  2011 Petr Skoda {@link http://skodak.org}
  24  * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
  25  */
  26
  27 defined('MOODLE_INTERNAL') || die();
  28
  29 class enrol_database_testcase extends advanced_testcase {
  30     protected static $courses = array();
  31     protected static $users = array();
  32     protected static $roles = array();
  33
  34     /** @var string Original error log */
  35     protected $oldlog;
  36
  37     protected function init_enrol_database() {
  38         global $DB, $CFG;
  39
  40         // Discard error logs from AdoDB.
  41         $this->oldlog = ini_get('error_log');
  42         ini_set('error_log', "$CFG->dataroot/testlog.log");
  43
  44         $dbman = $DB->get_manager();
  45
  46         set_config('dbencoding', 'utf-8', 'enrol_database');
  47
  48         set_config('dbhost', $CFG->dbhost, 'enrol_database');
  49         set_config('dbuser', $CFG->dbuser, 'enrol_database');
  50         set_config('dbpass', $CFG->dbpass, 'enrol_database');
  51         set_config('dbname', $CFG->dbname, 'enrol_database');
  52
  53         if (!empty($CFG->dboptions['dbport'])) {
  54             set_config('dbhost', $CFG->dbhost.':'.$CFG->dboptions['dbport'], 'enrol_database');
  55         }
  56
  57         switch ($DB->get_dbfamily()) {
  58
  59             case 'mysql':
  60                 set_config('dbtype', 'mysqli', 'enrol_database');
  61                 set_config('dbsetupsql', "SET NAMES 'UTF-8'", 'enrol_database');
  62                 set_config('dbsybasequoting', '0', 'enrol_database');
  63                 if (!empty($CFG->dboptions['dbsocket'])) {
  64                     $dbsocket = $CFG->dboptions['dbsocket'];
  65                     if ((strpos($dbsocket, '/') === false and strpos($dbsocket, '\\') === false)) {
  66                         $dbsocket = ini_get('mysqli.default_socket');
  67                     }
  68                     set_config('dbtype', 'mysqli://'.rawurlencode($CFG->dbuser).':'.rawurlencode($CFG->dbpass).'@'.rawurlencode($CFG->dbhost).'/'.rawurlencode($CFG->dbname).'?socket='.rawurlencode($dbsocket), 'enrol_database');
  69                 }
  70                 break;
  71
  72             case 'oracle':
  73                 set_config('dbtype', 'oci8po', 'enrol_database');
  74                 set_config('dbsybasequoting', '1', 'enrol_database');
  75                 break;
  76
  77             case 'postgres':
  78                 set_config('dbtype', 'postgres7', 'enrol_database');
  79                 $setupsql = "SET NAMES 'UTF-8'";
  80                 if (!empty($CFG->dboptions['dbschema'])) {
  81                     $setupsql .= "; SET search_path = '".$CFG->dboptions['dbschema']."'";
  82                 }
  83                 set_config('dbsetupsql', $setupsql, 'enrol_database');
  84                 set_config('dbsybasequoting', '0', 'enrol_database');
  85                 if (!empty($CFG->dboptions['dbsocket']) and ($CFG->dbhost === 'localhost' or $CFG->dbhost === '127.0.0.1')) {
  86                     if (strpos($CFG->dboptions['dbsocket'], '/') !== false) {
  87                         $socket = $CFG->dboptions['dbsocket'];
  88                         if (!empty($CFG->dboptions['dbport'])) {
  89                             $socket .= ':' . $CFG->dboptions['dbport'];
  90                         }
  91                         set_config('dbhost', $socket, 'enrol_database');
  92                     } else {
  93                       set_config('dbhost', '', 'enrol_database');
  94                     }
  95                 }
  96                 break;
  97
  98             case 'mssql':
  99                 if (get_class($DB) == 'mssql_native_moodle_database') {
 100                     set_config('dbtype', 'mssql_n', 'enrol_database');
 101                 } else {
 102                     set_config('dbtype', 'mssqlnative', 'enrol_database');
 103                 }
 104                 set_config('dbsybasequoting', '1', 'enrol_database');
 105                 break;
 106
 107             default:
 108                 throw new exception('Unknown database driver '.get_class($DB));
 109         }
 110
 111         // NOTE: It is stongly discouraged to create new tables in advanced_testcase classes,
 112         //       but there is no other simple way to test ext database enrol sync, so let's
 113         //       disable transactions are try to cleanup after the tests.
 114
 115         $table = new xmldb_table('enrol_database_test_enrols');
 116         $table->add_field('id', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, XMLDB_SEQUENCE, null);
 117         $table->add_field('courseid', XMLDB_TYPE_CHAR, '255', null, null, null);
 118         $table->add_field('userid', XMLDB_TYPE_CHAR, '255', null, null, null);
 119         $table->add_field('roleid', XMLDB_TYPE_CHAR, '255', null, null, null);
 120         $table->add_field('otheruser', XMLDB_TYPE_CHAR, '1', null, XMLDB_NOTNULL, null, '0');
 121         $table->add_key('primary', XMLDB_KEY_PRIMARY, array('id'));
 122         if ($dbman->table_exists($table)) {
 123             $dbman->drop_table($table);
 124         }
 125         $dbman->create_table($table);
 126         set_config('remoteenroltable', $CFG->prefix.'enrol_database_test_enrols', 'enrol_database');
 127         set_config('remotecoursefield', 'courseid', 'enrol_database');
 128         set_config('remoteuserfield', 'userid', 'enrol_database');
 129         set_config('remoterolefield', 'roleid', 'enrol_database');
 130         set_config('remoteotheruserfield', 'otheruser', 'enrol_database');
 131
 132         $table = new xmldb_table('enrol_database_test_courses');
 133         $table->add_field('id', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, XMLDB_SEQUENCE, null);
 134         $table->add_field('fullname', XMLDB_TYPE_CHAR, '255', null, null, null);
 135         $table->add_field('shortname', XMLDB_TYPE_CHAR, '255', null, null, null);
 136         $table->add_field('idnumber', XMLDB_TYPE_CHAR, '255', null, null, null);
 137         $table->add_field('category', XMLDB_TYPE_CHAR, '255', null, null, null);
 138         $table->add_key('primary', XMLDB_KEY_PRIMARY, array('id'));
 139         if ($dbman->table_exists($table)) {
 140             $dbman->drop_table($table);
 141         }
 142         $dbman->create_table($table);
 143         set_config('newcoursetable', $CFG->prefix.'enrol_database_test_courses', 'enrol_database');
 144         set_config('newcoursefullname', 'fullname', 'enrol_database');
 145         set_config('newcourseshortname', 'shortname', 'enrol_database');
 146         set_config('newcourseidnumber', 'idnumber', 'enrol_database');
 147         set_config('newcoursecategory', 'category', 'enrol_database');
 148
 149         // Create some test users and courses.
 150         for ($i = 1; $i <= 4; $i++) {
 151             self::$courses[$i] = $this->getDataGenerator()->create_course(array('fullname' => 'Test course '.$i, 'shortname' => 'tc'.$i, 'idnumber' => 'courseid'.$i));
 152         }
 153
 154         for ($i = 1; $i <= 10; $i++) {
 155             self::$users[$i] = $this->getDataGenerator()->create_user(array('username' => 'username'.$i, 'idnumber' => 'userid'.$i, 'email' => 'user'.$i.'@example.com'));
 156         }
 157
 158         foreach (get_all_roles() as $role) {
 159             self::$roles[$role->shortname] = $role;
 160         }
 161     }
 162
 163     protected function cleanup_enrol_database() {
 164         global $DB;
 165
 166         $dbman = $DB->get_manager();
 167         $table = new xmldb_table('enrol_database_test_enrols');
 168         $dbman->drop_table($table);
 169         $table = new xmldb_table('enrol_database_test_courses');
 170         $dbman->drop_table($table);
 171
 172         self::$courses = null;
 173         self::$users = null;
 174         self::$roles = null;
 175
 176         ini_set('error_log', $this->oldlog);
 177     }
 178
 179     protected function reset_enrol_database() {
 180         global $DB;
 181
 182         $DB->delete_records('enrol_database_test_enrols', array());
 183         $DB->delete_records('enrol_database_test_courses', array());
 184
 185         $plugin = enrol_get_plugin('database');
 186         $instances = $DB->get_records('enrol', array('enrol' => 'database'));
 187         foreach($instances as $instance) {
 188             $plugin->delete_instance($instance);
 189         }
 190     }
 191
 192     protected function assertIsEnrolled($userindex, $courseindex, $status=null, $rolename = null) {
 193         global $DB;
 194         $dbinstance = $DB->get_record('enrol', array('courseid' => self::$courses[$courseindex]->id, 'enrol' => 'database'), '*', MUST_EXIST);
 195
 196         $conditions = array('enrolid' => $dbinstance->id, 'userid' => self::$users[$userindex]->id);
 197         if ($status !== null) {
 198             $conditions['status'] = $status;
 199         }
 200         $this->assertTrue($DB->record_exists('user_enrolments', $conditions));
 201
 202         $this->assertHasRoleAssignment($userindex, $courseindex, $rolename);
 203     }
 204
 205     protected function assertHasRoleAssignment($userindex, $courseindex, $rolename = null) {
 206         global $DB;
 207         $dbinstance = $DB->get_record('enrol', array('courseid' => self::$courses[$courseindex]->id, 'enrol' => 'database'), '*', MUST_EXIST);
 208
 209         $coursecontext = context_course::instance(self::$courses[$courseindex]->id);
 210         if ($rolename === false) {
 211             $this->assertFalse($DB->record_exists('role_assignments', array('component' => 'enrol_database', 'itemid' => $dbinstance->id, 'userid' => self::$users[$userindex]->id, 'contextid' => $coursecontext->id)));
 212         } else if ($rolename !== null) {
 213             $this->assertTrue($DB->record_exists('role_assignments', array('component' => 'enrol_database', 'itemid' => $dbinstance->id, 'userid' => self::$users[$userindex]->id, 'contextid' => $coursecontext->id, 'roleid' => self::$roles[$rolename]->id)));
 214         }
 215     }
 216
 217     protected function assertIsNotEnrolled($userindex, $courseindex) {
 218         global $DB;
 219         if (!$dbinstance = $DB->get_record('enrol', array('courseid' => self::$courses[$courseindex]->id, 'enrol' => 'database'))) {
 220             return;
 221         }
 222         $this->assertFalse($DB->record_exists('user_enrolments', array('enrolid' => $dbinstance->id, 'userid' => self::$users[$userindex]->id)));
 223     }
 224
 225     public function test_sync_user_enrolments() {
 226         global $DB;
 227
 228         $this->init_enrol_database();
 229
 230         $this->resetAfterTest(false);
 231         $this->preventResetByRollback();
 232
 233         $plugin = enrol_get_plugin('database');
 234
 235         // Test basic enrol sync for one user after login.
 236
 237         $this->reset_enrol_database();
 238         $plugin->set_config('localcoursefield', 'idnumber');
 239         $plugin->set_config('localuserfield', 'idnumber');
 240         $plugin->set_config('localrolefield', 'shortname');
 241
 242         $plugin->set_config('defaultrole', self::$roles['student']->id);
 243
 244         $DB->insert_record('enrol_database_test_enrols', array('userid' => 'userid1', 'courseid' => 'courseid1', 'roleid' => 'student'));
 245         $DB->insert_record('enrol_database_test_enrols', array('userid' => 'userid1', 'courseid' => 'courseid2', 'roleid' => 'teacher'));
 246         $DB->insert_record('enrol_database_test_enrols', array('userid' => 'userid2', 'courseid' => 'courseid1', 'roleid' => null));
 247         $DB->insert_record('enrol_database_test_enrols', array('userid' => 'userid4', 'courseid' => 'courseid4', 'roleid' => 'editingteacher', 'otheruser' => '1'));
 248         $DB->insert_record('enrol_database_test_enrols', array('userid' => 'xxxxxxx', 'courseid' => 'courseid1', 'roleid' => 'student')); // Bogus record to be ignored.
 249         $DB->insert_record('enrol_database_test_enrols', array('userid' => 'userid1', 'courseid' => 'xxxxxxxxx', 'roleid' => 'student')); // Bogus record to be ignored.
 250
 251         $this->assertEquals(0, $DB->count_records('user_enrolments', array()));
 252         $this->assertEquals(0, $DB->count_records('enrol', array('enrol' => 'database')));
 253         $this->assertEquals(0, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 254
 255         $plugin->sync_user_enrolments(self::$users[1]);
 256         $this->assertEquals(2, $DB->count_records('user_enrolments', array()));
 257         $this->assertEquals(2, $DB->count_records('enrol', array('enrol' => 'database')));
 258         $this->assertEquals(2, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 259         $this->assertIsEnrolled(1, 1, ENROL_USER_ACTIVE, 'student');
 260         $this->assertIsEnrolled(1, 2, ENROL_USER_ACTIVE, 'teacher');
 261
 262         // Make sure there are no errors or changes on the next login.
 263
 264         $plugin->sync_user_enrolments(self::$users[1]);
 265         $this->assertEquals(2, $DB->count_records('user_enrolments', array()));
 266         $this->assertEquals(2, $DB->count_records('enrol', array('enrol' => 'database')));
 267         $this->assertEquals(2, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 268         $this->assertIsEnrolled(1, 1, ENROL_USER_ACTIVE, 'student');
 269         $this->assertIsEnrolled(1, 2, ENROL_USER_ACTIVE, 'teacher');
 270
 271         $plugin->sync_user_enrolments(self::$users[2]);
 272         $this->assertEquals(3, $DB->count_records('user_enrolments', array()));
 273         $this->assertEquals(2, $DB->count_records('enrol', array('enrol' => 'database')));
 274         $this->assertEquals(3, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 275         $this->assertIsEnrolled(1, 1, ENROL_USER_ACTIVE, 'student');
 276         $this->assertIsEnrolled(1, 2, ENROL_USER_ACTIVE, 'teacher');
 277         $this->assertIsEnrolled(2, 1, ENROL_USER_ACTIVE, 'student');
 278
 279         $plugin->sync_user_enrolments(self::$users[4]);
 280         $this->assertEquals(3, $DB->count_records('user_enrolments', array()));
 281         $this->assertEquals(3, $DB->count_records('enrol', array('enrol' => 'database')));
 282         $this->assertEquals(4, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 283         $this->assertIsEnrolled(1, 1, ENROL_USER_ACTIVE, 'student');
 284         $this->assertIsEnrolled(1, 2, ENROL_USER_ACTIVE, 'teacher');
 285         $this->assertIsEnrolled(2, 1, ENROL_USER_ACTIVE, 'student');
 286         $this->assertIsNotEnrolled(4, 4);
 287         $this->assertHasRoleAssignment(4, 4, 'editingteacher');
 288
 289         // Enrolment removals.
 290
 291         $DB->delete_records('enrol_database_test_enrols', array('userid' => 'userid1', 'courseid' => 'courseid1', 'roleid' => 'student'));
 292         $plugin->set_config('unenrolaction', ENROL_EXT_REMOVED_KEEP);
 293         $plugin->sync_user_enrolments(self::$users[1]);
 294         $this->assertEquals(3, $DB->count_records('user_enrolments', array()));
 295         $this->assertEquals(3, $DB->count_records('enrol', array('enrol' => 'database')));
 296         $this->assertEquals(4, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 297         $this->assertIsEnrolled(1, 1, ENROL_USER_ACTIVE, 'student');
 298         $this->assertIsEnrolled(1, 2, ENROL_USER_ACTIVE, 'teacher');
 299
 300
 301         $plugin->set_config('unenrolaction', ENROL_EXT_REMOVED_SUSPEND);
 302         $plugin->sync_user_enrolments(self::$users[1]);
 303         $this->assertEquals(3, $DB->count_records('user_enrolments', array()));
 304         $this->assertEquals(3, $DB->count_records('enrol', array('enrol' => 'database')));
 305         $this->assertEquals(4, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 306         $this->assertIsEnrolled(1, 1, ENROL_USER_SUSPENDED, 'student');
 307         $this->assertIsEnrolled(1, 2, ENROL_USER_ACTIVE, 'teacher');
 308
 309         $DB->insert_record('enrol_database_test_enrols', array('userid' => 'userid1', 'courseid' => 'courseid1', 'roleid' => 'student'));
 310         $plugin->sync_user_enrolments(self::$users[1]);
 311         $this->assertEquals(3, $DB->count_records('user_enrolments', array()));
 312         $this->assertEquals(3, $DB->count_records('enrol', array('enrol' => 'database')));
 313         $this->assertEquals(4, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 314         $this->assertIsEnrolled(1, 1, ENROL_USER_ACTIVE, 'student');
 315         $this->assertIsEnrolled(1, 2, ENROL_USER_ACTIVE, 'teacher');
 316
 317
 318         $DB->delete_records('enrol_database_test_enrols', array('userid' => 'userid1', 'courseid' => 'courseid1', 'roleid' => 'student'));
 319         $plugin->set_config('unenrolaction', ENROL_EXT_REMOVED_SUSPENDNOROLES);
 320         $plugin->sync_user_enrolments(self::$users[1]);
 321         $this->assertEquals(3, $DB->count_records('user_enrolments', array()));
 322         $this->assertEquals(3, $DB->count_records('enrol', array('enrol' => 'database')));
 323         $this->assertEquals(3, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 324         $this->assertIsEnrolled(1, 1, ENROL_USER_SUSPENDED, false);
 325         $this->assertIsEnrolled(1, 2, ENROL_USER_ACTIVE, 'teacher');
 326
 327         $DB->insert_record('enrol_database_test_enrols', array('userid' => 'userid1', 'courseid' => 'courseid1', 'roleid' => 'student'));
 328         $plugin->sync_user_enrolments(self::$users[1]);
 329         $this->assertEquals(3, $DB->count_records('user_enrolments', array()));
 330         $this->assertEquals(3, $DB->count_records('enrol', array('enrol' => 'database')));
 331         $this->assertEquals(4, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 332         $this->assertIsEnrolled(1, 1, ENROL_USER_ACTIVE, 'student');
 333         $this->assertIsEnrolled(1, 2, ENROL_USER_ACTIVE, 'teacher');
 334
 335
 336         $DB->delete_records('enrol_database_test_enrols', array('userid' => 'userid1', 'courseid' => 'courseid1', 'roleid' => 'student'));
 337         $plugin->set_config('unenrolaction', ENROL_EXT_REMOVED_UNENROL);
 338         $plugin->sync_user_enrolments(self::$users[1]);
 339         $this->assertEquals(2, $DB->count_records('user_enrolments', array()));
 340         $this->assertEquals(3, $DB->count_records('enrol', array('enrol' => 'database')));
 341         $this->assertEquals(3, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 342         $this->assertIsNotEnrolled(1, 1);
 343         $this->assertIsEnrolled(1, 2, ENROL_USER_ACTIVE, 'teacher');
 344
 345         $DB->delete_records('enrol_database_test_enrols', array('userid' => 'userid4', 'courseid' => 'courseid4', 'roleid' => 'editingteacher'));
 346         $plugin->set_config('unenrolaction', ENROL_EXT_REMOVED_SUSPENDNOROLES);
 347         $plugin->sync_user_enrolments(self::$users[4]);
 348         $this->assertEquals(2, $DB->count_records('user_enrolments', array()));
 349         $this->assertEquals(3, $DB->count_records('enrol', array('enrol' => 'database')));
 350         $this->assertEquals(2, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 351         $this->assertIsNotEnrolled(4, 4);
 352         $this->assertHasRoleAssignment(4, 4, false);
 353
 354         // Test all other mapping options.
 355
 356         $this->reset_enrol_database();
 357
 358         $this->assertEquals(0, $DB->count_records('user_enrolments', array()));
 359         $this->assertEquals(0, $DB->count_records('enrol', array('enrol' => 'database')));
 360         $this->assertEquals(0, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 361
 362         $plugin->set_config('localcoursefield', 'id');
 363         $plugin->set_config('localuserfield', 'id');
 364         $plugin->set_config('localrolefield', 'id');
 365
 366         $DB->insert_record('enrol_database_test_enrols', array('userid' => self::$users[1]->id, 'courseid' => self::$courses[1]->id, 'roleid' => self::$roles['student']->id));
 367         $DB->insert_record('enrol_database_test_enrols', array('userid' => self::$users[1]->id, 'courseid' => self::$courses[2]->id, 'roleid' => self::$roles['teacher']->id));
 368         $DB->insert_record('enrol_database_test_enrols', array('userid' => self::$users[2]->id, 'courseid' => self::$courses[1]->id, 'roleid' => self::$roles['student']->id));
 369
 370         $plugin->sync_user_enrolments(self::$users[1]);
 371         $this->assertEquals(2, $DB->count_records('user_enrolments', array()));
 372         $this->assertEquals(2, $DB->count_records('enrol', array('enrol' => 'database')));
 373         $this->assertEquals(2, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 374         $this->assertIsEnrolled(1, 1, ENROL_USER_ACTIVE, 'student');
 375         $this->assertIsEnrolled(1, 2, ENROL_USER_ACTIVE, 'teacher');
 376
 377
 378         $this->reset_enrol_database();
 379         $plugin->set_config('localcoursefield', 'shortname');
 380         $plugin->set_config('localuserfield', 'email');
 381         $plugin->set_config('localrolefield', 'id');
 382
 383         $DB->insert_record('enrol_database_test_enrols', array('userid' => self::$users[1]->email, 'courseid' => self::$courses[1]->shortname, 'roleid' => self::$roles['student']->id));
 384         $DB->insert_record('enrol_database_test_enrols', array('userid' => self::$users[1]->email, 'courseid' => self::$courses[2]->shortname, 'roleid' => self::$roles['teacher']->id));
 385         $DB->insert_record('enrol_database_test_enrols', array('userid' => self::$users[2]->email, 'courseid' => self::$courses[1]->shortname, 'roleid' => self::$roles['student']->id));
 386
 387         $plugin->sync_user_enrolments(self::$users[1]);
 388         $this->assertEquals(2, $DB->count_records('user_enrolments', array()));
 389         $this->assertEquals(2, $DB->count_records('enrol', array('enrol' => 'database')));
 390         $this->assertEquals(2, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 391         $this->assertIsEnrolled(1, 1, ENROL_USER_ACTIVE, 'student');
 392         $this->assertIsEnrolled(1, 2, ENROL_USER_ACTIVE, 'teacher');
 393
 394
 395         $this->reset_enrol_database();
 396         $plugin->set_config('localcoursefield', 'id');
 397         $plugin->set_config('localuserfield', 'username');
 398         $plugin->set_config('localrolefield', 'id');
 399
 400         $DB->insert_record('enrol_database_test_enrols', array('userid' => self::$users[1]->username, 'courseid' => self::$courses[1]->id, 'roleid' => self::$roles['student']->id));
 401         $DB->insert_record('enrol_database_test_enrols', array('userid' => self::$users[1]->username, 'courseid' => self::$courses[2]->id, 'roleid' => self::$roles['teacher']->id));
 402         $DB->insert_record('enrol_database_test_enrols', array('userid' => self::$users[2]->username, 'courseid' => self::$courses[1]->id, 'roleid' => self::$roles['student']->id));
 403
 404         $plugin->sync_user_enrolments(self::$users[1]);
 405         $this->assertEquals(2, $DB->count_records('user_enrolments', array()));
 406         $this->assertEquals(2, $DB->count_records('enrol', array('enrol' => 'database')));
 407         $this->assertEquals(2, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 408         $this->assertIsEnrolled(1, 1, ENROL_USER_ACTIVE, 'student');
 409         $this->assertIsEnrolled(1, 2, ENROL_USER_ACTIVE, 'teacher');
 410     }
 411
 412     /**
 413      * @depends test_sync_user_enrolments
 414      */
 415     public function test_sync_users() {
 416         global $DB;
 417
 418         $this->resetAfterTest(false);
 419         $this->preventResetByRollback();
 420         $this->reset_enrol_database();
 421
 422         $plugin = enrol_get_plugin('database');
 423
 424         $trace = new null_progress_trace();
 425
 426         // Test basic enrol sync for one user after login.
 427
 428         $this->reset_enrol_database();
 429         $plugin->set_config('localcoursefield', 'idnumber');
 430         $plugin->set_config('localuserfield', 'idnumber');
 431         $plugin->set_config('localrolefield', 'shortname');
 432
 433         $DB->insert_record('enrol_database_test_enrols', array('userid' => 'userid1', 'courseid' => 'courseid1', 'roleid' => 'student'));
 434         $DB->insert_record('enrol_database_test_enrols', array('userid' => 'userid1', 'courseid' => 'courseid2', 'roleid' => 'editingteacher'));
 435         $DB->insert_record('enrol_database_test_enrols', array('userid' => 'userid2', 'courseid' => 'courseid1', 'roleid' => 'student'));
 436         $DB->insert_record('enrol_database_test_enrols', array('userid' => 'userid4', 'courseid' => 'courseid4', 'roleid' => 'editingteacher', 'otheruser' => '1'));
 437         $DB->insert_record('enrol_database_test_enrols', array('userid' => 'xxxxxxx', 'courseid' => 'courseid1', 'roleid' => 'student')); // Bogus record to be ignored.
 438         $DB->insert_record('enrol_database_test_enrols', array('userid' => 'userid1', 'courseid' => 'xxxxxxxxx', 'roleid' => 'student')); // Bogus record to be ignored.
 439         $this->assertEquals(0, $DB->count_records('user_enrolments', array()));
 440         $this->assertEquals(0, $DB->count_records('enrol', array('enrol' => 'database')));
 441         $this->assertEquals(0, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 442
 443         $plugin->sync_enrolments($trace);
 444         $this->assertEquals(3, $DB->count_records('user_enrolments', array()));
 445         $this->assertEquals(3, $DB->count_records('enrol', array('enrol' => 'database')));
 446         $this->assertEquals(4, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 447         $this->assertIsEnrolled(1, 1, ENROL_USER_ACTIVE, 'student');
 448         $this->assertIsEnrolled(1, 2, ENROL_USER_ACTIVE, 'editingteacher');
 449         $this->assertIsEnrolled(2, 1, ENROL_USER_ACTIVE, 'student');
 450         $this->assertIsNotEnrolled(4, 4);
 451         $this->assertHasRoleAssignment(4, 4, 'editingteacher');
 452
 453         $plugin->set_config('defaultrole', self::$roles['teacher']->id);
 454         $DB->insert_record('enrol_database_test_enrols', array('userid' => 'userid3', 'courseid' => 'courseid3'));
 455         $plugin->sync_enrolments($trace);
 456         $this->assertEquals(4, $DB->count_records('user_enrolments', array()));
 457         $this->assertEquals(4, $DB->count_records('enrol', array('enrol' => 'database')));
 458         $this->assertEquals(5, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 459         $this->assertIsEnrolled(1, 1, ENROL_USER_ACTIVE, 'student');
 460         $this->assertIsEnrolled(1, 2, ENROL_USER_ACTIVE, 'editingteacher');
 461         $this->assertIsEnrolled(2, 1, ENROL_USER_ACTIVE, 'student');
 462         $this->assertIsNotEnrolled(4, 4);
 463         $this->assertHasRoleAssignment(4, 4, 'editingteacher');
 464         $this->assertIsEnrolled(3, 3, ENROL_USER_ACTIVE, 'teacher');
 465
 466
 467         // Test different unenrolment options.
 468
 469         $DB->delete_records('enrol_database_test_enrols', array('userid' => 'userid1', 'courseid' => 'courseid1', 'roleid' => 'student'));
 470         $plugin->set_config('unenrolaction', ENROL_EXT_REMOVED_KEEP);
 471         $plugin->sync_enrolments($trace);
 472         $this->assertEquals(4, $DB->count_records('user_enrolments', array()));
 473         $this->assertEquals(4, $DB->count_records('enrol', array('enrol' => 'database')));
 474         $this->assertEquals(5, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 475         $this->assertIsEnrolled(1, 1, ENROL_USER_ACTIVE, 'student');
 476         $this->assertIsEnrolled(1, 2, ENROL_USER_ACTIVE, 'editingteacher');
 477         $this->assertIsEnrolled(2, 1, ENROL_USER_ACTIVE, 'student');
 478         $this->assertIsNotEnrolled(4, 4);
 479         $this->assertHasRoleAssignment(4, 4, 'editingteacher');
 480         $this->assertIsEnrolled(3, 3, ENROL_USER_ACTIVE, 'teacher');
 481
 482
 483         $plugin->set_config('unenrolaction', ENROL_EXT_REMOVED_SUSPEND);
 484         $plugin->sync_enrolments($trace);
 485         $this->assertEquals(4, $DB->count_records('user_enrolments', array()));
 486         $this->assertEquals(4, $DB->count_records('enrol', array('enrol' => 'database')));
 487         $this->assertEquals(5, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 488         $this->assertIsEnrolled(1, 1, ENROL_USER_SUSPENDED, 'student');
 489         $this->assertIsEnrolled(1, 2, ENROL_USER_ACTIVE, 'editingteacher');
 490         $this->assertIsEnrolled(2, 1, ENROL_USER_ACTIVE, 'student');
 491         $this->assertIsNotEnrolled(4, 4);
 492         $this->assertHasRoleAssignment(4, 4, 'editingteacher');
 493         $this->assertIsEnrolled(3, 3, ENROL_USER_ACTIVE, 'teacher');
 494
 495         $DB->insert_record('enrol_database_test_enrols', array('userid' => 'userid1', 'courseid' => 'courseid1', 'roleid' => 'student'));
 496         $plugin->sync_enrolments($trace);
 497         $this->assertEquals(4, $DB->count_records('user_enrolments', array()));
 498         $this->assertEquals(4, $DB->count_records('enrol', array('enrol' => 'database')));
 499         $this->assertEquals(5, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 500         $this->assertIsEnrolled(1, 1, ENROL_USER_ACTIVE, 'student');
 501         $this->assertIsEnrolled(1, 2, ENROL_USER_ACTIVE, 'editingteacher');
 502         $this->assertIsEnrolled(2, 1, ENROL_USER_ACTIVE, 'student');
 503         $this->assertIsNotEnrolled(4, 4);
 504         $this->assertHasRoleAssignment(4, 4, 'editingteacher');
 505         $this->assertIsEnrolled(3, 3, ENROL_USER_ACTIVE, 'teacher');
 506
 507
 508         $DB->delete_records('enrol_database_test_enrols', array('userid' => 'userid1', 'courseid' => 'courseid1', 'roleid' => 'student'));
 509         $plugin->set_config('unenrolaction', ENROL_EXT_REMOVED_SUSPENDNOROLES);
 510         $plugin->sync_enrolments($trace);
 511         $this->assertEquals(4, $DB->count_records('user_enrolments', array()));
 512         $this->assertEquals(4, $DB->count_records('enrol', array('enrol' => 'database')));
 513         $this->assertEquals(4, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 514         $this->assertIsEnrolled(1, 1, ENROL_USER_SUSPENDED, false);
 515         $this->assertIsEnrolled(1, 2, ENROL_USER_ACTIVE, 'editingteacher');
 516         $this->assertIsEnrolled(2, 1, ENROL_USER_ACTIVE, 'student');
 517         $this->assertIsNotEnrolled(4, 4);
 518         $this->assertHasRoleAssignment(4, 4, 'editingteacher');
 519         $this->assertIsEnrolled(3, 3, ENROL_USER_ACTIVE, 'teacher');
 520
 521         $DB->insert_record('enrol_database_test_enrols', array('userid' => 'userid1', 'courseid' => 'courseid1', 'roleid' => 'student'));
 522         $plugin->sync_enrolments($trace);
 523         $this->assertEquals(4, $DB->count_records('user_enrolments', array()));
 524         $this->assertEquals(4, $DB->count_records('enrol', array('enrol' => 'database')));
 525         $this->assertEquals(5, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 526         $this->assertIsEnrolled(1, 1, ENROL_USER_ACTIVE, 'student');
 527         $this->assertIsEnrolled(1, 2, ENROL_USER_ACTIVE, 'editingteacher');
 528         $this->assertIsEnrolled(2, 1, ENROL_USER_ACTIVE, 'student');
 529         $this->assertIsNotEnrolled(4, 4);
 530         $this->assertHasRoleAssignment(4, 4, 'editingteacher');
 531         $this->assertIsEnrolled(3, 3, ENROL_USER_ACTIVE, 'teacher');
 532
 533
 534         $DB->delete_records('enrol_database_test_enrols', array('userid' => 'userid1', 'courseid' => 'courseid1', 'roleid' => 'student'));
 535         $plugin->set_config('unenrolaction', ENROL_EXT_REMOVED_UNENROL);
 536         $plugin->sync_enrolments($trace);
 537         $this->assertEquals(3, $DB->count_records('user_enrolments', array()));
 538         $this->assertEquals(4, $DB->count_records('enrol', array('enrol' => 'database')));
 539         $this->assertEquals(4, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 540         $this->assertIsNotEnrolled(1, 1);
 541         $this->assertIsEnrolled(1, 2, ENROL_USER_ACTIVE, 'editingteacher');
 542         $this->assertIsEnrolled(2, 1, ENROL_USER_ACTIVE, 'student');
 543         $this->assertIsNotEnrolled(4, 4);
 544         $this->assertHasRoleAssignment(4, 4, 'editingteacher');
 545         $this->assertIsEnrolled(3, 3, ENROL_USER_ACTIVE, 'teacher');
 546
 547         $DB->insert_record('enrol_database_test_enrols', array('userid' => 'userid1', 'courseid' => 'courseid1', 'roleid' => 'student'));
 548         $DB->insert_record('enrol_database_test_enrols', array('userid' => 'userid1', 'courseid' => 'courseid1', 'roleid' => 'teacher'));
 549         $plugin->sync_enrolments($trace);
 550         $this->assertEquals(4, $DB->count_records('user_enrolments', array()));
 551         $this->assertEquals(4, $DB->count_records('enrol', array('enrol' => 'database')));
 552         $this->assertEquals(6, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 553         $this->assertIsEnrolled(1, 1, ENROL_USER_ACTIVE, 'student');
 554         $this->assertIsEnrolled(1, 1, ENROL_USER_ACTIVE, 'teacher');
 555         $this->assertIsEnrolled(1, 2, ENROL_USER_ACTIVE, 'editingteacher');
 556         $this->assertIsEnrolled(2, 1, ENROL_USER_ACTIVE, 'student');
 557         $this->assertIsNotEnrolled(4, 4);
 558         $this->assertHasRoleAssignment(4, 4, 'editingteacher');
 559         $this->assertIsEnrolled(3, 3, ENROL_USER_ACTIVE, 'teacher');
 560
 561         $DB->delete_records('enrol_database_test_enrols', array('userid' => 'userid1', 'courseid' => 'courseid1', 'roleid' => 'teacher'));
 562         $plugin->sync_enrolments($trace);
 563         $this->assertEquals(4, $DB->count_records('user_enrolments', array()));
 564         $this->assertEquals(4, $DB->count_records('enrol', array('enrol' => 'database')));
 565         $this->assertEquals(5, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 566         $this->assertIsEnrolled(1, 1, ENROL_USER_ACTIVE, 'student');
 567         $this->assertIsEnrolled(1, 2, ENROL_USER_ACTIVE, 'editingteacher');
 568         $this->assertIsEnrolled(2, 1, ENROL_USER_ACTIVE, 'student');
 569         $this->assertIsNotEnrolled(4, 4);
 570         $this->assertHasRoleAssignment(4, 4, 'editingteacher');
 571         $this->assertIsEnrolled(3, 3, ENROL_USER_ACTIVE, 'teacher');
 572
 573
 574         // Test all other mapping options.
 575
 576         $this->reset_enrol_database();
 577
 578         $this->assertEquals(0, $DB->count_records('user_enrolments', array()));
 579         $this->assertEquals(0, $DB->count_records('enrol', array('enrol' => 'database')));
 580         $this->assertEquals(0, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 581
 582         $plugin->set_config('localcoursefield', 'id');
 583         $plugin->set_config('localuserfield', 'id');
 584         $plugin->set_config('localrolefield', 'id');
 585
 586         $DB->insert_record('enrol_database_test_enrols', array('userid' => self::$users[1]->id, 'courseid' => self::$courses[1]->id, 'roleid' => self::$roles['student']->id));
 587         $DB->insert_record('enrol_database_test_enrols', array('userid' => self::$users[1]->id, 'courseid' => self::$courses[2]->id, 'roleid' => self::$roles['teacher']->id));
 588         $DB->insert_record('enrol_database_test_enrols', array('userid' => self::$users[2]->id, 'courseid' => self::$courses[1]->id, 'roleid' => self::$roles['student']->id));
 589
 590         $plugin->sync_enrolments($trace);
 591         $this->assertEquals(3, $DB->count_records('user_enrolments', array()));
 592         $this->assertEquals(2, $DB->count_records('enrol', array('enrol' => 'database')));
 593         $this->assertEquals(3, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 594         $this->assertIsEnrolled(1, 1, ENROL_USER_ACTIVE, 'student');
 595         $this->assertIsEnrolled(1, 2, ENROL_USER_ACTIVE, 'teacher');
 596         $this->assertIsEnrolled(2, 1, ENROL_USER_ACTIVE, 'student');
 597
 598
 599         $this->reset_enrol_database();
 600         $plugin->set_config('localcoursefield', 'shortname');
 601         $plugin->set_config('localuserfield', 'email');
 602         $plugin->set_config('localrolefield', 'id');
 603
 604         $DB->insert_record('enrol_database_test_enrols', array('userid' => self::$users[1]->email, 'courseid' => self::$courses[1]->shortname, 'roleid' => self::$roles['student']->id));
 605         $DB->insert_record('enrol_database_test_enrols', array('userid' => self::$users[1]->email, 'courseid' => self::$courses[2]->shortname, 'roleid' => self::$roles['teacher']->id));
 606         $DB->insert_record('enrol_database_test_enrols', array('userid' => self::$users[2]->email, 'courseid' => self::$courses[1]->shortname, 'roleid' => self::$roles['student']->id));
 607
 608         $plugin->sync_enrolments($trace);
 609         $this->assertEquals(3, $DB->count_records('user_enrolments', array()));
 610         $this->assertEquals(2, $DB->count_records('enrol', array('enrol' => 'database')));
 611         $this->assertEquals(3, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 612         $this->assertIsEnrolled(1, 1, ENROL_USER_ACTIVE, 'student');
 613         $this->assertIsEnrolled(1, 2, ENROL_USER_ACTIVE, 'teacher');
 614         $this->assertIsEnrolled(2, 1, ENROL_USER_ACTIVE, 'student');
 615
 616
 617         $this->reset_enrol_database();
 618         $plugin->set_config('localcoursefield', 'id');
 619         $plugin->set_config('localuserfield', 'username');
 620         $plugin->set_config('localrolefield', 'id');
 621
 622         $DB->insert_record('enrol_database_test_enrols', array('userid' => self::$users[1]->username, 'courseid' => self::$courses[1]->id, 'roleid' => self::$roles['student']->id));
 623         $DB->insert_record('enrol_database_test_enrols', array('userid' => self::$users[1]->username, 'courseid' => self::$courses[2]->id, 'roleid' => self::$roles['teacher']->id));
 624         $DB->insert_record('enrol_database_test_enrols', array('userid' => self::$users[2]->username, 'courseid' => self::$courses[1]->id, 'roleid' => self::$roles['student']->id));
 625
 626         $plugin->sync_enrolments($trace);
 627         $this->assertEquals(3, $DB->count_records('user_enrolments', array()));
 628         $this->assertEquals(2, $DB->count_records('enrol', array('enrol' => 'database')));
 629         $this->assertEquals(3, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 630         $this->assertIsEnrolled(1, 1, ENROL_USER_ACTIVE, 'student');
 631         $this->assertIsEnrolled(1, 2, ENROL_USER_ACTIVE, 'teacher');
 632         $this->assertIsEnrolled(2, 1, ENROL_USER_ACTIVE, 'student');
 633
 634
 635         // Test sync of one course only.
 636
 637         $this->reset_enrol_database();
 638
 639         $DB->insert_record('enrol_database_test_enrols', array('userid' => self::$users[1]->username, 'courseid' => self::$courses[1]->id, 'roleid' => self::$roles['student']->id));
 640         $DB->insert_record('enrol_database_test_enrols', array('userid' => self::$users[1]->username, 'courseid' => self::$courses[2]->id, 'roleid' => self::$roles['teacher']->id));
 641         $DB->insert_record('enrol_database_test_enrols', array('userid' => self::$users[2]->username, 'courseid' => self::$courses[1]->id, 'roleid' => self::$roles['student']->id));
 642
 643         $this->assertEquals(0, $DB->count_records('user_enrolments', array()));
 644         $this->assertEquals(0, $DB->count_records('enrol', array('enrol' => 'database')));
 645         $this->assertEquals(0, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 646
 647         $plugin->sync_enrolments($trace, self::$courses[3]->id);
 648         $this->assertEquals(0, $DB->count_records('user_enrolments', array()));
 649         $this->assertEquals(1, $DB->count_records('enrol', array('enrol' => 'database')));
 650         $this->assertEquals(0, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 651
 652         $plugin->sync_enrolments($trace, self::$courses[1]->id);
 653         $this->assertEquals(2, $DB->count_records('user_enrolments', array()));
 654         $this->assertEquals(2, $DB->count_records('enrol', array('enrol' => 'database')));
 655         $this->assertEquals(2, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 656         $this->assertIsEnrolled(1, 1, ENROL_USER_ACTIVE, 'student');
 657         $this->assertIsEnrolled(2, 1, ENROL_USER_ACTIVE, 'student');
 658
 659         $plugin->sync_enrolments($trace, self::$courses[2]->id);
 660         $this->assertEquals(3, $DB->count_records('user_enrolments', array()));
 661         $this->assertEquals(3, $DB->count_records('enrol', array('enrol' => 'database')));
 662         $this->assertEquals(3, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 663         $this->assertIsEnrolled(1, 1, ENROL_USER_ACTIVE, 'student');
 664         $this->assertIsEnrolled(1, 2, ENROL_USER_ACTIVE, 'teacher');
 665         $this->assertIsEnrolled(2, 1, ENROL_USER_ACTIVE, 'student');
 666
 667
 668         $plugin->set_config('unenrolaction', ENROL_EXT_REMOVED_UNENROL);
 669
 670         $DB->delete_records('enrol_database_test_enrols', array());
 671
 672         $plugin->sync_enrolments($trace, self::$courses[1]->id);
 673         $this->assertEquals(1, $DB->count_records('user_enrolments', array()));
 674         $this->assertEquals(3, $DB->count_records('enrol', array('enrol' => 'database')));
 675         $this->assertEquals(1, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 676         $this->assertIsEnrolled(1, 2, ENROL_USER_ACTIVE, 'teacher');
 677
 678         $plugin->sync_enrolments($trace, self::$courses[2]->id);
 679         $this->assertEquals(0, $DB->count_records('user_enrolments', array()));
 680         $this->assertEquals(3, $DB->count_records('enrol', array('enrol' => 'database')));
 681         $this->assertEquals(0, $DB->count_records('role_assignments', array('component' => 'enrol_database')));
 682     }
 683
 684     /**
 685      * @depends test_sync_users
 686      */
 687     public function test_sync_courses() {
 688         global $DB;
 689
 690         $this->resetAfterTest(true);
 691         $this->preventResetByRollback();
 692         $this->reset_enrol_database();
 693
 694         $plugin = enrol_get_plugin('database');
 695
 696         $trace = new null_progress_trace();
 697
 698         $plugin->set_config('localcategoryfield', 'id');
 699         $coursecat = $this->getDataGenerator()->create_category(array('name' => 'Test category 1', 'idnumber' => 'tcid1'));
 700         $defcat = $DB->get_record('course_categories', array('id' => $plugin->get_config('defaultcategory')));
 701
 702         $course1 = array('fullname' => 'New course 1', 'shortname' => 'nc1', 'idnumber' => 'ncid1', 'category' => $coursecat->id);
 703         $course2 = array('fullname' => 'New course 2', 'shortname' => 'nc2', 'idnumber' => 'ncid2', 'category' => null);
 704         // Duplicate records are to be ignored.
 705         $course3 = array('fullname' => 'New course 3', 'shortname' => 'xx', 'idnumber' => 'yy2', 'category' => $defcat->id);
 706         $course4 = array('fullname' => 'New course 4', 'shortname' => 'xx', 'idnumber' => 'yy3', 'category' => $defcat->id);
 707         $course5 = array('fullname' => 'New course 5', 'shortname' => 'xx1', 'idnumber' => 'yy', 'category' => $defcat->id);
 708         $course6 = array('fullname' => 'New course 6', 'shortname' => 'xx2', 'idnumber' => 'yy', 'category' => $defcat->id);
 709
 710         $DB->insert_record('enrol_database_test_courses', $course1);
 711         $DB->insert_record('enrol_database_test_courses', $course2);
 712         $DB->insert_record('enrol_database_test_courses', $course3);
 713         $DB->insert_record('enrol_database_test_courses', $course4);
 714         $DB->insert_record('enrol_database_test_courses', $course5);
 715         $DB->insert_record('enrol_database_test_courses', $course6);
 716
 717         $this->assertEquals(1+count(self::$courses), $DB->count_records('course'));
 718
 719         $plugin->sync_courses($trace);
 720
 721         $this->assertEquals(4+1+count(self::$courses), $DB->count_records('course'));
 722
 723         $this->assertTrue($DB->record_exists('course', $course1));
 724         $course2['category'] = $defcat->id;
 725         $this->assertTrue($DB->record_exists('course', $course2));
 726
 727
 728         // People should NOT push duplicates there because the results are UNDEFINED! But anyway skip the duplicates.
 729
 730         $this->assertEquals(1, $DB->count_records('course', array('idnumber' => 'yy')));
 731         $this->assertEquals(1, $DB->count_records('course', array('shortname' => 'xx')));
 732
 733
 734         // Test category mapping via idnumber.
 735
 736         $plugin->set_config('localcategoryfield', 'idnumber');
 737         $course7 = array('fullname' => 'New course 7', 'shortname' => 'nc7', 'idnumber' => 'ncid7', 'category' => 'tcid1');
 738         $DB->insert_record('enrol_database_test_courses', $course7);
 739         $plugin->sync_courses($trace);
 740
 741         $this->assertEquals(1+4+1+count(self::$courses), $DB->count_records('course'));
 742         $this->assertTrue($DB->record_exists('course', $course1));
 743         $this->assertTrue($DB->record_exists('course', $course2));
 744         $course7['category'] = $coursecat->id;
 745         $this->assertTrue($DB->record_exists('course', $course7));
 746
 747
 748         // Test course template.
 749
 750         $template = $this->getDataGenerator()->create_course(array('numsections' => 666, 'shortname' => 'crstempl'));
 751         $plugin->set_config('templatecourse', 'crstempl');
 752
 753         $course8 = array('fullname' => 'New course 8', 'shortname' => 'nc8', 'idnumber' => 'ncid8', 'category' => null);
 754         $DB->insert_record('enrol_database_test_courses', $course8);
 755         $plugin->sync_courses($trace);
 756
 757         $this->assertEquals(2+1+4+1+count(self::$courses), $DB->count_records('course'));
 758         $course8['category'] = $defcat->id;
 759         $record = $DB->get_record('course', $course8);
 760         $this->assertFalse(empty($record));
 761         $courseformatoptions = course_get_format($record)->get_format_options();
 762         $this->assertEquals($courseformatoptions['numsections'], 666);
 763
 764         // Test invalid category.
 765
 766         $course9 = array('fullname' => 'New course 9', 'shortname' => 'nc9', 'idnumber' => 'ncid9', 'category' => 'xxxxxxx');
 767         $DB->insert_record('enrol_database_test_courses', $course9);
 768         $plugin->sync_courses($trace);
 769         $this->assertEquals(2+1+4+1+count(self::$courses), $DB->count_records('course'));
 770         $this->assertFalse($DB->record_exists('course', array('idnumber' => 'ncid9')));
 771
 772
 773         // Test when categories not specified.
 774
 775         $plugin->set_config('newcoursecategory', '');
 776         $plugin->sync_courses($trace);
 777         $this->assertEquals(1+2+1+4+1+count(self::$courses), $DB->count_records('course'));
 778         $this->assertTrue($DB->record_exists('course', array('idnumber' => 'ncid9')));
 779
 780
 781         // Final cleanup - remove extra tables, fixtures and caches.
 782         $this->cleanup_enrol_database();
 783     }
 784 }