Back to Home

Gulp Guide

Table of Contents

• Overview
• Gulp Commands
• Releases
• Refresh Wiki

Overview

• Gulp commands used in our applications for cleaning up sql code, releases, updating our wiki

Gulp Commands

• gulp resetData - Reset all data using the data.sql file
• gulp resetSql - Reset all stored procedures, views, and functions using the files in sql/StoredProcedure, sql/View, etc
• gulp resetAll - Resets everything in resetData and resetAll as well as tables using files in sql/Table
• gulp generateData - Generates a new data.sql file using the data in the database
• gulp generateSql - Generates new files for tables, stored procedures, views, and functions using the SQL objects in the database
• gulp generateAll - Generates everything from generateSql and generateData
• gulp releaseDev - Generates web files and sql scripts to move to DEV
• gulp releaseStaging - Generates web files and sql scripts to move to Staging

Releases

Release Procedure - DEV

• Local Machine

  1. Run from git bash: gulp releaseDev
  2. Copy release folder to an external hard drive

• Cigna Machine (dev server)

  1. Plug in external hard drive
  2. Run any necessary Script for Release files
  3. Run release/sql/createAllButTables.sql
  4. Copy files in release/files into webroot
  5. Only copy files in folders if the files have changed.

Release Procedure - Staging

• Local Machine
  1. Run from git bash: gulp releaseStaging
  2. Copy release folder to an external hard drive
  3. Cigna Machine (staging server)
  4. Combine any necessary Script for Release files and release/sql/dropAllButTables.sql and release/sql/createAllButTables.sql
  5. Send resulting file to Bud with a backout script
  6. Copy all files in release/compiled into webroot
  7. Copy all files in release/compiled/bin
  8. Only copy p11 files unless the other files have changed

Release Wiki

Run the following command in git bash after committing final changes to git.

Changes to the documentation will be uploaded to our documentation section in the pbc website

• gulp releaseDocumentation