2019093000_addPayzurTrustedMaster.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 AddPayzurTrustedMaster extends AbstractMigration {
    public function up() {

        // check if we already made the change
        $tableName = "cutrustedmaster";

        if ($this->hasTable($tableName)) { // This table should exist but make sure.
        $unpreppedDetailString = '{"testMode":{"Type":"digits","Default":"1","Message":"1=testing 0=production"},"testapiKey":{"Type":"string","Default":"u3daL09q","Message":"From Vendor. API key for vendor test environment"},"testapiHMAC":{"Type":"string","Default":"","Message":"From Vendor. Optional HMAC for signature hash in vendor test environment. Only used if useHMAC=1"},"prodapiKey":{"Type":"string","Default":"","Message":"From Vendor. API key for vendor production environment"},"prodapiHMAC":{"Type":"string","Default":"","Message":"From Vendor. Optional HMAC for signature hash in vendor production environment. Only used if useHMAC=1"},"useHMAC":{"Type":"digits","Default":"0","Message":"1=use optional signature hash for added security 0=no hash"},"testURL":{"Type":"string","Default":"https:\/\/cert.payzur.com\/payzurservices.svc\/user","Message":"From Vendor. URL for vendor test environment"},"prodURL":{"Type":"string","Default":"","Message":"From Vendor. URL for vendor production environment"},"useMIR":{"Type":"digits","Default":"1","Message":"1=require extended member info 0=no MIR required"},"hcuLogging":{"Type":"string","Default":"","Message":"0\/blank = no logging -1 = log everyone, csv list=log listed accounts"}}';

        $detailsString = pg_escape_string($unpreppedDetailString);

          $this->query("insert into $tableName values ('PAYZUR_SSO','Payzur','O',NULL, '$detailsString')");
          print "Inserted 'PAYZUR_SSO' into $tableName.\n";
        } else {
          print "Oh No! cutrustedmaster has gone missing.\n";
        }
    } // End "up" function.

    public function down() {

        // check if we already made the change
        $tableName = "cutrustedmaster";

        if ($this->hasTable($tableName)) { // This table should exist but make sure.

          $this->query("delete from $tableName where trustedid = 'PAYZUR_SSO'");
          print "Removed 'PAYZUR_SSO' from $tableName.\n";
        } else {
          print "Oh No! cutrustedmaster has gone missing.\n";
        }
    } // End "down" function
}