m4_indexes::update_schema() - Code Metrics - Inspection of "#20: Rename admanagement to ads" - phpbb-extensions/ad-management - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Pull Request — master (#24)

by Jakub

created 2017-06-13 08:14 UTC

m4_indexes::update_schema() A

↳ Parent: m4_indexes

Complexity

Conditions	1
Paths	1

Size

Total Lines	13
Code Lines	7

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
dl	0
loc	13
rs	9.4285
c	1
b	0
f	0
cc	1
eloc	7
nc	1
nop	0

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

namespace phpbb\ads\migrations\v10x;

class m4_indexes extends \phpbb\db\migration\migration
{
	/**
	* {@inheritDoc}
	*/
	public function effectively_installed()
	{
		return $this->db_tools->sql_index_exists($this->table_prefix . 'ads', 'ad_enabled');
	}

	/**
	* {@inheritDoc}
	*/
	static public function depends_on()
	{
		return array('\phpbb\ads\migrations\v10x\m3_template_locations_schema');
	}

	/**
	* Add the indexes
	*
	* @return array Array of altered table schema
	* @access public
	*/
	public function update_schema()
	{
		return array(
			'add_index'	=> array(
				$this->table_prefix . 'ads'	=> array(
					'ad_enabled'	=> array('ad_enabled'), // index used in ad\manager::get_ads
				),
				$this->table_prefix . 'ad_locations'	=> array(
					'location_id'	=> array('location_id'), // index used in ad\manager::get_ads
				),
			),
		);
	}

	/**
	* Drop the indexes
	*
	* @return array Array of altered table schema
	* @access public
	*/
	public function revert_schema()
	{
		return array(
			'drop_keys'	=> array(
				$this->table_prefix . 'ad_locations' => array(
					'location_id',
				),
				$this->table_prefix . 'ads' => array(
					'ad_enabled',
				),
			),
		);
	}
}


1			<?php
2			/**
3			*
4			* Advertisement management. An extension for the phpBB Forum Software package.
5			*
6			* @copyright (c) 2017 phpBB Limited <https://www.phpbb.com>
7			* @license GNU General Public License, version 2 (GPL-2.0)
8			*
9			*/
10
11			namespace phpbb\ads\migrations\v10x;
12
13			class m4_indexes extends \phpbb\db\migration\migration
14			{
15			/**
16			* {@inheritDoc}
17			*/
18			public function effectively_installed()
19			{
20			return $this->db_tools->sql_index_exists($this->table_prefix . 'ads', 'ad_enabled');
21			}
22
23			/**
24			* {@inheritDoc}
25			*/
26			static public function depends_on()
27			{
28			return array('\phpbb\ads\migrations\v10x\m3_template_locations_schema');
29			}
30
31			/**
32			* Add the indexes
33			*
34			* @return array Array of altered table schema
35			* @access public
36			*/
37			public function update_schema()
38			{
39			return array(
40			'add_index' => array(
41			$this->table_prefix . 'ads' => array(
42			'ad_enabled' => array('ad_enabled'), // index used in ad\manager::get_ads
43			),
44			$this->table_prefix . 'ad_locations' => array(
45			'location_id' => array('location_id'), // index used in ad\manager::get_ads
46			),
47			),
48			);
49			}
50
51			/**
52			* Drop the indexes
53			*
54			* @return array Array of altered table schema
55			* @access public
56			*/
57			public function revert_schema()
58			{
59			return array(
60			'drop_keys' => array(
61			$this->table_prefix . 'ad_locations' => array(
62			'location_id',
63			),
64			$this->table_prefix . 'ads' => array(
65			'ad_enabled',
66			),
67			),
68			);
69			}
70			}
71

phpbb-extensions / ad-management

Pull Request — master (#24)

m4_indexes::update_schema() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like