FEUsersMigrateCountryTypo3::migrate() - Code Metrics - Inspection of "Removed composer/installers package requirement" - aimeos/ai-typo3 - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 49f6b0...199364 )

by Aimeos

created 2021-06-15 06:41 UTC

FEUsersMigrateCountryTypo3::migrate() A

↳ Parent: FEUsersMigrateCountryTypo3

Complexity

Conditions	4
Paths	2

Size

Total Lines	19
Code Lines	9

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
eloc	9
c	1
b	0
f	0
dl	0
loc	19
rs	9.9666
cc	4
nc	2
nop	0

<?php

/**
 * @license LGPLv3, http://opensource.org/licenses/LGPL-3.0
 * @copyright Aimeos (aimeos.org), 2017-2021
 */


namespace Aimeos\MW\Setup\Task;


/**
 * Adds siteid column to fe_users table.
 */
class FEUsersMigrateCountryTypo3 extends \Aimeos\MW\Setup\Task\Base
{
	/**
	 * Returns the list of task names which depends on this task.
	 *
	 * @return string[] List of task names
	 */
	public function getPostDependencies() : array
	{
		return ['TablesCreateMShop'];
	}


	/**
	 * Add column siteid to fe_users table.
	 *
	 */
	public function migrate()
	{
		$this->msg( sprintf( 'Migrating "%1$s" column in "%2$s" table', 'static_info_country', 'fe_users' ), 0 );

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

		if( $schema->tableExists( 'fe_users' ) === true && $schema->tableExists( 'static_countries' ) === true
			&& $schema->columnExists( 'fe_users', 'static_info_country' ) === true )
		{
			$stmt = 'UPDATE fe_users SET static_info_country = (
				SELECT cn_iso_2 FROM static_countries WHERE cn_iso_3 = static_info_country
			) WHERE LENGTH(static_info_country) = 3';

			$this->execute( $stmt, 'db-customer' );
			$this->status( 'done' );
		}
		else
		{
			$this->status( 'OK' );
		}
	}
}


1			<?php
2
3			/**
4			* @license LGPLv3, http://opensource.org/licenses/LGPL-3.0
5			* @copyright Aimeos (aimeos.org), 2017-2021
6			*/
7
8
9			namespace Aimeos\MW\Setup\Task;
10
11
12			/**
13			* Adds siteid column to fe_users table.
14			*/
15			class FEUsersMigrateCountryTypo3 extends \Aimeos\MW\Setup\Task\Base
16			{
17			/**
18			* Returns the list of task names which depends on this task.
19			*
20			* @return string[] List of task names
21			*/
22			public function getPostDependencies() : array
23			{
24			return ['TablesCreateMShop'];
25			}
26
27
28			/**
29			* Add column siteid to fe_users table.
30			*
31			*/
32			public function migrate()
33			{
34			$this->msg( sprintf( 'Migrating "%1$s" column in "%2$s" table', 'static_info_country', 'fe_users' ), 0 );
35
36			$schema = $this->getSchema( 'db-customer' );
37
38			if( $schema->tableExists( 'fe_users' ) === true && $schema->tableExists( 'static_countries' ) === true
39			&& $schema->columnExists( 'fe_users', 'static_info_country' ) === true )
40			{
41			$stmt = 'UPDATE fe_users SET static_info_country = (
42			SELECT cn_iso_2 FROM static_countries WHERE cn_iso_3 = static_info_country
43			) WHERE LENGTH(static_info_country) = 3';
44
45			$this->execute( $stmt, 'db-customer' );
46			$this->status( 'done' );
47			}
48			else
49			{
50			$this->status( 'OK' );
51			}
52			}
53			}
54

aimeos / ai-typo3

Push — master ( 49f6b0...199364 )

FEUsersMigrateCountryTypo3::migrate() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like