2019072501_increaseTracenumber.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 IncreaseTracenumber extends AbstractMigration {
    public function up() {
        /*
        * Updating ext_withdraw
        */
        $cuList = $this->fetchAll('select cu from cuadmin');
        $cuTableList = array(
            array("table" => "accounthistory", "column" => "tracenumber"),
            array("table" => "loanhistory", "column" => "tracenumber")
        );
        $globalTableList = array(
            array("table" => "cutronah", "column" => "tracenumber"),
            array("table" => "cutronlh", "column" => "tracenumber"),
            array("table" => "cu_alerts", "column" => "lasttrace")
        );
        $size = 22;
        foreach ($cuList as $cuListItem) {
            $cu = strtolower(trim($cuListItem['cu']));

            foreach($cuTableList as $cuTableRecord) {
                $table = $cu . $cuTableRecord["table"];
                $column = $cuTableRecord["column"];
                if ($this->hasTable($table)) {
                    print "Updating table $table...\n";
                    $sql = "alter table $table alter column $column type character($size)";
                    $this->query($sql);
                }
            }
        }

        foreach($globalTableList as $tableRecord) {
            $table = $tableRecord["table"];
            $column = $tableRecord["column"];
            if ($this->hasTable($table)) {
                print "Updating table $table...\n";
                $sql = "alter table $table alter column $column type character($size)";
                $this->query($sql);
            }
        }
    }

    public function down() {

    }
}