2017101600_removestale.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 RemoveStale extends AbstractMigration {

  /*
   * remove the column "stale" from account and loan balance tables
   */
  public function up() {

    $cuList = $this->fetchAll('SELECT cu FROM cuadmin');
    for ($i = 0; $i < count($cuList); $i ++) {
      $cu = strtolower( trim( $cuList[$i]["cu"] ) );
      $tableAcct = $this->hasTable("{$cu}accountbalance");
      $tableLoan = $this->hasTable("{$cu}loanbalance");

      if ($tableAcct) {
        $sql = "ALTER TABLE {$cu}accountbalance DROP COLUMN stale";
        $this->query($sql);
      }

      if ($tableLoan) {
        $sql = "ALTER TABLE {$cu}loanbalance DROP COLUMN stale";
        $this->query($sql);
      }
    }
  }

  /* 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() {

  }
}

?>