Page Comparison

...

1. in bi/ppiparser run parseall.sh (this will regenerate generated/testData/*.properties files
2. initialize a clean Mifos database with base etl test data
   • echo "drop database mifos_ppi_test" | mysql -u root
   • echo "create database mifos_ppi_test" | mysql -u root
   • mysql -u root mifos_ppi_test < bi/ETL/MifosDataWarehouseETLTest/mifos_testetl_db.sql
3. copy all question group XML files to MIFOS_CONF/uploads/questionGroups
   • cp $PPI_BASE/ppiparser/generated/questionGroups/* ~/.mifos/uploads/questionGroups
4. run PPITestDataGenerator from inside Eclipse with an arg pointing to the test data dir (e.g. -a /home/van/reportingWorkspace/bi/ppiparser/generated/testData) and an arg for the client to use (e.g. -i 0003-000000006)
5. save the resulting Mifos database (with completed ppi surveys) NOTE: different output sql file than above
   • mysqldump --default-character-set=utf8 -u root mifos_ppi_test > bi/ETL/MifosDataWarehouseETLTest/load_testppi_db.sql
6. run the etl (bi/ppi_build.sh) to populate with DW with PPI survey scores NOTE: jndi file for pentaho data integration must be configured with same OLTP and DW databases, and must support UTF-8
   • ppi_build.sh mifos_ppi_test mifos_ppi_test_dw ~/pentaho/data-integration/ '-u root'
7. now PPITest.groovy can be run
   • under Eclipse run configurations, add a new JUnit test
   • in the "VM arguments", define variables for biTestDbUrl and other system properties used by PPITest.groovy, for example:

     Code Block
     -DbiTestDbUrl=jdbc:mysql://localhost/mifos_ppi_test_dw -DbiTestDbUser=root -DbiTestDbPassword= -DbiTestDbDriver=com.mysql.jdbc.Driver

     (note that biTestDbUrl points to a test data warehouse schema)