CustomerRenameGroup::up() - Code Metrics - Inspection of "Moved customer/group manager/item to primary group..." - aimeos/aimeos-core - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( ae8cc8...b4d665 )

by Aimeos

created 2023-10-20 10:34 UTC

CustomerRenameGroup::up() A

↳ Parent: CustomerRenameGroup

Complexity

Conditions	2
Paths	2

Size

Total Lines	15
Code Lines	8

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
eloc	8
c	1
b	0
f	0
dl	0
loc	15
rs	10
cc	2
nc	2
nop	0

<?php

/**
 * @license LGPLv3, https://opensource.org/licenses/LGPL-3.0
 * @copyright Aimeos (aimeos.org), 2023
 */


namespace Aimeos\Upscheme\Task;


class CustomerRenameGroup extends Base
{
	public function before() : array
	{
		return ['Customer', 'Group'];
	}


	public function up()
	{
		$this->info( 'Rename mshop_customer_group to mshop_group', 'vv' );

		$db = $this->db( 'db-customer' );

		if( $db->hasTable( 'mshop_customer_group' ) )
		{
			$db->dropIndex( 'mshop_customer_group', 'pk_mscusgr_id' )
				->dropIndex( 'mshop_customer_group', 'unq_mscusgr_code_sid' )
				->dropIndex( 'mshop_customer_group', 'idx_mscusgr_label_sid' )
				->renameTable( 'mshop_customer_group', 'mshop_group' );
		}

		$this->update( 'mshop_customer_list' );
	}


	protected function update( string $table )
	{
		$db = $this->db( 'db-customer' );

		$result = $db->query( 'SELECT
			' . $db->qi( 'id' ) . ',
			' . $db->qi( 'type' ) . ',
			' . $db->qi( 'refid' ) . '
			FROM ' . $db->qi( $table ) . '
			WHERE domain = ?',
			['customer/group']
		);

		foreach( $result->iterateAssociative() as $row )
		{
			$db->update(
				'mshop_customer_list',
				['key' => 'group|' . $row['type'] . '|' . $row['refid'], 'domain' => 'group'],
				['id' => $row['id']]
			);
		}
	}
}


1			<?php
2
3			/**
4			* @license LGPLv3, https://opensource.org/licenses/LGPL-3.0
5			* @copyright Aimeos (aimeos.org), 2023
6			*/
7
8
9			namespace Aimeos\Upscheme\Task;
10
11
12			class CustomerRenameGroup extends Base
13			{
14			public function before() : array
15			{
16			return ['Customer', 'Group'];
17			}
18
19
20			public function up()
21			{
22			$this->info( 'Rename mshop_customer_group to mshop_group', 'vv' );
23
24			$db = $this->db( 'db-customer' );
25
26			if( $db->hasTable( 'mshop_customer_group' ) )
27			{
28			$db->dropIndex( 'mshop_customer_group', 'pk_mscusgr_id' )
29			->dropIndex( 'mshop_customer_group', 'unq_mscusgr_code_sid' )
30			->dropIndex( 'mshop_customer_group', 'idx_mscusgr_label_sid' )
31			->renameTable( 'mshop_customer_group', 'mshop_group' );
32			}
33
34			$this->update( 'mshop_customer_list' );
35			}
36
37
38			protected function update( string $table )
39			{
40			$db = $this->db( 'db-customer' );
41
42			$result = $db->query( 'SELECT
43			' . $db->qi( 'id' ) . ',
44			' . $db->qi( 'type' ) . ',
45			' . $db->qi( 'refid' ) . '
46			FROM ' . $db->qi( $table ) . '
47			WHERE domain = ?',
48			['customer/group']
49			);
50
51			foreach( $result->iterateAssociative() as $row )
52			{
53			$db->update(
54			'mshop_customer_list',
55			['key' => 'group\|' . $row['type'] . '\|' . $row['refid'], 'domain' => 'group'],
56			['id' => $row['id']]
57			);
58			}
59			}
60			}
61

aimeos / aimeos-core

Push — master ( ae8cc8...b4d665 )

CustomerRenameGroup::up() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like