Tanzania eLMIS demo data

The scripts for eLMIS instance data used in Tanzania can be found here. This scripts will do the followings;

1. Clear content on your program table and insert ILS Redesign program.
2. Clear facilities reference data on your database and create new two facilities - one dispensary another health center.
3. Clear product reference data on your database and create four new products, map products with program and facilities.
4. Create new RnR template for ILS Redesign program.
5. Clear users on your database and create four new users
   
   1. Store in charge - username: StoreInCharge, password: Admin123, role: creates and submits requisitions
   2. Facility in charge - username: FacilityInCharge, password: Admin123, role: authorizes requisitions
   3. LMU - username: lmu, password: Admin123, role: approves requisitions
   4. Administrator - username: Admin123, password: Admin123, role: Admin
6. Add processing schedules
7. Add requisitions groups

How to use these scripts?

1. These scripts can be downloaded and extracted on local machine to this directory on your project (open-lmis/test-data).
2. Add following gradle task on this file on your project (open-lmis/modules/db/build.gradle)

   task casperSeed(type: Exec) {
   environment("PGPASSWORD", dbPassword)
   commandLine 'psql', 'U', dbUser, '-file', '../../test-data/casper/seed.sql', '-h', databaseHostName, '-w', dbName
   }

3. You are done, now every time you want fresh data you will have to run this command

   gradle casperSeed

Note:

Past requisitions have not yet been included on this script

Quick corresponding v3 SQL script