2018112900_AddTransmetaField.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 AddTransmetaField 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"]));
            $tableName = "{$cu}transhdr";

            // check if table exists
            if ($this->hasTable($tableName)) {
                $table = $this->table($tableName);
                $tableColumn = "transmeta";

                // add column if it doesn't exist
                if (!$table->hasColumn($tableColumn)) {
                    $this->query("ALTER TABLE $tableName ADD COLUMN $tableColumn varchar");
                }
            }
        }
    }

    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"]));
            $tableName = "{$cu}transhdr";

            // check if table exists
            if ($this->hasTable($tableName)) {
                $table = $this->table($tableName);
                $tableColumn = "transmeta";

                // remove column if it exists
                if ($table->hasColumn($tableColumn)) {
                    $this->query("ALTER TABLE $tableName DROP COLUMN $tableColumn");
                }
            }
        }
    }
}