2018042000_allowEnroll.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 AllowEnroll extends AbstractMigration {
    public function up() {
      // get the list of credit unions
      $cuList = $this->fetchAll('SELECT cu FROM cuadmin');


      foreach ($cuList as $cuRow) {
        $cu = strtolower(trim($cuRow["cu"]));

        // check if we already made the change
        $tableName = "{$cu}memberacct";

        if ($this->hasTable($tableName)) { // Not all Credit Unions have this table.  Webonly Credit Unions don't have a lot of the CU-specific tables.
          $table = $this->table( $tableName );

          $hasColumn = $table->hasColumn('allowenroll');

          // test to see if change has already happened
          if ( !$hasColumn ) {
            // announce it
            print "Upgrade $cu {$tableName}.\n";

            // Add column
            $this->query("alter table $tableName add column allowenroll boolean default false");
          }
        } else {
          print "Skip $cu which doesn't have the member acct table.\n";
        }

      }
    } // End "up" function.

    public function down() {
      // get the list of credit unions
      $cuList = $this->fetchAll('SELECT cu FROM cuadmin');


      foreach ($cuList as $cuRow) {
        $cu = strtolower(trim($cuRow["cu"]));

        // check if we already made the change
        $tableName = "{$cu}memberacct";

        if ($this->hasTable($tableName)) { // Not all Credit Unions have this table.  Webonly Credit Unions don't have a lot of the CU-specific tables.
          $table = $this->table( $tableName );
          $hasColumn = $table->hasColumn('allowenroll');

          // test to see if change has already happened
          if ( $hasColumn ) {
            // announce it
            print "Downgrade $cu {$tableName}.\n";

            // drop column
            $this->query("alter table $tableName drop column allowenroll");
          }
        } else {
          print "Skip $cu which doesn't have the member acct table.\n";
        }

      }
    } // End "down" function
}