2018090600_LoanAppTrustedMaster.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 LoanAppTrustedMaster extends AbstractMigration {
    public function up() {
      // get the list of credit unions
      $tableName = "cutrustedmaster";

      if ($this->hasTable($tableName)) {
        // check for specific docsid 1: Start Disclosure
        $findRec = $this->fetchRow("SELECT * FROM cutrustedmaster WHERE trustedid = 'hcuLoanApp'");
        // ONLY trying to insert
        if (!$findRec) {

          // IF the record is NOT found then insert into the table.
          $this->query('INSERT INTO "cutrustedmaster" ("trustedid", "trustedvendor", "trustedtype", "hcuinterface", "trustedfields") VALUES (\'hcuLoanApp\', \'HomeCU\', \'O\', NULL, \'{"lnAppId":{"Type":"string","Default":"4mH4VNSnVEHa72q4WhU8G6z%2F2z8tGLNJhA2tfIOTuwg%3D"},"URL":{"Type":"string","Default":"https:\/\/www6.homecu.net\/hculive7\/lnapp\/AppMain?appinit=1&f=hbssouser"},"hcuLogging":{"Type":"string","Default":"","Message":""}}\');');

        }

      }
    }

    public function down() {
      
    }
}