/** * Test that we can add related competencies. * * @return void */ public function test_add_related_competency() { global $DB; $this->setUser($this->creator); $lpg = $this->getDataGenerator()->get_plugin_generator('core_competency'); $framework = $lpg->create_framework(); $framework2 = $lpg->create_framework(); $competency1 = $lpg->create_competency(array('competencyframeworkid' => $framework->get_id())); $competency2 = $lpg->create_competency(array('competencyframeworkid' => $framework->get_id())); $competency3 = $lpg->create_competency(array('competencyframeworkid' => $framework->get_id())); $competency4 = $lpg->create_competency(array('competencyframeworkid' => $framework2->get_id())); // The lower one always as competencyid. $result = external::add_related_competency($competency1->get_id(), $competency2->get_id()); $result = external_api::clean_returnvalue(external::add_related_competency_returns(), $result); $this->assertTrue($result); $this->assertTrue($DB->record_exists_select(related_competency::TABLE, 'competencyid = :cid AND relatedcompetencyid = :rid', array('cid' => $competency1->get_id(), 'rid' => $competency2->get_id()))); $this->assertFalse($DB->record_exists_select(related_competency::TABLE, 'competencyid = :cid AND relatedcompetencyid = :rid', array('cid' => $competency2->get_id(), 'rid' => $competency1->get_id()))); $result = external::add_related_competency($competency3->get_id(), $competency1->get_id()); $result = external_api::clean_returnvalue(external::add_related_competency_returns(), $result); $this->assertTrue($result); $this->assertTrue($DB->record_exists_select(related_competency::TABLE, 'competencyid = :cid AND relatedcompetencyid = :rid', array('cid' => $competency1->get_id(), 'rid' => $competency3->get_id()))); $this->assertFalse($DB->record_exists_select(related_competency::TABLE, 'competencyid = :cid AND relatedcompetencyid = :rid', array('cid' => $competency3->get_id(), 'rid' => $competency1->get_id()))); // We can not allow a duplicate relation, not even in the other direction. $this->assertEquals(1, $DB->count_records_select(related_competency::TABLE, 'competencyid = :cid AND relatedcompetencyid = :rid', array('cid' => $competency1->get_id(), 'rid' => $competency2->get_id()))); $this->assertEquals(0, $DB->count_records_select(related_competency::TABLE, 'competencyid = :cid AND relatedcompetencyid = :rid', array('rid' => $competency1->get_id(), 'cid' => $competency2->get_id()))); $result = external::add_related_competency($competency2->get_id(), $competency1->get_id()); $result = external_api::clean_returnvalue(external::add_related_competency_returns(), $result); $this->assertTrue($result); $this->assertEquals(1, $DB->count_records_select(related_competency::TABLE, 'competencyid = :cid AND relatedcompetencyid = :rid', array('cid' => $competency1->get_id(), 'rid' => $competency2->get_id()))); $this->assertEquals(0, $DB->count_records_select(related_competency::TABLE, 'competencyid = :cid AND relatedcompetencyid = :rid', array('rid' => $competency1->get_id(), 'cid' => $competency2->get_id()))); // Check that we cannot create links across frameworks. try { external::add_related_competency($competency1->get_id(), $competency4->get_id()); $this->fail('Exception expected due mis-use of shared competencies'); } catch (invalid_persistent_exception $e) { // Yay! } // User without permission. $this->setUser($this->user); // Check we can not add the related competency now. try { external::add_related_competency($competency1->get_id(), $competency3->get_id()); $this->fail('Exception expected due to not permissions to manage template competencies'); } catch (moodle_exception $e) { $this->assertEquals('nopermissions', $e->errorcode); } }