Spiral\Database\Drivers\SQLite\Schemas\SQLiteReference

Complexity

Total Complexity

9

Size/Duplication

Total Lines	76
Duplicated Lines	0 %

Coupling/Cohesion

Components	2
Dependencies	3

Importance

Changes

0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	getName()	0	4	1
A	sqlStatement()	0	15	1
B	compare()	0	12	6
A	createInstance()	0	17	1

<?php
/**
 * Spiral Framework.
 *
 * @license   MIT
 * @author    Anton Titov (Wolfy-J)
 */

namespace Spiral\Database\Drivers\SQLite\Schemas;

use Spiral\Database\Entities\Driver;
use Spiral\Database\Schemas\Prototypes\AbstractReference;
use Spiral\Database\Schemas\ReferenceInterface;

class SQLiteReference extends AbstractReference
{
    /**
     * In SQLite we have no predictable name.
     *
     * @return string
     */
    public function getName(): string
    {
        return $this->tablePrefix . $this->table . '_' . $this->column . '_fk';
    }

    /**
     * {@inheritdoc}
     */
    public function sqlStatement(Driver $driver): string
    {
        $statement = [];

        $statement[] = 'FOREIGN KEY';
        $statement[] = '(' . $driver->identifier($this->column) . ')';

        $statement[] = 'REFERENCES ' . $driver->identifier($this->foreignTable);
        $statement[] = '(' . $driver->identifier($this->foreignKey) . ')';

        $statement[] = "ON DELETE {$this->deleteRule}";
        $statement[] = "ON UPDATE {$this->updateRule}";

        return implode(' ', $statement);
    }

    /**
     * Name insensitive compare.
     *
     * @param ReferenceInterface $initial
     *
     * @return bool
     */
    public function compare(ReferenceInterface $initial): bool
    {
        if (parent::compare($initial)) {
            return true;
        }

        return $this->getColumn() == $initial->getColumn()
            && $this->getForeignTable() == $initial->getForeignTable()
            && $this->getForeignKey() == $initial->getForeignKey()
            && $this->getUpdateRule() == $initial->getUpdateRule()
            && $this->getDeleteRule() == $initial->getDeleteRule();
    }

    /**
     * @param string $table
     * @param string $tablePrefix
     * @param array  $schema
     *
     * @return SQLiteReference
     */
    public static function createInstance(string $table, string $tablePrefix, array $schema): self
    {
        $reference = new self($table, $tablePrefix, $schema['id']);

        $reference->column = $schema['from'];

        $reference->foreignTable = $schema['table'];
        $reference->foreignKey = $schema['to'];

        //In SQLLite we have to work with pre-defined reference names
        $reference->name = $reference->getName();

        $reference->deleteRule = $schema['on_delete'];
        $reference->updateRule = $schema['on_update'];

        return $reference;
    }
}