Aimeos\MW\Setup\Task\ServiceUniqueCode

Complexity

Total Complexity

7

Size/Duplication

Total Lines	71
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	5

Importance

Changes	1
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	getPreDependencies()	0	4	1
A	getPostDependencies()	0	4	1
B	migrate()	0	32	5

<?php

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


namespace Aimeos\MW\Setup\Task;


/**
 * Ensures service codes are unique
 */
class ServiceUniqueCode extends \Aimeos\MW\Setup\Task\Base
{
	private $select = '
		SELECT "code" FROM "mshop_service" GROUP BY "code" HAVING COUNT("code") > 1
	';
	private $update = '
		UPDATE "mshop_service" SET "code"=? WHERE "code"=?
		AND (SELECT "id" FROM "mshop_service_type" WHERE "code"=\'delivery\')
	';


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


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


	/**
	 * Renames all order tables if they exist.
	 *
	 * @param array $stmts Associative array of tables names and lists of SQL statements to execute.

There is no parameter named $stmts. Was it maybe removed?

	 */
	public function migrate()
	{
		$this->msg( 'Ensure unique codes in mshop_service', 0 );
		$schema = $this->getSchema( 'db-service' );
		$table = 'mshop_service';

		if( $schema->tableExists( $table ) && $schema->columnExists( $table, 'code' ) )
		{
			$list = [];
			$conn = $this->getConnection( 'db-service' );
			$result = $conn->create( $this->select )->execute();

			while( ( $row = $result->fetch() ) !== false ) {
				$list[] = $row['code'];
			}
			$result->finish();

			$stmt = $conn->create( $this->update );
			foreach( $list as $code )
			{
				$stmt->bind( 1, $code );
				$stmt->bind( 2, $code . '2' );
				$stmt->execute()->finish();
			}

			$this->status( 'done' );
		}
		else
		{
			$this->status( 'OK' );
		}
	}
}