SimpleCrud\Queries\Mysql\Update

Complexity

Total Complexity

7

Size/Duplication

Total Lines	80
Duplicated Lines	25 %

Coupling/Cohesion

Components	2
Dependencies	4

Importance

Changes	10
Bugs	1	Features	0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	data()	0	6	1
A	marks()	0	6	1
A	__invoke()	10	10	2
A	__toString()	0	10	1
A	buildFields()	10	10	2

<?php

namespace SimpleCrud\Queries\Mysql;

use SimpleCrud\Queries\BaseQuery;
use SimpleCrud\Queries\SelectionTrait;
use SimpleCrud\Entity;
use PDOStatement;

/**
 * Manages a database update query.
 */
class Update extends BaseQuery
{
    use SelectionTrait;

    protected $data = [];

    /**
     * Set the data to update.
     *
     * @param array $data
     *
     * @return self
     */
    public function data(array $data)
    {
        $this->data = $this->entity->prepareDataToDatabase($data, false);

        return $this;
    }

    /**
     * Adds new marks to the query.
     *
     * @param array $marks
     *
     * @return self
     */
    public function marks(array $marks)
    {
        $this->marks += $marks;

        return $this;
    }

    /**
     * {@inheritdoc}
     */
    public function __invoke()

This method seems to be duplicated in your project.

    {
        $marks = $this->marks;

        foreach ($this->data as $field => $value) {
            $marks[":__{$field}"] = $value;
        }

        return $this->entity->getDb()->execute((string) $this, $marks);
    }

    /**
     * {@inheritdoc}
     */
    public function __toString()
    {
        $query = "UPDATE `{$this->entity->name}`";
        $query .= ' SET '.static::buildFields(array_keys($this->data));

        $query .= $this->whereToString();
        $query .= $this->limitToString();

        return $query;
    }

    /**
     * Generates the data part of a UPDATE query.
     *
     * @param array $fields
     *
     * @return string
     */
    protected static function buildFields(array $fields)

This method seems to be duplicated in your project.

    {
        $query = [];

        foreach ($fields as $field) {
            $query[] = "`{$field}` = :__{$field}";
        }

        return implode(', ', $query);
    }
}