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:36 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

Metric	Value
dl	0
loc	13
rs	9.4285
c	0
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\m1_initial_schema',
			'\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(
29			'\phpbb\ads\migrations\v10x\m1_initial_schema',
30			'\phpbb\ads\migrations\v10x\m3_template_locations_schema'
31			);
32			}
33
34			/**
35			* Add the indexes
36			*
37			* @return array Array of altered table schema
38			* @access public
39			*/
40			public function update_schema()
41			{
42			return array(
43			'add_index' => array(
44			$this->table_prefix . 'ads' => array(
45			'ad_enabled' => array('ad_enabled'), // index used in ad\manager::get_ads
46			),
47			$this->table_prefix . 'ad_locations' => array(
48			'location_id' => array('location_id'), // index used in ad\manager::get_ads
49			),
50			),
51			);
52			}
53
54			/**
55			* Drop the indexes
56			*
57			* @return array Array of altered table schema
58			* @access public
59			*/
60			public function revert_schema()
61			{
62			return array(
63			'drop_keys' => array(
64			$this->table_prefix . 'ad_locations' => array(
65			'location_id',
66			),
67			$this->table_prefix . 'ads' => array(
68			'ad_enabled',
69			),
70			),
71			);
72			}
73			}
74

phpbb-extensions / ad-management

Pull Request — master (#24)

m4_indexes::update_schema() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like