2019101800_updDMITrustedMaster.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 updDMITrustedMaster extends AbstractMigration {

  /** @var string  */
  protected $trusted_table    = "cutrustedmaster";
  /** @var array - use in part for updates, completely for insert */
    protected $trusted_default  = [
    'trustedid'     => 'DMI',
    'trustedvendor' => 'Dovenmuehle',
    'trustedtype'   => 'O',
    'hcuinterface'  => '',
    'trustedfields' => [
      'prodGUID' => [
        'Type' => 'string',
        'Default' => '',
        'Message' => 'Client ID from DMI - production'
      ],
      'testGUID' => [
        'Type' => 'string',
        'Default' => '',
        'Message' => 'Client ID from DMI - testing'
      ],
      'pilot' => [
        'Type' => 'digits',
        'Default' => '0',
        'Message' => '1=testing 0=production'
      ],
      'prodSSOURL' => [
        'Type' => 'string',
        'Default' => 'https://mtgsvc.com/SSO/SSOLogin.aspx',
        'Message' => 'SSO URL - production'
      ],
      'testSSOURL' => [
        'Type' => 'string',
        'Default' => 'https://mtgsvc.tv/SSO/SSOLogin.aspx',
        'Message' => 'SSO URL - testing'
      ],
      'prodAuthURL' => [
        'Type' => 'string',
        'Default' => 'https://mtgsvc.com/SSO/SSOCertify.aspx',
        'Message' => 'authentication URL - production'
      ],
      'testAuthURL' => [
        'Type' => 'string',
        'Default' => 'https://mtgsvc.tv/SSO/SSOCertify.aspx',
        'Message' => 'authentication URL - testing'
      ],
      'hcuLogging' => [
        'Type' => 'string',
        'Default' => ''
      ],
      'hcuCert' => [
        'Type' => 'string',
        'Default' => 'prod/certs/homecu/HomeCUCF.crt',
        'Message' => 'HomeCU server certificate is passed as client cert.'
      ],
      'hcuKey' => [
        'Type' => 'string',
        'Default' => 'prod/certs/homecu/HomeCUCF.key',
        'Message' => 'HomeCU server certificate key to pass with server cert as client cert'
      ],
      'testers' => [
        'Type' => 'string',
        'Default' => '',
        'Message' => 'csv list of users to force test mode'
      ]
    ]
  ];

  /**
   * See if Dovenmuehle DMI exists, if so, update it to force the testers entry and
   * updated default values for URLS
   *
   * Since trustedid is unique key to table, counting on only one DMI 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);
      }
        }
    }

  /**
   * **Assuming** the previous state was properly added without testers, re-add it as such.
   * @return void
   */
    public function down() {

    $def = $this->trusted_default;
    unset ($def['trustedfields']['testers']);

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

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

?>