updDMITrustedMaster Class Reference

Inheritance diagram for updDMITrustedMaster:

Public Member Functions
	up ()
	down ()

Protected Attributes
	$trusted_table = "cutrustedmaster"
	$trusted_default

Detailed Description

Updates trusted master to include testers for DMI

Definition at line 13 of file 2019101800_updDMITrustedMaster.php.

Member Function Documentation

down()

updDMITrustedMaster::down

(

)

Assuming the previous state was properly added without testers, re-add it as such.

Returns

void

Definition at line 124 of file 2019101800_updDMITrustedMaster.php.

                           {

    $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);
    }

up()

updDMITrustedMaster::up

(

)

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

Returns

void

Definition at line 88 of file 2019101800_updDMITrustedMaster.php.

                         {

        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);
      }
        }
    }

---

The documentation for this class was generated from the following file:

• tools/cumanage/db/migrations/2019101800_updDMITrustedMaster.php