Ejemplos de robertheim\topictags\service tags_manager::remove_all_tags_from_topic en PHP

Ejemplo n.º 1

Archivo: tags_manager_test.php Proyecto: NuLeaf/phpbb-ext-tags

    public function test_remove_all_tags_from_topic()
    {
        global $table_prefix;
        $topic_id = 1;
        // there is one tag assigned to the topic
        $result = $this->db->sql_query('SELECT COUNT(*) as count
			FROM ' . $table_prefix . tables::TOPICTAGS . '
			WHERE topic_id=' . $topic_id);
        $assigned_tags_count = $this->db->sql_fetchfield('count');
        $this->assertEquals(1, $assigned_tags_count);
        // there exists one unused tag
        $result = $this->db->sql_query('SELECT COUNT(*) as count
			FROM ' . $table_prefix . tables::TAGS . '
			WHERE id=2');
        $assigned_tags_count = $this->db->sql_fetchfield('count');
        $this->assertEquals(1, $assigned_tags_count);
        $delete_unused_tags = true;
        $this->tags_manager->remove_all_tags_from_topic($topic_id, $delete_unused_tags);
        // there is no tag assigned to the topic
        $result = $this->db->sql_query('SELECT COUNT(*) as count
			FROM ' . $table_prefix . tables::TOPICTAGS . '
			WHERE topic_id=' . $topic_id);
        $assigned_tags_count = $this->db->sql_fetchfield('count');
        $this->assertEquals(0, $assigned_tags_count);
        // the unused tag is deleted
        $result = $this->db->sql_query('SELECT COUNT(*) as count
			FROM ' . $table_prefix . tables::TAGS . '
			WHERE id=2');
        $assigned_tags_count = $this->db->sql_fetchfield('count');
        $this->assertEquals(0, $assigned_tags_count);
    }