cakephp / phinx

use Phinx\Db\Table\Index;

use Phinx\Db\Table\Table;

class AddIndex extends Action

{

    /**

     * The index to add to the table

     *

     * @var Index

     */

    protected $index;

    /**

     * Constructor

     *

     * @param Table $table The table to add the index to

     * @param Index $index The index to be added

     */

    public function __construct(Table $table, Index $index)

    {

        parent::__construct($table);

        $this->index = $index;

    }

    /**

     * Creates a new AddIndex object after building the index object with the

     * provided arguments

     *

     * @param Table $table The table to add the index to

     * @param mixed $columns The columns to index

     * @param array $options Additional options for the index creation

     * @return AddIndex

     */

    public static function build(Table $table, $columns, array $options = [])

    {

        // create a new index object if strings or an array of strings were supplied

        $index = $columns;

        if (!$columns instanceof Index) {

            $index = new Index();

            if (is_string($columns)) {

                $columns = [$columns]; // str to array

            }

            $index->setColumns($columns);

            $index->setOptions($options);

        }

        return new static($table, $index);

    }

    /**

     * Returns the index to be added

     *

     * @return Index

     */

    public function getIndex()

    {

        return $this->index;

    }

}

use Phinx\Db\Table\ForeignKey;

use Phinx\Db\Table\Table;

class DropForeignKey extends Action

{

    /**

     * The foreing key to remove

     *

     * @var ForeignKey

     */

    protected $foreignKey;

    /**

     * Constructor

     *

     * @param Table $table The table to remove the constraint from

     * @param ForeignKey $foreignKey The foreign key to remove

     */

    public function __construct(Table $table, ForeignKey $foreignKey)

    {

        parent::__construct($table);

        $this->foreignKey = $foreignKey;

    }

    /**

     * Creates a new DropForeignKey object after building the ForeignKey

     * definition out of the passed arguments.

     *

     * @param Table $table The table to dele the foreign key from

     * @param string|string[] $columns The columns participating in the foreign key

     * @param string|null $constraint The constraint name

     * @return DropForeignKey

     */

    public static function build(Table $table, $columns, $constraint = null)

    {

        if (is_string($columns)) {

            $columns = [$columns];

        }

        $foreignKey = new ForeignKey();

        $foreignKey->setColumns($columns);

        if ($constraint) {

            $foreignKey->setConstraint($constraint);

        }

        return new static($table, $foreignKey);

    }

    /**

     * Returns the  foreign key to remove

     *

     * @return ForeignKey

     */

    public function getForeignKey()

    {

        return $this->foreignKey;

    }

}