Aimeos\Upscheme\Task\PriceMigrateTaxRateName

Complexity

Total Complexity

4

Size/Duplication

Total Lines	28
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	up()	0	14	2
A	after()	0	3	1
A	before()	0	3	1

<?php

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


namespace Aimeos\Upscheme\Task;


class PriceMigrateTaxRateName extends Base
{
	public function before() : array
	{
		return ['Price'];
	}


	public function after() : array
	{
		return ['PriceMigrateTaxrate'];
	}


	public function up()
	{
		$db = $this->db( 'db-price' );

		if( !$db->hasTable( 'mshop_price' ) ) {
			return;
		}

		$this->info( 'Migrating taxrate name in price table', 'v' );

		$db->stmt()->update( 'mshop_price' )
			->set( 'taxrate', 'REPLACE(' . $db->qi( 'taxrate' ) . ', \'{"":\', \'{"tax":\')' )
			->where( $db->qi( 'taxrate' ) . ' LIKE \'{"":%\'' )
			->execute();
	}
}