2019050100_AddBankingMenuCache.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 AddBankingMenuCache extends AbstractMigration {
    public function up() {
      // get the list of credit unions
      $cuList = $this->fetchAll('SELECT cu FROM cuadmin');
      $columnName = "cachedmenu";

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

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

        if ($this->hasTable($tableName)) {
          $table = $this->table( $tableName );

          $hasColumn = $table->hasColumn($columnName);

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

            // Add column
            $this->query("alter table $tableName add column $columnName varchar");
          }
        }

      }
    }

    public function down() {

    }
}