2019102100_updXDITrustedMaster.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;

/**
 * Updates trusted master to include testers for DMI
 */
class updXDITrustedMaster extends AbstractMigration {

  /** @var string  */
  protected $trusted_table    = "cutrustedmaster";
  /** @var array - use in part for updates, completely for insert */
    protected $trusted_default  = [
    'trustedid'     => 'XPRESS_SSO',
    'trustedvendor' => 'Xpress Data',
    'trustedtype'   => 'E',
    'hcuinterface'  => '',
    'trustedfields' => [
      'testMode' => [
        'Type' => 'digits',
        'Default' => '1',
        'Message' => '1=test 0=production'
      ],
      'testappKey' => [
            'Type' => 'string',
            'Default' => 'AppId',
            'Message' => 'Issued by XDI'
      ],
      'testappValue' => [
            'Type' => 'string',
            'Default' => 'xdi',
            'Message' => 'use xdi for SSO'
      ],
      'testtokenURL' => [
            'Type' => 'string',
            'Default' => 'https://exstokenserver.xdi.com/DISCOVERYFCUTokenServer/TokenServer.asmx',
            'Message' => 'eXpressServices token server URL issued by XDI'
      ],
      'prodappKey' => [
            'Type' => 'string',
            'Default' => 'AppId',
            'Message' => 'Issued by XDI'
      ],
      'prodappValue' => [
            'Type' => 'string',
            'Default' => 'xdi',
            'Message' => 'use xdi for SSO'
      ],
      'prodtokenURL' => [
            'Type' => 'string',
            'Default' => 'https://exstokenserver.xdi.com/DISCOVERYFCUTokenServer/TokenServer.asmx',
            'Message' => 'eXpressServices token server URL issued by XDI'
      ],
      'hcuLogging' => [
            'Type' => 'string',
            'Default' => '',
            'Message' => '-1 to log all or csv list to log specified or blank/0 no logging'
      ]
    ]
  ];

  /**
   * See if row defined above exists in trusted master.
   * If so, update it to force the content defined above
   *
   * Since trustedid is unique key to table, counting on only one entry
   * @return void
   */
    public function up() {

        if ($this->hasTable($this->trusted_table)) {

      $def = $this->trusted_default;
      $sql = "select * from {$this->trusted_table} where trustedid = '{$def['trustedid']}'";

      # note appears that fetchRow always returns count of 1, even if no row is found.
      # using fetchAll even though I expect max 1 record (trustedid is unique key)

      $trusted_row = $this->fetchAll($sql);

      if (count($trusted_row) > 0) {
                    $sql = "update {$this->trusted_table} set trustedfields = E'"
                        . json_encode($def['trustedfields'])
                        . "' where trustedid = '{$def['trustedid']}'";

          echo " updating {$def['trustedid']} trusted master\n";
                    $this->query($sql);

      } else {

        $sql = "insert into {$this->trusted_table} (trustedid, trustedvendor, trustedtype, hcuinterface, trustedfields)"
              . " values('{$def['trustedid']}', '{$def['trustedvendor']}', '{$def['trustedtype']}',"
              . " E'{$def['hcuinterface']}', E'" . json_encode($def['trustedfields']) . "')";

        echo " inserting {$def['trustedid']} trusted master\n";
        $this->query($sql);
      }
        }
  }
  /**
   * No Down
   * @return void
   */
    public function down() {
    }
}

?>