vse\similartopics\migrations\release_1_4_0_data

Complexity

Total Complexity

10

Size/Duplication

Total Lines	70
Duplicated Lines	0 %

Importance

Changes	2
Bugs	0	Features	0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	convert_similar_topic_forums()	0	20	3
A	migrate_config_data()	0	17	3
A	effectively_installed()	0	3	2
A	depends_on()	0	3	1
A	update_data()	0	8	1

<?php
/**
 *
 * Precise Similar Topics
 *
 * @copyright (c) 2016 Matt Friedman
 * @license GNU General Public License, version 2 (GPL-2.0)
 *
 */

namespace vse\similartopics\migrations;

class release_1_4_0_data extends \phpbb\db\migration\migration

The type phpbb\db\migration\migration was not found. Maybe you did not declare it correctly or list all dependencies?

{
	public function effectively_installed()
	{
		return !$this->config->offsetExists('similar_topics_hide') && !$this->config->offsetExists('similar_topics_ignore');
	}

	public static function depends_on()
	{
		return array('\vse\similartopics\migrations\release_1_4_0_schema');
	}

	public function update_data()
	{
		return array(
			array('custom', array(array($this, 'migrate_config_data'))),
			array('custom', array(array($this, 'convert_similar_topic_forums'))),

			array('config.remove', array('similar_topics_hide')),
			array('config.remove', array('similar_topics_ignore')),
		);
	}

	/**
	 * Convert data stored in configs to new columns in the forum table
	 */
	public function migrate_config_data()
	{
		$old_configs = array(
			'similar_topics_hide',
			'similar_topics_ignore',
		);

		foreach ($old_configs as $column)
		{
			if (!empty($this->config[$column]))
			{
				$forum_ids = explode(',', $this->config[$column]);

				$sql = 'UPDATE ' . FORUMS_TABLE . "

The constant vse\similartopics\migrations\FORUMS_TABLE was not found. Maybe you did not declare it correctly or list all dependencies?

					SET $column = 1
					WHERE " . $this->db->sql_in_set('forum_id', $forum_ids);
				$this->db->sql_query($sql);
			}
		}
	}

	/**
	 * Convert imploded string data into json encoded data
	 */
	public function convert_similar_topic_forums()
	{
		$sql = 'SELECT forum_id, similar_topic_forums
			FROM ' . FORUMS_TABLE;

The constant vse\similartopics\migrations\FORUMS_TABLE was not found. Maybe you did not declare it correctly or list all dependencies?

		$result = $this->db->sql_query($sql);

		while ($row = $this->db->sql_fetchrow($result))
		{
			if (!empty($row['similar_topic_forums']))
			{
				$forum_ids = explode(',', $row['similar_topic_forums']);
				$forum_ids = json_encode($forum_ids, JSON_NUMERIC_CHECK);

				$sql = 'UPDATE ' . FORUMS_TABLE . "
					SET similar_topic_forums = '" . $this->db->sql_escape($forum_ids) . "'
					WHERE forum_id = " . (int) $row['forum_id'];
				$this->db->sql_query($sql);
			}
		}
		$this->db->sql_freeresult($result);
	}
}