Dynamic\Products\Task\ManyImageRelationTask

Complexity

Total Complexity

5

Size/Duplication

Total Lines	40
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	updateRelationTable()	0	6	2
A	yieldProductImages()	0	4	2
A	run()	0	3	1

<?php

namespace Dynamic\Products\Task;

use SilverStripe\Dev\BuildTask;
use SilverStripe\ORM\DB;

/**
 * Class ManyImageRelationTask
 * @package Dynamic\Products\Task
 */
class ManyImageRelationTask extends BuildTask
{
    /**
     * @var string
     */
    protected $title = 'Product Image Relation Update Task';

    /**
     * @var string
     */
    private static $segment = 'product-image-relation-update-task';

The private property $segment is not used, and could be removed.

    /**
     * @param \SilverStripe\Control\HTTPRequest $request
     */
    public function run($request)
    {
        $this->updateRelationTable();
    }

    /**
     *
     */
    protected function updateRelationTable()
    {
        foreach ($this->yieldProductImages() as $record) {
            DB::prepared_query(
                'UPDATE `Product_Images` SET `FileID` = ? WHERE `ID` = ?',
                [$record['ImageID'], $record['ID']]
            );
        }
    }

    /**
     * @return \Generator
     */
    protected function yieldProductImages()
    {
        foreach (DB::query('SELECT * FROM `Product_Images`') as $record) {
            yield $record;
        }
    }
}