Aimeos\Upscheme\Task\PriceMigrateTaxrate::up()

Complexity

Conditions	3
Paths	3

Size

Total Lines	28
Code Lines	15

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

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

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

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

		$dbm = $this->context()->db();

The method context() does not exist on Aimeos\Upscheme\Task\PriceMigrateTaxrate. Since you implemented __call, consider adding a @method annotation.

		$conn = $dbm->acquire( 'db-price' );

		$select = 'SELECT "id", "taxrate" FROM "mshop_price" WHERE "taxrate" NOT LIKE \'{%\'';
		$update = 'UPDATE "mshop_price" SET "taxrate" = ? WHERE "id" = ?';

		$stmt = $conn->create( $update );
		$result = $conn->create( $select )->execute();

		while( ( $row = $result->fetch() ) !== null )
		{
			$stmt->bind( 1, json_encode( ['' => $row['taxrate']], JSON_FORCE_OBJECT ) );
			$stmt->bind( 2, $row['id'], \Aimeos\MW\DB\Statement\Base::PARAM_INT );

			$stmt->execute()->finish();
		}

		$dbm->release( $conn, 'db-price' );
	}