2018041600_emailnotify.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 EmailNotify 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"]));
        $cuTableExists = $this->hasTable($cu . "transdtl");
        
        if ($cuTableExists) {
          $this->query("ALTER TABLE {$cu}transdtl ALTER COLUMN email_notify DROP DEFAULT");
          $this->query("ALTER TABLE {$cu}transdtl ALTER COLUMN email_notify TYPE smallint USING CASE WHEN email_notify=TRUE THEN 1 ELSE 0 END");
          $this->query("ALTER TABLE {$cu}transdtl ALTER COLUMN email_notify SET DEFAULT 0");
        }
      }
    }

    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"]));
        $cuTableExists = $this->hasTable($cu . "transdtl");

        if ($cuTableExists) {
          $this->query("ALTER TABLE {$cu}transdtl ALTER COLUMN email_notify DROP DEFAULT");
          $this->query("ALTER TABLE {$cu}transdtl ALTER COLUMN email_notify TYPE bool USING CASE WHEN email_notify=0 THEN FALSE ELSE TRUE END");
          $this->query("ALTER TABLE {$cu}transdtl ALTER COLUMN email_notify SET DEFAULT FALSE"); 
        }       
      }
    }
}