LoadLnAppData Class Reference

Inheritance diagram for LoadLnAppData:

Public Member Functions
	up ()

Detailed Description

Definition at line 9 of file 2018041701_loadLnAppData.php.

Member Function Documentation

up()

LoadLnAppData::up

(

)

Load the default TEMPLATE DATA into the lnapp tables

LOCAL VARIABLES

Cleanup the other records. This assumes an initial insert for the lnapp tables

---

SCHEMA MASTER

LOAD SQL STATEMENT

---

SCHEMA DETAIL

LOAD SQL STATEMENT

set nextval to be high enough to allow for other templates

---

ANSWER LOOKUP HEADER

LOAD SQL STATEMENT

set nextval to be high enough to allow for other templates

---

ANSWER LOOKUP DETAIL

LOAD SQL STATEMENT

set nextval to be high enough to allow for other templates

Definition at line 15 of file 2018041701_loadLnAppData.php.

                       {
    /**
     *  Load the default TEMPLATE DATA into the lnapp tables
     *
     */

    /**
     * LOCAL VARIABLES
     */
    $skipLoad = false;


    /**
     * Cleanup the other records.  This assumes an initial insert for the lnapp tables
     */
    $sqlDel = "DELETE FROM lnappschemamaster;";
    $result = $this->execute($sqlDel);

    $sqlDel = "DELETE FROM lnappschemadetail;";
    $result = $this->execute($sqlDel);


    /** ************
     *
     * SCHEMA MASTER
     *
     */

    /**
     *  LOAD SQL STATEMENT
     */
    $sqlLoad = GetLnappMasterData();


    $result = $this->execute($sqlLoad);
    print "*** RESULT lnappschemamaster: $result ***\n";

    // ** Set skipLoad based on result being 0 (assuming no records inserted)
    $skipLoad = ($result == 0);


    if (!$skipLoad) {

      /** ************
       *
       * SCHEMA DETAIL
       *
       */
      /**
       *  LOAD SQL STATEMENT
       */
      $sqlLoad = GetLnappDetailData();
      $result = $this->execute($sqlLoad);
      print "*** RESULT lnappschemadetail: $result ***\n";


      /**
       * set nextval to be high enough to allow for other templates
       */
      // * set to 1000
      $sql = "SELECT SETVAL('lnappschemamaster_loanid_seq', 1000);";
      $this->execute($sql);



      /** ************
       *
       * ANSWER LOOKUP HEADER
       *
       */
      /**
       *  LOAD SQL STATEMENT
       */
      $sqlLoad = GetLnappAnsLookupHeaderData();
      $result = $this->execute($sqlLoad);
      print "*** RESULT lnappanslookupheader: $result ***\n";

      /**
       * set nextval to be high enough to allow for other templates
       */
      // * set to 1000
      $sql = "SELECT SETVAL('lnappanslookupheader_ansid_seq', 1000);";
      $this->execute($sql);

      /** ************
       *
       * ANSWER LOOKUP DETAIL
       *
       */
      /**
       *  LOAD SQL STATEMENT
       */
      $sqlLoad = GetLnappAnsLookupDetailData();
      $result = $this->execute($sqlLoad);
      print "*** RESULT lnappanslookupdetail: $result ***\n";

      /**
       * set nextval to be high enough to allow for other templates
       */
      // * set to 10000
      $sql = "SELECT SETVAL('lnappanswerlookupdetail_ansdetailid_seq', 10000);";
      $this->execute($sql);



    } else {
      print "** Skipped loading lnappschemadetail **";
    }

  }

---

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

• tools/cumanage/db/migrations/2018041701_loadLnAppData.php