2019052000_addFeatureGate.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 AddFeaturegate extends AbstractMigration {

  /* This is the process for moving forward. We are re-creating the table so if there is
   * existing data will need to create a temporary table, copy the data, drop the old table,
   * rename the temporary table.
   */
  public function up() {

    // create cucorerequests table if it doesn't exist
    $exists = $this->hasTable("cufeaturegate");

    if (!$exists) {
      $sql = "
        CREATE TABLE cufeaturegate (
        feature     character varying(10) NOT NULL,
        description character varying(255),
        enabled_all character(1),
        enabled_cu  character varying
        );";
      $sqlRs = $this->query($sql);

      // add comments for table and columns
      $sql = "COMMENT ON TABLE cufeaturegate IS 'Table to help the gating of features into master.';";
      $sqlRs = $this->query($sql);

      $sql = "COMMENT ON COLUMN cufeaturegate.feature IS 'A developer created Feature Code to identify feature being gated.';";
      $sqlRs = $this->query($sql);

      $sql = "COMMENT ON COLUMN cufeaturegate.description IS 'More verbose description to help other understand the feature.';";
      $sqlRs = $this->query($sql);

      $sql = "COMMENT ON COLUMN cufeaturegate.enabled_all IS 'Global feature setting. {Y}-Enabled All, {N}-Not enabled, {O}-Off for everyone.';";
      $sqlRs = $this->query($sql);

      $sql = "COMMENT ON COLUMN cufeaturegate.enabled_cu IS 'Enabled list for credit unions.';";
      $sqlRs = $this->query($sql);

      // set primary key constraint on feature column
      $sql = "ALTER TABLE ONLY cufeaturegate ADD CONSTRAINT pk_cufeaturegate_feature PRIMARY KEY (feature);";
      $sqlRs = $this->query($sql);

    }
  }

  /* To execute this you need to run the following command:
   * php vendor/bin/phinx rollback (using correct path to phinx)
   * Or, to roll back to a specific time:
   * php vendor/bin/phinx rollback -t 20151123211207
   */
  public function down() {
    // drop cucorerequests table
    $this->dropTable("cufeaturegate");
  }
}

?>