Table::setName() - Code Metrics - Inspection of "DB->quote() now has special cases for Column and S..." - hfw/db - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( af4849...ba71ff )

by y

created 2019-02-16 07:06 UTC

Table::setName() A

↳ Parent: Project

Complexity

Conditions	2
Paths	2

Size

Total Lines	7
Code Lines	5

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	2
eloc	5
nc	2
nop	1
dl	0
loc	7
rs	10
c	0
b	0
f	0

<?php

namespace Helix\DB;

use Helix\DB;

/**
 * Table manipulation using arrays.
 *
 * Accessing the table as an array produces {@link Column} instances.
 *
 * @immutable
 */
class Table extends AbstractTable {

    /**
     * `[name => Column]`
     *
     * @var Column[]
     */
    protected $columns = [];

    /**
     * @var string
     */
    protected $name;

    /**
     * @param DB $db
     * @param string $name
     * @param string[] $columns
     */
    public function __construct (DB $db, $name, array $columns) {
        parent::__construct($db);
        $this->name = $name;
        foreach ($columns as $column) {
            $this->columns[$column] = new Column($db, $column, $this);
        }
    }

    /**
     * Returns the table name.
     *
     * @return string
     */
    final public function __toString (): string {
        return $this->name;
    }

    /**
     * Executes an `INSERT IGNORE` using arbitrary columns.
     *
     * @param array $values
     * @return int Rows affected.
     */
    public function apply (array $values): int {
        $columns = implode(',', array_keys($values));
        $values = implode(',', $this->db->quote($values));
        $values = implode(',', /** @scrutinizer ignore-type */ $this->db->quote($values));
        switch ($this->db->getDriver()) {
            case 'sqlite':
                return $this->db->exec("INSERT OR IGNORE INTO {$this} ($columns) VALUES ($values)");
            default:
                return $this->db->exec("INSERT IGNORE INTO {$this} ($columns) VALUES ($values)");
        }
    }

    /**
     * Executes a deletion using arbitrary columns.
     *
     * @see DB::match()
     *
     * @param array $match
     * @return int Rows affected.
     */
    public function delete (array $match): int {
        $match = SQL::all($this->db->match($match));
        $match = SQL::all(/** @scrutinizer ignore-type */ $this->db->match($match));
        return $this->db->exec("DELETE FROM {$this} WHERE {$match}");
    }

    /**
     * @return Column[]
     */
    final public function getColumns (): array {
        return $this->columns;
    }

    /**
     * @return string
     */
    final public function getName (): string {
        return $this->name;
    }

    /**
     * Executes an insertion using arbitrary columns.
     *
     * @param array $values
     * @return int Insertion ID.
     */
    public function insert (array $values): int {
        $columns = implode(',', array_keys($values));
        $values = implode(',', $this->db->quote($values));
        $values = implode(',', /** @scrutinizer ignore-type */ $this->db->quote($values));
        $this->db->exec("INSERT INTO {$this} ($columns) VALUES ($values)");
        return $this->db->lastInsertId();

    }

    /**
     * @param string $name
     * @return bool
     */
    public function offsetExists ($name): bool {
        return isset($this->columns[$name]);
    }

    /**
     * @param string $name
     * @return Column
     */
    public function offsetGet ($name): Column {
        return $this->columns[$name];
    }

    /**
     * Returns a selection object for columns in the table.
     *
     * @param string[] $columns Defaults to all columns.
     * @return Select
     */
    public function select (array $columns = []): Select {
        if (!$columns) {
            $columns = $this->columns;
        }
        return new Select($this->db, $this, $columns);
    }

    /**
     * Returns a clone with a different name. Columns are also re-qualified.
     *
     * @param string $name
     * @return Table
     */
    public function setName (string $name) {
        $clone = clone $this;
        $clone->name = $name;
        foreach ($this->columns as $name => $column) {
            $clone->columns[$name] = $column->setQualifier($clone);
        }
        return $clone;
    }

    /**
     * Executes an update using arbitrary columns.
     *
     * @see DB::match()
     *
     * @param array $values
     * @param array $match
     * @return int Rows affected.
     */
    public function update (array $values, array $match): int {
        $values = implode(', ', SQL::isEqual($this->db->quote($values)));
        $values = implode(', ', /** @scrutinizer ignore-type */ SQL::isEqual($this->db->quote($values)));
        $match = SQL::all($this->db->match($match));
        $match = SQL::all(/** @scrutinizer ignore-type */ $this->db->match($match));
        return $this->db->exec("UPDATE {$this} SET {$values} WHERE {$match}");
    }
}

hfw / db

Push — master ( af4849...ba71ff )

Table::setName() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like