kalanis\nested_tree\Sources\PDO\MySql::add()

Complexity

Conditions	17
Paths	300

Size

Total Lines	76
Code Lines	42

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	38
CRAP Score	17

Importance

Changes	1
Bugs	0	Features	0

<?php
    public function add(Support\Node $node, ?Support\Conditions $where = null) : Support\Node
    {
        // Insert itself
        $sql = 'INSERT INTO `' . $this->settings->tableName . '`';
        $lookup = [];
        $pairs = [];
        foreach ((array) $node as $column => $value) {
            if (
                !is_numeric($column)
                && !$this->isColumnNameFromBasic($column)
                && !$this->isColumnNameFromSpecial($column)
                && $this->allowColumn($this->settings, $column)
                && $this->allowColumnWithEmptyValue($this->settings, $column, $value)
            ) {
                $translateColumn = $this->translateColumn($this->settings, $column);
                if (!is_null($translateColumn)) {
                    $lookup['`' . $translateColumn . '`'] = ':' . $translateColumn;
                    $pairs[':' . $translateColumn] = $value;
                }
            }
        }
        if (empty($lookup)) {
            // @codeCoverageIgnoreStart
            // when this happens it is problem with inserted data, not with library
            throw new \RuntimeException('No lookup data!');
        }
        // @codeCoverageIgnoreEnd

        $sql .= '(' . implode(',', array_keys($lookup)) . ')';
        $sql .= ' VALUES (' . implode(',', array_keys($pairs)) . ')';

        $Sth = $this->pdo->prepare($sql);

        foreach ($pairs as $column => $value) {
            $Sth->bindValue($column, $value);
        }

        $execute = $Sth->execute();
        if (!$execute) {
            // @codeCoverageIgnoreStart
            // when this happens it is problem with DB, not with library
            throw new \RuntimeException('Cannot save!');
        }
        // @codeCoverageIgnoreEnd
        $Sth->closeCursor();

        // Now get it back
        $sql = 'SELECT * FROM `' . $this->settings->tableName . '` WHERE 1';
        foreach ($lookup as $column => $bind) {
            if (is_null($pairs[$bind])) {
                $sql .= ' AND ' . $column . ' IS NULL';
            } else {
                $sql .= ' AND ' . $column . ' = ' . $bind;
            }
        }
        $Lth = $this->pdo->prepare($sql);
        foreach ($pairs as $column => $value) {
            if (!is_null($value)) {
                $Lth->bindValue($column, $value);
            }
        }

        $Lth->execute();
        /** @var array<string|int, mixed>|false $row */
        $row = $Lth->fetch();
        $node = $row ? $this->fillDataFromRow($row) : null;
        $Lth->closeCursor();

        if (is_null($node)) {
            // @codeCoverageIgnoreStart
            // when this happens it is problem with DB, not with library
            throw new \RuntimeException('Node not found in database');
        }
        // @codeCoverageIgnoreEnd

        return $node;
    }