2019102300_removeGroupnameConstraint.php

<?php
/**
 * Notes:
 * 1. Anything complicated needs to be done with SQL.
 * 2. Always have a check to know if the migration needs to occur (up or down).
 * 3. Use up() and down(), not change(), because of the SQL
 */
use Phinx\Migration\AbstractMigration;

class RemoveGroupnameConstraint extends AbstractMigration {
    public function up() {
        $sql = "SELECT relname
                FROM   pg_class c
                INNER JOIN pg_namespace n ON n.oid = c.relnamespace
                INNER JOIN cuadmin a on c.relname = 'idx_' || coalesce(lower(a.cu), '') || '_group_name'";

        $indices = $this->fetchAll($sql);
        foreach($indices as $index) {
            $sql = "DROP INDEX " . $index["relname"];
            $this->query($sql);
        }
    }

    public function down() {
    }
}