. /** * Tag related unit tests. * * @package core_tag * @category test * @copyright 2014 Mark Nelson * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later */ defined('MOODLE_INTERNAL') || die(); global $CFG; require_once($CFG->dirroot . '/tag/lib.php'); class core_tag_taglib_testcase extends advanced_testcase { /** * Test set up. * * This is executed before running any test in this file. */ public function setUp() { $this->resetAfterTest(); } /** * Test the tag_set function. */ public function test_tag_set() { global $DB; // Create a course to tag. $course = $this->getDataGenerator()->create_course(); // Create the tag and tag instance. tag_set('course', $course->id, array('A random tag'), 'core', context_course::instance($course->id)->id); // Get the tag instance that should have been created. $taginstance = $DB->get_record('tag_instance', array('itemtype' => 'course', 'itemid' => $course->id), '*', MUST_EXIST); $this->assertEquals('core', $taginstance->component); $this->assertEquals(context_course::instance($course->id)->id, $taginstance->contextid); // Now call the tag_set function without specifying the component or contextid and // ensure the function debugging is called. tag_set('course', $course->id, array('Another tag')); $this->assertDebuggingCalled(); } /** * Test the tag_set_add function. */ public function test_tag_set_add() { global $DB; // Create a course to tag. $course = $this->getDataGenerator()->create_course(); // Create the tag and tag instance. tag_set_add('course', $course->id, 'A random tag', 'core', context_course::instance($course->id)->id); // Get the tag instance that should have been created. $taginstance = $DB->get_record('tag_instance', array('itemtype' => 'course', 'itemid' => $course->id), '*', MUST_EXIST); $this->assertEquals('core', $taginstance->component); $this->assertEquals(context_course::instance($course->id)->id, $taginstance->contextid); // Remove the tag we just created. $tag = $DB->get_record('tag', array('rawname' => 'A random tag')); tag_delete($tag->id); // Now call the tag_set_add function without specifying the component or // contextid and ensure the function debugging is called. tag_set_add('course', $course->id, 'Another tag'); $this->assertDebuggingCalled(); } /** * Test the tag_set_delete function. */ public function test_tag_set_delete() { global $DB; // Create a course to tag. $course = $this->getDataGenerator()->create_course(); // Create the tag and tag instance we are going to delete. tag_set_add('course', $course->id, 'A random tag', 'core', context_course::instance($course->id)->id); // Call the tag_set_delete function. tag_set_delete('course', $course->id, 'a random tag', 'core', context_course::instance($course->id)->id); // Now check that there are no tags or tag instances. $this->assertEquals(0, $DB->count_records('tag')); $this->assertEquals(0, $DB->count_records('tag_instance')); // Recreate the tag and tag instance. tag_set_add('course', $course->id, 'A random tag', 'core', context_course::instance($course->id)->id); // Now call the tag_set_delete function without specifying the component or // contextid and ensure the function debugging is called. tag_set_delete('course', $course->id, 'A random tag'); $this->assertDebuggingCalled(); } /** * Test the tag_assign function. */ public function test_tag_assign() { global $DB; // Create a course to tag. $course = $this->getDataGenerator()->create_course(); // Create the tag. $tag = $this->getDataGenerator()->create_tag(); // Tag the course with the tag we created. tag_assign('course', $course->id, $tag->id, 0, 0, 'core', context_course::instance($course->id)->id); // Get the tag instance that should have been created. $taginstance = $DB->get_record('tag_instance', array('itemtype' => 'course', 'itemid' => $course->id), '*', MUST_EXIST); $this->assertEquals('core', $taginstance->component); $this->assertEquals(context_course::instance($course->id)->id, $taginstance->contextid); // Now call the tag_assign function without specifying the component or // contextid and ensure the function debugging is called. tag_assign('course', $course->id, $tag->id, 0, 0); $this->assertDebuggingCalled(); } /** * Test the tag cleanup function used by the cron. */ public function test_tag_cleanup() { global $DB; // Create some users. $users = array(); for ($i = 0; $i < 10; $i++) { $users[] = $this->getDataGenerator()->create_user(); } // Create a course to tag. $course = $this->getDataGenerator()->create_course(); $context = context_course::instance($course->id); // Test clean up instances with tags that no longer exist. $tags = array(); for ($i = 0; $i < 10; $i++) { $tags[] = $this->getDataGenerator()->create_tag(array('userid' => $users[0]->id)); } // Create instances with the tags. foreach ($tags as $tag) { tag_assign('course', $course->id, $tag->id, 0, 0, 'core', $context->id); } // We should now have ten tag instances. $coursetaginstances = $DB->count_records('tag_instance', array('itemtype' => 'course')); $this->assertEquals(10, $coursetaginstances); // Delete four tags // Manual delete of tags is done as the function will remove the instances as well. $DB->delete_records('tag', array('id' => $tags[6]->id)); $DB->delete_records('tag', array('id' => $tags[7]->id)); $DB->delete_records('tag', array('id' => $tags[8]->id)); $DB->delete_records('tag', array('id' => $tags[9]->id)); // Clean up the tags. tag_cleanup(); // Check that we now only have six tag_instance records left. $coursetaginstances = $DB->count_records('tag_instance', array('itemtype' => 'course')); $this->assertEquals(6, $coursetaginstances); // Test clean up with users that have been deleted. // Create a tag for this course. foreach ($users as $user) { tag_assign('user', $user->id, $tags[0]->id, 0, 0, 'core', $context->id); } $usertags = $DB->count_records('tag_instance', array('itemtype' => 'user')); $this->assertCount($usertags, $users); // Remove three students. // Using the proper function to delete the user will also remove the tags. $DB->update_record('user', array('id' => $users[4]->id, 'deleted' => 1)); $DB->update_record('user', array('id' => $users[5]->id, 'deleted' => 1)); $DB->update_record('user', array('id' => $users[6]->id, 'deleted' => 1)); // Clean up the tags. tag_cleanup(); $usertags = $DB->count_records('tag_instance', array('itemtype' => 'user')); $usercount = $DB->count_records('user', array('deleted' => 0)); // Remove admin and guest from the count. $this->assertEquals($usertags, ($usercount - 2)); // Test clean up where a course has been removed. // Delete the course. This also needs to be this way otherwise the tags are removed by using the proper function. $DB->delete_records('course', array('id' => $course->id)); tag_cleanup(); $coursetags = $DB->count_records('tag_instance', array('itemtype' => 'course')); $this->assertEquals(0, $coursetags); // Test clean up where a post has been removed. // Create default post. $post = new stdClass(); $post->userid = $users[1]->id; $post->content = 'test post content text'; $post->id = $DB->insert_record('post', $post); tag_assign('post', $post->id, $tags[0]->id, 0, 0, 'core', $context->id); // Add another one with a fake post id to be removed. tag_assign('post', 15, $tags[0]->id, 0, 0, 'core', $context->id); // Check that there are two tag instances. $posttags = $DB->count_records('tag_instance', array('itemtype' => 'post')); $this->assertEquals(2, $posttags); // Clean up the tags. tag_cleanup(); // We should only have one entry left now. $posttags = $DB->count_records('tag_instance', array('itemtype' => 'post')); $this->assertEquals(1, $posttags); } /** * Test deleting a group of tag instances. */ public function test_tag_bulk_delete_instances() { global $DB; // Setup. $user = $this->getDataGenerator()->create_user(); $course = $this->getDataGenerator()->create_course(); $context = context_course::instance($course->id); // Create some tag instances. for ($i = 0; $i < 10; $i++) { $tag = $this->getDataGenerator()->create_tag(array('userid' => $user->id)); tag_assign('course', $course->id, $tag->id, 0, 0, 'core', $context->id); } // Get tag instances. tag name and rawname are required for the event fired in this function. $sql = "SELECT ti.*, t.name, t.rawname FROM {tag_instance} ti JOIN {tag} t ON t.id = ti.tagid"; $taginstances = $DB->get_records_sql($sql); $this->assertCount(10, $taginstances); // Run the function. tag_bulk_delete_instances($taginstances); // Make sure they are gone. $instancecount = $DB->count_records('tag_instance'); $this->assertEquals(0, $instancecount); } /** * Test for function tag_compute_correlations() that is part of tag cron */ public function test_correlations() { global $DB; $user = $this->getDataGenerator()->create_user(); $this->setUser($user); $user1 = $this->getDataGenerator()->create_user(); $user2 = $this->getDataGenerator()->create_user(); $user3 = $this->getDataGenerator()->create_user(); $user4 = $this->getDataGenerator()->create_user(); $user5 = $this->getDataGenerator()->create_user(); $user6 = $this->getDataGenerator()->create_user(); // Several records have both 'cat' and 'cats' tags attached to them. // This will make those tags automatically correlated. // Same with 'dog', 'dogs' and 'puppy. tag_set('user', $user1->id, array('cat', 'cats'), 'core', context_user::instance($user1->id)->id); tag_set('user', $user2->id, array('cat', 'cats', 'kitten'), 'core', context_user::instance($user2->id)->id); tag_set('user', $user3->id, array('cat', 'cats'), 'core', context_user::instance($user3->id)->id); tag_set('user', $user4->id, array('dog', 'dogs', 'puppy'), 'core', context_user::instance($user4->id)->id); tag_set('user', $user5->id, array('dog', 'dogs', 'puppy'), 'core', context_user::instance($user5->id)->id); tag_set('user', $user6->id, array('dog', 'dogs', 'puppy'), 'core', context_user::instance($user6->id)->id); $tags = tag_get_id(array('cat', 'cats', 'dog', 'dogs', 'kitten', 'puppy')); // Add manual relation between tags 'cat' and 'kitten'. tag_set('tag', $tags['cat'], array('kitten'), 'core', context_system::instance()->id); tag_compute_correlations(); $this->assertEquals($tags['cats'], $DB->get_field_select('tag_correlation', 'correlatedtags', 'tagid = ?', array($tags['cat']))); $this->assertEquals($tags['cat'], $DB->get_field_select('tag_correlation', 'correlatedtags', 'tagid = ?', array($tags['cats']))); $this->assertEquals($tags['dogs'] . ',' . $tags['puppy'], $DB->get_field_select('tag_correlation', 'correlatedtags', 'tagid = ?', array($tags['dog']))); $this->assertEquals($tags['dog'] . ',' . $tags['puppy'], $DB->get_field_select('tag_correlation', 'correlatedtags', 'tagid = ?', array($tags['dogs']))); $this->assertEquals($tags['dog'] . ',' . $tags['dogs'], $DB->get_field_select('tag_correlation', 'correlatedtags', 'tagid = ?', array($tags['puppy']))); // Make sure tag_get_correlated() returns 'cats' as the only correlated tag to the 'cat'. $correlatedtags = array_values(tag_get_correlated($tags['cat'])); $this->assertCount(3, $correlatedtags); // This will return all existing instances but they all point to the same tag. $this->assertEquals('cats', $correlatedtags[0]->rawname); $this->assertEquals('cats', $correlatedtags[1]->rawname); $this->assertEquals('cats', $correlatedtags[2]->rawname); $correlatedtags = array_values(tag_get_related_tags($tags['cat'], TAG_RELATED_CORRELATED)); $this->assertCount(1, $correlatedtags); // Duplicates are filtered out here. $this->assertEquals('cats', $correlatedtags[0]->rawname); // Make sure tag_get_correlated() returns 'dogs' and 'puppy' as the correlated tags to the 'dog'. $correlatedtags = array_values(tag_get_correlated($tags['dog'])); $this->assertCount(6, $correlatedtags); // 2 tags times 3 instances. $correlatedtags = array_values(tag_get_related_tags($tags['dog'], TAG_RELATED_CORRELATED)); $this->assertCount(2, $correlatedtags); $this->assertEquals('dogs', $correlatedtags[0]->rawname); $this->assertEquals('puppy', $correlatedtags[1]->rawname); // Function tag_get_related_tags() with default argument will return both related and correlated tags. $relatedtags = array_values(tag_get_related_tags($tags['cat'])); $this->assertCount(2, $relatedtags); $this->assertEquals('kitten', $relatedtags[0]->rawname); $this->assertEquals('cats', $relatedtags[1]->rawname); // If we then manually set 'cat' and 'cats' as related, tag_get_related_tags() will filter out duplicates. tag_set('tag', $tags['cat'], array('kitten', 'cats'), 'core', context_system::instance()->id); $relatedtags = array_values(tag_get_related_tags($tags['cat'])); $this->assertCount(2, $relatedtags); $this->assertEquals('kitten', $relatedtags[0]->rawname); $this->assertEquals('cats', $relatedtags[1]->rawname); // Make sure tag_get_correlated() and tag_get_tags() return the same set of fields. $relatedtags = tag_get_tags('tag', $tags['cat']); $relatedtag = reset($relatedtags); $correlatedtags = tag_get_correlated($tags['cat']); $correlatedtag = reset($correlatedtags); $this->assertEquals(array_keys((array)$relatedtag), array_keys((array)$correlatedtag)); } /** * Test for function tag_cleanup() that is part of tag cron */ public function test_cleanup() { global $DB; $user = $this->getDataGenerator()->create_user(); // Setting tags will create non-official tags 'cat', 'dog' and 'fish'. tag_set('user', $user->id, array('cat', 'dog', 'fish'), 'core', context_user::instance($user->id)->id); $this->assertTrue($DB->record_exists('tag', array('name' => 'cat'))); $this->assertTrue($DB->record_exists('tag', array('name' => 'dog'))); $this->assertTrue($DB->record_exists('tag', array('name' => 'fish'))); // Make tag 'dog' official. $dogtag = tag_get('name', 'dog'); $fishtag = tag_get('name', 'fish'); tag_type_set($dogtag->id, 'official'); // Manually remove the instances pointing on tags 'dog' and 'fish'. $DB->execute('DELETE FROM {tag_instance} WHERE tagid in (?,?)', array($dogtag->id, $fishtag->id)); // Call tag_cleanup(). tag_cleanup(); // Tag 'cat' is still present because it's used. Tag 'dog' is present because it's official. // Tag 'fish' was removed because it is not official and it is no longer used by anybody. $this->assertTrue($DB->record_exists('tag', array('name' => 'cat'))); $this->assertTrue($DB->record_exists('tag', array('name' => 'dog'))); $this->assertFalse($DB->record_exists('tag', array('name' => 'fish'))); // Delete user without using API function. $DB->update_record('user', array('id' => $user->id, 'deleted' => 1)); // Call tag_cleanup(). tag_cleanup(); // Tag 'cat' was now deleted too. $this->assertFalse($DB->record_exists('tag', array('name' => 'cat'))); // Assign tag to non-existing record. Make sure tag was created in the DB. tag_set('course', 1231231, array('bird'), 'core', context_system::instance()->id); $this->assertTrue($DB->record_exists('tag', array('name' => 'bird'))); // Call tag_cleanup(). tag_cleanup(); // Tag 'bird' was now deleted because the related record does not exist in the DB. $this->assertFalse($DB->record_exists('tag', array('name' => 'bird'))); // Now we have a tag instance pointing on 'sometag' tag. $user = $this->getDataGenerator()->create_user(); tag_set('user', $user->id, array('sometag'), 'core', context_user::instance($user->id)->id); $sometag = tag_get('name', 'sometag'); $this->assertTrue($DB->record_exists('tag_instance', array('tagid' => $sometag->id))); // Some hacker removes the tag without using API. $DB->delete_records('tag', array('id' => $sometag->id)); // Call tag_cleanup(). tag_cleanup(); // The tag instances were also removed. $this->assertFalse($DB->record_exists('tag_instance', array('tagid' => $sometag->id))); } }