PageRenderTime 25ms CodeModel.GetById 17ms RepoModel.GetById 0ms app.codeStats 0ms

/src/test/java/org/openmf/mifos/dataimport/populator/SavingsTransactionWorkbookPopulatorTest.java

https://gitlab.com/skylabase/DataImportTool
Java | 105 lines | 86 code | 17 blank | 2 comment | 0 complexity | 4e862b5e58d84d1c4970dc48e3c4efa9 MD5 | raw file
    

  1. package org.openmf.mifos.dataimport.populator;
    2. 

  2. 

  3. import org.apache.poi.hssf.usermodel.HSSFWorkbook;
    4. 

  4. import org.apache.poi.ss.usermodel.Row;
    5. 

  5. import org.apache.poi.ss.usermodel.Sheet;
    6. 

  6. import org.apache.poi.ss.usermodel.Workbook;
    7. 

  7. import org.junit.Assert;
    8. 

  8. import org.junit.Test;
    9. 

  9. import org.junit.runner.RunWith;
    10. 

  10. import org.mockito.Mock;
    11. 

  11. import org.mockito.Mockito;
    12. 

  12. import org.mockito.runners.MockitoJUnitRunner;
    13. 

  13. import org.openmf.mifos.dataimport.handler.Result;
    14. 

  14. import org.openmf.mifos.dataimport.http.RestClient;
    15. 

  15. import org.openmf.mifos.dataimport.populator.savings.SavingsTransactionWorkbookPopulator;
    16. 

  16. 

  17. @RunWith(MockitoJUnitRunner.class)
    18. 

  18. public class SavingsTransactionWorkbookPopulatorTest {
    19. 

  19. 	
    20. 

  20. 	@Mock
    21. 

  21. 	RestClient restClient;
    22. 

  22. 	
    23. 

  23. 	private static final int LOOKUP_CLIENT_NAME_COL = 15;
    24. 

  24.     private static final int LOOKUP_ACCOUNT_NO_COL = 16;
    25. 

  25.     private static final int LOOKUP_PRODUCT_COL = 17;
    26. 

  26.     private static final int LOOKUP_OPENING_BALANCE_COL = 18;
    27. 

  27. 	
    28. 

  28. 	@Test
    29. 

  29.     public void shouldPopulateLoanRepaymentWorkbook() {
    30. 

  30. 		
    31. 

  31. 		Mockito.when(restClient.get("savingsaccounts?limit=-1")).thenReturn("{\"totalFilteredRecords\": 1,\"pageItems\": [{" +
    32. 

  32.       "\"id\": 6,\"accountNo\": \"000000006\",\"clientId\": 1,\"clientName\": \"Arsene K Wenger\",\"savingsProductId\": 1,\"savingsProductName\": \"SP1\",\"fieldOfficerId\": 1," +
    33. 

  33.       "\"fieldOfficerName\": \"Chatta, Sahil\",\"status\": {\"id\": 300,\"code\": \"savingsAccountStatusType.active\",\"value\": \"Active\",\"submittedAndPendingApproval\": false," +
    34. 

  34.       "\"approved\": false,\"rejected\": false,\"withdrawnByApplicant\": false,\"active\": true,\"closed\": false},\"timeline\": {\"submittedOnDate\": [2013,7,2]," +
    35. 

  35.       "\"approvedOnDate\": [2013,7,3],\"approvedByUsername\": \"mifos\",\"approvedByFirstname\": \"App\",\"approvedByLastname\": \"Administrator\",\"activatedOnDate\": [2013,7,4]}," +
    36. 

  36.       "\"currency\": {\"code\": \"USD\",\"name\": \"US Dollar\",\"decimalPlaces\": 2,\"displaySymbol\": \"$\",\"nameCode\": \"currency.USD\",\"displayLabel\": \"US Dollar ($)\"}," +
    37. 

  37.       "\"nominalAnnualInterestRate\": 8.000000,\"interestCompoundingPeriodType\": {\"id\": 1,\"code\": \"savings.interest.period.savingsCompoundingInterestPeriodType.daily\"," +
    38. 

  38.       "\"value\": \"Daily\"},\"interestPostingPeriodType\": {\"id\": 4,\"code\": \"savings.interest.posting.period.savingsPostingInterestPeriodType.monthly\",\"value\": \"Monthly\"}," +
    39. 

  39.       "\"interestCalculationType\": {\"id\": 1,\"code\": \"savingsInterestCalculationType.dailybalance\",\"value\": \"Daily Balance\"},\"interestCalculationDaysInYearType\": {" +
    40. 

  40.       "\"id\": 365,\"code\": \"savingsInterestCalculationDaysInYearType.days365\",\"value\": \"365 Days\"},\"minRequiredOpeningBalance\": 1200.000000,\"withdrawalFeeForTransfers\": true," +
    41. 

  41.       "\"summary\": {\"currency\": {\"code\": \"USD\",\"name\": \"US Dollar\",\"decimalPlaces\": 2,\"displaySymbol\": \"$\",\"nameCode\": \"currency.USD\",\"displayLabel\": \"US Dollar ($)\"}," +
    42. 

  42.       "\"totalDeposits\": 1300.000000,\"totalWithdrawals\": 200.000000,\"totalInterestEarned\": 19.830000,\"totalInterestPosted\": 15.910000,\"accountBalance\": 1115.910000}}]}");
    43. 

  43. 		
    44. 

  44. 		Mockito.when(restClient.get("clients?limit=-1")).thenReturn("{\"totalFilteredRecords\": 2,\"pageItems\": [{\"id\": 1,\"accountNo\": \"000000001\"," +
    45. 

  45.     	 		"\"status\": {\"id\": 300,\"code\": \"clientStatusType.active\",\"value\": \"Active\"},\"active\": true,\"activationDate\": [2013,7,1]," +
    46. 

  46.     	 		"\"firstname\": \"Arsene\",\"middlename\": \"K\",\"lastname\": \"Wenger\",\"displayName\": \"Arsene K Wenger\",\"officeId\": 1," +
    47. 

  47.     	 		"\"officeName\": \"Head Office\",\"staffId\": 1,\"staffName\": \"Chatta, Sahil\"},{\"id\": 2,\"accountNo\": \"000000002\"," +
    48. 

  48.     	 		"\"status\": {\"id\": 300,\"code\": \"clientStatusType.active\",\"value\": \"Active\"},\"active\": true,\"activationDate\": [2013,7,1]," +
    49. 

  49.     	 		"\"firstname\": \"Billy\",\"middlename\": \"T\",\"lastname\": \"Bob\",\"displayName\": \"Billy T Bob\",\"officeId\": 2,\"officeName\": \"Office1\"," +
    50. 

  50.     	 		"\"staffId\": 2,\"staffName\": \"Dzeko, Edin\"}]}");
    51. 

  51. 		
    52. 

  52. 		Mockito.when(restClient.get("offices?limit=-1")).thenReturn("[{\"id\":1,\"name\":\"Head Office\",\"nameDecorated\":\"Head Office\",\"externalId\": \"1\"," +
    53. 

  53.         		"\"openingDate\":[2009,1,1],\"hierarchy\": \".\"},{\"id\": 2,\"name\": \"Office1\",\"nameDecorated\": \"....Office1\",\"openingDate\":[2013,4,1]," +
    54. 

  54.         		"\"hierarchy\": \".2.\",\"parentId\": 1,\"parentName\": \"Head Office\"}]");
    55. 

  55. 		
    56. 

  56. 		Mockito.when(restClient.get("funds")).thenReturn("[{\"id\": 1,\"name\": \"Fund1\"}]");
    57. 

  57.         Mockito.when(restClient.get("codes/12/codevalues")).thenReturn("[{\"id\": 10,\"name\": \"Cash\",\"position\": 1},{\"id\": 11,\"name\": \"MPesa\",\"position\": 2}]");
    58. 

  58. 

  59. 		SavingsTransactionWorkbookPopulator savingsTransactionWorkbookPopulator = new SavingsTransactionWorkbookPopulator(restClient,
    60. 

  60. 				new OfficeSheetPopulator(restClient), new ClientSheetPopulator(restClient), new ExtrasSheetPopulator(restClient));
    61. 

  61. 	
    62. 

  62. 		savingsTransactionWorkbookPopulator.downloadAndParse();
    63. 

  63.     	
    64. 

  64.     	Workbook savingsTransactionWorkbook = new HSSFWorkbook();
    65. 

  65.     	Result result = savingsTransactionWorkbookPopulator.populate(savingsTransactionWorkbook);
    66. 

  66.     	Assert.assertTrue(result.isSuccess());
    67. 

  67.     	Mockito.verify(restClient, Mockito.atLeastOnce()).get("savingsaccounts?limit=-1");
    68. 

  68.     	Mockito.verify(restClient, Mockito.atLeastOnce()).get("clients?limit=-1");
    69. 

  69.     	Mockito.verify(restClient, Mockito.atLeastOnce()).get("offices?limit=-1");
    70. 

  70.     	Mockito.verify(restClient, Mockito.atLeastOnce()).get("funds");
    71. 

  71.     	Mockito.verify(restClient, Mockito.atLeastOnce()).get("codes/12/codevalues");
    72. 

  72.     	
    73. 

  73.     	Sheet savingsTransactionSheet = savingsTransactionWorkbook.getSheet("SavingsTransaction");
    74. 

  74.     	Row row = savingsTransactionSheet.getRow(0);
    75. 

  75.     	
    76. 

  76.     	//If test fails, also check if column letters embedded in formulas in setDefault and setRules have changed or not.
    77. 

  77.     	Assert.assertEquals("Office Name*", row.getCell(0).getStringCellValue());
    78. 

  78.     	Assert.assertEquals("Client Name*", row.getCell(1).getStringCellValue());
    79. 

  79.     	Assert.assertEquals("Account No.*", row.getCell(2).getStringCellValue());
    80. 

  80.     	Assert.assertEquals("Product Name", row.getCell(3).getStringCellValue());
    81. 

  81.     	Assert.assertEquals("Opening Balance", row.getCell(4).getStringCellValue());
    82. 

  82.     	Assert.assertEquals("Transaction Type*", row.getCell(5).getStringCellValue());
    83. 

  83.     	Assert.assertEquals("Amount*", row.getCell(6).getStringCellValue()); 
    84. 

  84.     	Assert.assertEquals("Date*", row.getCell(7).getStringCellValue()); 
    85. 

  85.     	Assert.assertEquals("Type*", row.getCell(8).getStringCellValue()); 
    86. 

  86.     	Assert.assertEquals("Account No", row.getCell(9).getStringCellValue());
    87. 

  87.     	Assert.assertEquals("Check No", row.getCell(10).getStringCellValue());
    88. 

  88.     	Assert.assertEquals("Routing Code", row.getCell(11).getStringCellValue());
    89. 

  89.     	Assert.assertEquals("Receipt No", row.getCell(12).getStringCellValue());
    90. 

  90.     	Assert.assertEquals("Bank No", row.getCell(13).getStringCellValue());
    91. 

  91.     	Assert.assertEquals("Lookup Client", row.getCell(LOOKUP_CLIENT_NAME_COL).getStringCellValue());
    92. 

  92.     	Assert.assertEquals("Lookup Account", row.getCell(LOOKUP_ACCOUNT_NO_COL).getStringCellValue());
    93. 

  93.     	Assert.assertEquals("Lookup Product", row.getCell(LOOKUP_PRODUCT_COL).getStringCellValue());
    94. 

  94.     	Assert.assertEquals("Lookup Opening Balance", row.getCell(LOOKUP_OPENING_BALANCE_COL).getStringCellValue());
    95. 

  95.     	
    96. 

  96.     	//Lookup Table test
    97. 

  97.     	row = savingsTransactionSheet.getRow(1);
    98. 

  98.     	Assert.assertEquals("Arsene K Wenger(1)", row.getCell(LOOKUP_CLIENT_NAME_COL).getStringCellValue());
    99. 

  99.     	Assert.assertEquals("6.0", ((Double)row.getCell(LOOKUP_ACCOUNT_NO_COL).getNumericCellValue()).toString());
    100. 

  100.     	Assert.assertEquals("SP1", row.getCell(LOOKUP_PRODUCT_COL).getStringCellValue());
    101. 

  101.     	Assert.assertEquals("1200.0", ((Double)row.getCell(LOOKUP_OPENING_BALANCE_COL).getNumericCellValue()).toString());
    102. 

  102. 	
    103. 

  103. 	}
    104. 

  104. 

  105. }
    106. 

  106.