CustomerRemoveLostUserDataLaravel::migrate() - Code Metrics - Inspection of "Improved indexes for multi-site setups" - aimeos/ai-laravel - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( eb8cff...7d9e8c )

by Aimeos

created 2021-04-08 10:37 UTC

CustomerRemoveLostUserDataLaravel::migrate() A

↳ Parent: CustomerRemoveLostUserDataLaravel

Complexity

Conditions	6
Paths	4

Size

Total Lines	21
Code Lines	11

Duplication

Lines	0
Ratio	0 %

Importance

Changes	3
Bugs	0	Features	0

Metric	Value
cc	6
eloc	11
c	3
b	0
f	0
nc	4
nop	0
dl	0
loc	21
rs	9.2222

<?php

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


namespace Aimeos\MW\Setup\Task;


/**
 * Removes address and list records without users entry
 */
class CustomerRemoveLostUserDataLaravel extends \Aimeos\MW\Setup\Task\Base
{
	private $sql = [
		'users_address' => [
			'fk_lvuad_pid' => 'DELETE FROM "users_address" WHERE NOT EXISTS ( SELECT "id" FROM "users" AS u WHERE "parentid"=u."id" )'
		],
		'users_list' => [
			'fk_lvuli_pid' => 'DELETE FROM "users_list" WHERE NOT EXISTS ( SELECT "id" FROM "users" AS u WHERE "parentid"=u."id" )'
		],
		'users_property' => [
			'fk_lvupr_pid' => 'DELETE FROM "users_property" WHERE NOT EXISTS ( SELECT "id" FROM "users" AS u WHERE "parentid"=u."id" )'
		],
	];


	/**
	 * Returns the list of task names which depends on this task.
	 *
	 * @return string[] List of task names
	 */
	public function getPostDependencies() : array
	{
		return ['TablesCreateMShop'];
	}


	/**
	 * Migrate database schema
	 */
	public function migrate()
	{
		$this->msg( 'Remove left over Laravel user references', 0, '' );

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

		foreach( $this->sql as $table => $map )
		{
			foreach( $map as $constraint => $sql )
			{
				$this->msg( sprintf( 'Remove records from %1$s', $table ), 1 );

				if( $schema->tableExists( 'fe_users' ) && $schema->tableExists( $table )
					&& $schema->constraintExists( $table, $constraint ) === false
				) {
					$this->execute( $sql, '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), 2018-2021
6			*/
7
8
9			namespace Aimeos\MW\Setup\Task;
10
11
12			/**
13			* Removes address and list records without users entry
14			*/
15			class CustomerRemoveLostUserDataLaravel extends \Aimeos\MW\Setup\Task\Base
16			{
17			private $sql = [
18			'users_address' => [
19			'fk_lvuad_pid' => 'DELETE FROM "users_address" WHERE NOT EXISTS ( SELECT "id" FROM "users" AS u WHERE "parentid"=u."id" )'
20			],
21			'users_list' => [
22			'fk_lvuli_pid' => 'DELETE FROM "users_list" WHERE NOT EXISTS ( SELECT "id" FROM "users" AS u WHERE "parentid"=u."id" )'
23			],
24			'users_property' => [
25			'fk_lvupr_pid' => 'DELETE FROM "users_property" WHERE NOT EXISTS ( SELECT "id" FROM "users" AS u WHERE "parentid"=u."id" )'
26			],
27			];
28
29
30			/**
31			* Returns the list of task names which depends on this task.
32			*
33			* @return string[] List of task names
34			*/
35			public function getPostDependencies() : array
36			{
37			return ['TablesCreateMShop'];
38			}
39
40
41			/**
42			* Migrate database schema
43			*/
44			public function migrate()
45			{
46			$this->msg( 'Remove left over Laravel user references', 0, '' );
47
48			$schema = $this->getSchema( 'db-customer' );
49
50			foreach( $this->sql as $table => $map )
51			{
52			foreach( $map as $constraint => $sql )
53			{
54			$this->msg( sprintf( 'Remove records from %1$s', $table ), 1 );
55
56			if( $schema->tableExists( 'fe_users' ) && $schema->tableExists( $table )
57			&& $schema->constraintExists( $table, $constraint ) === false
58			) {
59			$this->execute( $sql, 'db-customer' );
60			$this->status( 'done' );
61			}
62			else
63			{
64			$this->status( 'OK' );
65			}
66			}
67			}
68			}
69			}
70

aimeos / ai-laravel

Push — master ( eb8cff...7d9e8c )

CustomerRemoveLostUserDataLaravel::migrate() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like