2019072600_addSavvyMoneyTrustedMaster.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 AddSavvyMoneyTrustedMaster 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 = '{"beta":{"Type":"digits","Default":"1","Message":"1=beta test 0=production"},"betaAuthId":{"Type":"string","Default":"HomeCU-Test","Message":"Auth ID issued by SavvyMoney"},"betaAuthKey":{"Type":"string","Default":"eyJhbGciOiJSUzUxMiJ9.eyJzdWIiOiJIb21lQ1UtVGVzdCIsImF1ZCI6ImJldGEuc2F2dnltb25leS5jb20iLCJzbVBsYXRmb3JtIjoiSG9tZUNVIiwic21Jc3N1ZVRpbWUiOiIyMDE5LTA3LTEwVDE3OjQwOjI1LjUyNloiLCJzbUlzc3VlZEJ5Ijoic2h3ZXRhLm5haWsiLCJzbUNsYWltVmVyc2lvbiI6Miwic21BRVMyNTZLZXkiOiJoTXN1L0hvZ084NThCRUdzSHdOakd0dXdIM3Jub3FPSllCRGdTbSt2dUtJU3RXb0RIU21xUDZxNG5QUjhWQUR4aWF2NVNXUGNUak82NzV5bXJ0OHUxVXY3eHRsL3NYVFRYeU5QL1NGbUpZbjlqR1A2RG5HbDVscWcwdHVZa0w3VzlNSkFWQVhKQ2R5RnlReDNGOTVXQlZyRU1UMWUxS0QvS04xbVR4TEg5M0dnYi81Y3pUZHZLam04OTl5elZydXduZW5LM1o1VnFXRUtZYlNLR0Z0TlNlNVIrZS9ybnZ6bXloRGJjZ2pGREtrcWdCYUJwMlgrT1V4V0ZuZ3RVc01XWk5qSGhyeUM5aXIwYlBMNkF0M2w0MzE5RE1CQXByeGFHSHNYL0xjSzFqWFRjam4vcG5vQTlveU5sdGRYdXBDZlhtRFNWT3JMTytGUTVsOVBPUkQycXc9PSJ9.dxh7kd_1nYGP5iVyuKAUTdvrmxqfGJtQ2GRqSg1AwGHIcR9KtmwJ5a8s9kYUY1tpFkZf1r0kVnsbOjV0sN8NjOjv4SxtWu6EZbxdm69b2W-1F12UFDXAMwABq5OFMrq02gouMnQGXUHlHMcnuZsUn2oC80-pINVwRZCnYXaBxBXGPWCsN10hv-3c2tdrTQGUQa56OD1hxNDY_fxYtbpIiPiqTZaftbAtzmZ6c7Z6esS2nB79JOOtX4c0bXY3akk6DRgW8Hp933Dj23vJCJkXP4ADOcNt7DmaM3e6YPUHOfZKlmO5cHUoJVBmsIVvgda5jvjNo_jLR7Iz6nvzGOK2lQ","Message":"Auth Key issued by SavvyMoney"},"betaAuthDomain":{"Type":"string","Default":"beta.savvymoney.com","Message":"SavvyMoney Domain issued by SavvyMoney"},"betaPartnerId":{"Type":"string","Default":"336","Message":"Partner Id issued by SavvyMoney"},"betaEncKey":{"Type":"string","Default":"bArCHs5iFdiYGru2LNioWTHj2q6uQCvyMIlrbFOiN44=","Message":"Encryption Key issued by SavvyMoney"},"betaAPIurl":{"Type":"string","Default":"https:\/\/beta.savvymoney.com\/sso\/api\/rest","Message":"Rest API URL no trailing slash"},"betaSSOurl":{"Type":"string","Default":"https:\/\/beta.savvymoney.com\/ui\/sso","Message":"appUrl for DSK\/Responsive Redirect URL no trailing slash"},"betaMBLurl":{"Type":"string","Default":"https:\/\/beta.savvymoney.com\/ui\/mobile-sso","Message":"appUrl for APP Redirect URL no trailing slash"},"prodAuthId":{"Type":"string","Default":"","Message":"Auth ID issued by SavvyMoney"},"prodAuthKey":{"Type":"string","Default":"","Message":"Auth Key issued by SavvyMoney"},"prodAuthDomain":{"Type":"string","Default":"","Message":"SavvyMoney Domain issued by SavvyMoney"},"prodPartnerId":{"Type":"string","Default":"","Message":"Partner Id issued by SavvyMoney"},"prodEncKey":{"Type":"string","Default":"","Message":"Encryption Key issued by SavvyMoney"},"prodAPIurl":{"Type":"string","Default":"https:\/\/www.savvymoney.com\/sso\/api\/rest","Message":"Rest API URL no trailing slash"},"prodSSOurl":{"Type":"string","Default":"https:\/\/www.savvymoney.com\/ui\/sso","Message":"appUrl for DSK\/Responsive Redirect URL no trailing slash"},"prodMBLurl":{"Type":"string","Default":"https:\/\/www.savvymoney.com\/ui\/mobile-sso","Message":"appUrl for APP Redirect URL no trailing slash"},"PadMbrSize":{"Type":"digits","Default":"0","Message":"Pad accountToUse for use as member unique id.  Pad to this size, or zero is no padding"},"hcuLogging":{"Type":"string","Default":"","Message":""}}';

        $detailsString = pg_escape_string($unpreppedDetailString);

          $this->query("insert into $tableName values ('SavvyMo_SSO','SavvyMoney','O',NULL, '$detailsString')");
          print "Inserted 'SavvyMoney' 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 = 'SavvyMo_SSO'");
          print "Removed 'SavvyMoney' from $tableName.\n";
        } else {
          print "Oh No! cutrustedmaster has gone missing.\n";
        }
    } // End "down" function
}