Rentgen\Schema\Manipulation\AddConstraintCommand

Complexity

Total Complexity

4

Size/Duplication

Total Lines	43
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	4

Importance

Changes	1
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	setConstraint()	0	6	1
A	getSql()	0	21	3

<?php
namespace Rentgen\Schema\Manipulation;

use Rentgen\Schema\Command;
use Rentgen\Database\Constraint\ConstraintInterface;
use Rentgen\Database\Constraint\ForeignKey;
use Rentgen\Database\Constraint\Unique;
use Rentgen\Database\Table;

class AddConstraintCommand extends Command
{
    private $constraint;

    /**
     * Set a constraint.
     *
     * @param ConstraintInterface $constraint A constraint instance.
     *
     * @return AddConstraintCommand
     */
    public function setConstraint(ConstraintInterface $constraint)
    {
        $this->constraint = $constraint;

        return $this;
    }

    /**
     * {@inheritdoc}
     */
    public function getSql()
    {
        if ($this->constraint instanceof ForeignKey) {
            return sprintf('ALTER TABLE %s ADD CONSTRAINT %s FOREIGN KEY (%s) REFERENCES %s (%s) MATCH SIMPLE ON UPDATE %s ON DELETE %s;'
                , $this->constraint->getTable()->getQualifiedName()
                , $this->constraint->getName()
                , implode(',', $this->constraint->getColumns())
                , $this->constraint->getReferencedTable()->getQualifiedName()
                , implode(',', $this->constraint->getReferencedColumns())
                , $this->constraint->getUpdateAction()
                , $this->constraint->getDeleteAction()
            );
        }
        if ($this->constraint instanceof Unique) {
            return sprintf('ALTER TABLE %s ADD CONSTRAINT %s UNIQUE (%s);'
                , $this->constraint->getTable()->getQualifiedName()
                , $this->constraint->getName()
                , implode(',', $this->constraint->getColumns())
            );
        }
    }
}