vse\similartopics\migrations\release_1_5_x\postgres_index

Complexity

Total Complexity

11

Size/Duplication

Total Lines	78
Duplicated Lines	11.54 %

Coupling/Cohesion

Components	1
Dependencies	1

Importance

Changes	2
Bugs	0	Features	0

8 Methods

Rating	Name	Duplication	Size	Complexity
A	depends_on()	0	4	1
A	update_data()	0	11	1
A	revert_data()	9	9	1
A	create_postgres_index()	0	6	1
A	drop_postgres_changes()	0	10	2
A	get_driver()	0	4	1
A	get_ts_name()	0	4	2
A	effectively_installed()	0	4	2

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

namespace vse\similartopics\migrations\release_1_5_x;

class postgres_index extends \phpbb\db\migration\migration
{
	/**
	 * Do not run this migration if the DB is not PostgreSQL
	 *
	 * @return bool
	 */
	public function effectively_installed()
	{
		return $this->db->get_sql_layer() !== 'postgres' || $this->config->offsetExists('pst_postgres_ts_name');
	}

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

	public function update_data()
	{
		return array(
			array('if', array(
				$this->db->get_sql_layer() === 'postgres',
				array('custom', array(array($this, 'create_postgres_index'))),
			)),
			array('config.update', array('similar_topics_sense', 1)),
			array('config.add', array('pst_postgres_ts_name', $this->get_ts_name())),
		);
	}

	public function revert_data()
	{
		return array(
			array('if', array(
				$this->db->get_sql_layer() === 'postgres',
				array('custom', array(array($this, 'drop_postgres_changes'))),
			)),
		);
	}

	/**
	 * Create PostgreSQL FULLTEXT index for the topic_title
	 */
	public function create_postgres_index()
	{
		$driver = $this->get_driver();
		$driver->set_ts_name($this->get_ts_name())
			->create_fulltext_index();
	}

	/**
	 * Drop the PostgreSQL FULLTEXT index on phpbb_topics.topic_title
	 */
	public function drop_postgres_changes()
	{
		$driver = $this->get_driver();

		foreach ($driver->get_pg_indexes() as $index)
		{
			$sql = 'DROP INDEX ' . $index;
			$this->db->sql_query($sql);
		}
	}

	/**
	 * Get an instance of the similartopics POSTGRES driver
	 *
	 * @return \vse\similartopics\driver\postgres
	 */
	protected function get_driver()
	{
		return new \vse\similartopics\driver\postgres($this->db, $this->config);
	}

	protected function get_ts_name()
	{
		return $this->config->offsetExists('fulltext_postgres_ts_name') ? $this->config['fulltext_postgres_ts_name'] : 'simple';
	}
}