Janisbiz\LightOrm\Dms\MySQL\QueryBuilder\Traits\OnDuplicateKeyUpdateTrait

Complexity

Total Complexity

4

Size/Duplication

Total Lines	55
Duplicated Lines	0 %

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	buildOnDuplicateKeyUpdateQueryPart()	0	5	2
A	onDuplicateKeyUpdate()	0	31	2

<?php declare(strict_types=1);

namespace Janisbiz\LightOrm\Dms\MySQL\QueryBuilder\Traits;

use Janisbiz\LightOrm\Dms\MySQL\QueryBuilder\QueryBuilderException;

trait OnDuplicateKeyUpdateTrait
{
    /**
     * @var array
     */
    protected $onDuplicateKeyUpdate = [];

    /**
     * @param string $column
     * @param null|int|string|double $value
     *
     * @throws QueryBuilderException
     * @return $this
     */
    public function onDuplicateKeyUpdate(string $column, $value)
    {
        if (empty($column)) {
            throw new QueryBuilderException('You must pass $column to onDuplicateKeyUpdate function!');
        }

        $columnNormalised = \sprintf(
            '%s_OnDuplicateKeyUpdate',
            \implode(
                '_',
                \array_map(
                    function ($columnPart) {
                        return \mb_convert_case($columnPart, MB_CASE_TITLE);
                    },
                    \explode('.', $column)
                )
            )
        );

        $this->onDuplicateKeyUpdate = \array_merge(
            $this->onDuplicateKeyUpdate,
            [
                $column => \sprintf('%s = :%s', $column, $columnNormalised),
            ]
        );

        $this->bindValue([

It seems like bindValue() must be provided by classes using this trait. How about adding it as abstract method to this trait?

            $columnNormalised => $value,
        ]);

        return $this;
    }

    /**
     * @return null|string
     */
    protected function buildOnDuplicateKeyUpdateQueryPart(): ?string
    {
        return empty($this->onDuplicateKeyUpdate)
            ? null
            : \sprintf('ON DUPLICATE KEY UPDATE %s', \implode(', ', $this->onDuplicateKeyUpdate))
        ;
    }
}