2017050800_memberacct.php

<?php
/**
 * PURPOSE:
 *   The purpose of this script is to add two columns
 *     balance_stamp
 *     balance_attemp 
 *   to the <client>memberacct table.
 *   This script will first verify the fields don't already exist,
 *     ADD - if the fields are not present
 *     SKIP - if the fields are present
 * 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 MemberAcct extends AbstractMigration {
    /* This is the process for moving forward. We are re-creating the table so if there is
     * existing data will need to create a temporary table, copy the data, drop the old table,
     * rename the temporary table.
     */
    public function up() {
      // get the list of credit unions
      $cuList = $this->fetchAll('SELECT cu FROM cuadmin');

      for ( $i = 0; $i < count( $cuList ); $i++ ) {
        $cu = strtolower( trim( $cuList[$i]["cu"] ) );

        // check if we already made the change
        $tableName = "{$cu}memberacct";
        $table = $this->table( $tableName );
        $hasColumn = $table->hasColumn('balance_stamp');

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

          /*
           * ADD COLUMNS
           */
          // ** balance_stamp
          $table->addColumn('balance_stamp', 'biginteger', array('null' => true))
                ->save();

          // ** balance_attempt
          $table->addColumn('balance_attempt', 'biginteger', array('null' => true))
                ->save();

        }
      }
    }

    /* To execute this you need to run the following command:
     * php vendor/bin/phinx rollback (using correct path to phinx)
     * Or, to roll back to a specific time:
     * php vendor/bin/phinx rollback -t 20151123211207
     */
    public function down() {
      // get the list of credit unions
      $cuList = $this->fetchAll('SELECT cu FROM cuadmin');

      for ( $i = 0; $i < count( $cuList ); $i++ ) {
        $cu = strtolower( trim( $cuList[$i]["cu"] ) );

        // check if we already made the change
        $tableName = "{$cu}memberacct";
        $table = $this->table( $tableName );
        $hasColumn = $table->hasColumn('balance_stamp');

        // test to see if table has NOT been reversed yet
        if ( $hasColumn ) {
          // announce it
          print "Migration - Downgrade $cu {$tableName}\n";

          /*
           * REMOVE COLUMNS
           */
          // ** balance_stamp
          $table->removeColumn('balance_stamp')
              ->save();

          // ** balance_attempt
          $table->removeColumn('balance_attempt')
              ->save();
        }
      }
    }
}