Updating FACOLS with MST PACT Table changes - department-of-veterans-affairs/caseflow GitHub Wiki

With the release of MST/PACT, VACOLS was updated to have an ISSMST and ISSPACT column on the ISSUES table to track MST and PACT statuses of legacy issues. To recreate this in Caseflow Local FACOLS, you will need to recreate a new FACOLS image with the new columns added by running these setup steps for your environment:

Windows Setup Steps

  1. Within Caseflow, checkout to setup branch git checkout grant/setup-no-aws and pull the latest by running git pull
  2. Clear your local docker environment by running bundle exec rake local:nuke. This will destroy everything in your docker environment.
  3. Change directory to ~appeals/ directory. If you ls in the directory, caseflow should be the only folder.
  4. Copy caseflow-facols repository by running git clone https://github.com/department-of-veterans-affairs/caseflow-facols.git. Enter your github username and SSH key when prompted.
  5. To download the files FACOLS files quicker, you can use git-lfs. You can download LFS by running sudo apt-get install git-lfs
  6. After downloading git-lfs, navigate to caseflow-facols by running cd caseflow-facols. Download the contests of the repo by running git lfs pull. FACOLS should download into the folder.
  7. Next we need to copy caseflow-facols/build facols. This can be done using windows Explorer GUI by running explorer.exe . in the command line (this will open up windows explorer so you can navigate through the files more easily. You can also do the following steps in the command line if you prefer).
  8. Copy the caseflow-facols/build facols directory. We will move this to the caseflow/local/vacols subdirectory (Ensure you have a caseflow/local/vacols/build facols directory with all the files before continuing to the next step). You can get to there in the command line by running cd ../caseflow/local/vacols or through the GUI using Explorer.exe (you can always ls and make sure you are in the correct directory).
  9. Building within caseflow/local/vacols, make sure the build_facols directory is now present. Build the FACOLS docker image by running ./build_push.sh local.
  10. Navigate back to appeals/caseflow root directory (cd ../.. and ls to make sure you are in the correct directory)
  11. Run within the caseflow folder docker-compose up -d to pull all the created docker images and spin up the containers
  12. Run bundle exec rake db:create to create Databases caseflow_certification_development and caseflow_certification_test
  13. Run bundle exec rake local:vacols:seed
  14. Run bundle exec rake db:schema:load db:seed to reseed your local.
  15. run make reset incase if you run into issues.

Mac with Intel Setup Steps

  1. Checkout to setup branch git checkout grant/setup-no-aws and pull the latest by running git pull
  2. Clear your local docker environment by running bundle exec rake local:nuke. This will destroy everything in your docker environment.
  3. Clone facols to your local by running git clone https://github.com/department-of-veterans-affairs/caseflow-facols.git Upon completion, navigate to caseflow-facols (cd ~/caseflow-facols)
  4. Run: git lfs install (needed to initialize large file storage in repo)
  5. Run: git lfs pull (this will pull the large zipfile)
  6. Copy the caseflow-facols/build facols directory to the caseflow/local/vacols subdirectory. (Ensure you have a caseflow/local/vacols/build facols directory with all the files before continuing to the next step)
  7. Build FACOLS docker image by running ./build_push.sh local.
  8. Navigate back to caseflow root directory (cd ~/caseflow-setup/caseflow)
  9. Run docker-compose up -d. This command pulls all the created docker images and spins up the containers.
  10. Run bundle exec rake db:create it will create Databases caseflow_certification_development and caseflow_certification_test
  11. Run bundle exec rake local:vacols:seed
  12. Run bundle exec rake db:schema:load db:seed
  13. run make reset incase if you run into issues.

Note: If you have an issue seeding due to no space left on device, you might need to clear out your old docker containers with docker builder prune -a

Mac with VM Setup Steps

The Mac VM should be set up to have ISSMST and ISSPACT, but if your setup doesn't, you can add the columns manually:

  1. In the VM for FACOLS, navigate to the ISSUES table.
  2. Using your SQL GUI in your VM, add ISSMST and ISSPACT columns to the table. The columns accept 'Y' and 'N' values for true and false.
  3. Save the table changes.

Mac with Apple Silicon Setup Steps

1. Log in to the UTM Appeals VACOLS Virtual Machine

  • Open the UTM Application
  • Start the "Appeals VACOLS VM" virtual machine
  • Click anywhere in the window to get a login prompt for OracleDB
  • The password is: password

2. Open the Command Prompt

  • Click on the "Command Prompt" icon at the bottom of the screen, or click on the search icon and select "Command Prompt" from the popup.

    UpdateFACOLS-Silicon

3. Enter the VACOLS_DEV Environment

  • Run this command: sqlplus "VACOLS_DEV/VACOLS_DEV@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SID=BVAP)))"

4. Update the Issues Table

  • Run these commands (this will tell you if they exist already):

    ALTER TABLE issues ADD issmst varchar(1);

    ALTER TABLE issues ADD isspact varchar(1);

5. Exit the VACOLS_DEV SQL Environment

  • Enter exit at the sql prompt

6. Enter the VACOLS_TEST Environment

  • Run this command: sqlplus "VACOLS_TEST/VACOLS_TEST@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SID=BVAP)))"

7. Update the Issues Table

  • Run these commands (this will tell you if they exist already):

    ALTER TABLE issues ADD issmst varchar(1);

    ALTER TABLE issues ADD isspact varchar(1);

8. Exit the VACOLS_TEST SQL Environment

  • Enter exit at the sql prompt