phpbb\ideas\migrations\m11_reparse_old_ideas

Complexity

Total Complexity

8

Size/Duplication

Total Lines	100
Duplicated Lines	0 %

Importance

Changes	3
Bugs	0	Features	0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	depends_on()	0	8	1
A	effectively_installed()	0	6	2
A	reparse()	0	38	3
A	update_data()	0	4	1
A	bbcode_exists()	0	11	1

<?php
/**
 *
 * Ideas extension for the phpBB Forum Software package.
 *
 * @copyright (c) phpBB Limited <https://www.phpbb.com>
 * @license GNU General Public License, version 2 (GPL-2.0)
 *
 */

namespace phpbb\ideas\migrations;

class m11_reparse_old_ideas extends \phpbb\db\migration\container_aware_migration
{
	/**
	 * {@inheritDoc}
	 */
	public static function depends_on()
	{
		return [
			'\phpbb\ideas\migrations\m1_initial_schema',
			'\phpbb\ideas\migrations\m6_migrate_old_tables',
			'\phpbb\ideas\migrations\m7_drop_old_tables',
			'\phpbb\ideas\migrations\m8_implemented_version',
			'\phpbb\ideas\migrations\m10_update_idea_schema',
		];
	}

	/**
	 * {@inheritDoc}
	 */
	public function effectively_installed()
	{
		/** @var \phpbb\textreparser\manager $reparser_manager */
		$reparser_manager = $this->container->get('text_reparser.manager');

		return !empty($reparser_manager->get_resume_data('phpbb.ideas.text_reparser.clean_old_ideas') || !$this->bbcode_exists('idea'));
	}

	/**
	 * @inheritDoc
	 */
	public function update_data()
	{
		return [
			['custom', [[$this, 'reparse']]],
		];
	}

	/**
	 * Run the clean old ideas reparser
	 *
	 * @param int $current An idea identifier
	 * @return bool|int An idea identifier or true if finished
	 */
	public function reparse($current = 0)
	{
		/** @var \phpbb\textreparser\manager $reparser_manager */
		$reparser_manager = $this->container->get('text_reparser.manager');

		/** @var \phpbb\textformatter\s9e\utils $text_formatter_utils */
		$text_formatter_utils = $this->container->get('text_formatter.utils');

		$reparser = new \phpbb\ideas\textreparser\plugins\clean_old_ideas(
			$this->db,
			$text_formatter_utils,
			$this->container->getParameter('tables.posts'),
			$this->container->getParameter('tables.topics'),
			$this->container->getParameter('core.table_prefix') . 'ideas_ideas'
		);

		if (empty($current))
		{
			$current = $reparser->get_max_id();
		}

		$limit = 50; // let's keep the reparsing conservative
		$start = max(1, $current + 1 - $limit);
		$end   = max(1, $current);

		$reparser->reparse_range($start, $end);

		$current = $start - 1;

		if ($current === 0)
		{
			// Prevent CLI command from running this reparser again
			$reparser_manager->update_resume_data('phpbb.ideas.text_reparser.clean_old_ideas', 1, 0, $limit);

			return true;
		}

		return $current;
	}

	/**
	 * Check if a bbcode exists
	 *
	 * @param  string $tag BBCode's tag
	 * @return bool        True if bbcode exists, false if not
	 */
	public function bbcode_exists($tag)
	{
		$sql = 'SELECT bbcode_id
			FROM ' . $this->table_prefix . "bbcodes
			WHERE LOWER(bbcode_tag) = '" . $this->db->sql_escape(strtolower($tag)) . "'
			OR LOWER(bbcode_tag) = '" . $this->db->sql_escape(strtolower($tag)) . "='";
		$result = $this->db->sql_query_limit($sql, 1);
		$bbcode_id = $this->db->sql_fetchfield('bbcode_id');
		$this->db->sql_freeresult($result);

		return $bbcode_id !== false;
	}
}