Cache Implementation For Account Additional Config

What is the purpose of this article?

This article contains all the logical steps to implement cache for account additional config which contains the details about risk score settings

What are the steps to achieve the above task?

1. We create a function named: fetchAccountAdditionalConfig(String accountSlug, Boolean forceRefresh)

2. In this function(method) we first create cacheKey using following rule, the cacheKey will have two key

   1. static = Account_Additional_Config

   2. dynamic = accountSlug

   3. we will create cacheKey by concatenating static and dynamic key e.g. “Account_Additional_Config” + “_” +”accountSlug”

3. If we get forceRefresh

   1. True then we will fetch details from DB using query given below and set into Cache against the cacheKey prepared Above and also return these details to calling method

      SELECT account_additional_config.isRiskScoreEnabled FROM accounts LEFT JOIN account_additional_config ON accounts.id = account_additional_config.account_id WHERE accounts.account_slug = "tab"

   2. False we simply get details from cache using cache key

4. We will use forceRefresh as True when we receive event related to setting change request from Workspace event Structure will be:

   { "resource": "accounts", "eventType": "PUT", "eventSubType": "riskScore", "accountSlug": "tab", "accountId": 758, "actor": "SYSTEM", "version": "v1", "request_data": [], "response_data": { "country": null, "workspace": "tab", "partnerCode": "617391", "accountName": "tab", "city": null, "contactPerson": "Tabassum Ansari", "bankName": null, "type": "0", "gstin": null, "branch": null, "workspaceStatus": "1", "isBatching": "0", "cancelledChequeScannedCopy": null, "stepsCompleted": 5, "createdAt": "2021-05-01T08:51:48.000Z", "contractUrl": null, "accountSlug": "tab", "addressLine1": null, "addressLine2": null, "id": 758, "state": null, "ifscCode": null, "email": "tabassum.ansari@eshopbox.com", "updatedAt": "2023-03-17T12:37:00.000Z", "pincode": null, "updatedBy": null, "panNumber": null, "accountNumber": null, "isRiskScoreEnabled": "1", "phone": null, "createdBy": null, "warehouseId": null, "clientCode": "T758", "pancardScannedCopy": null, "status": "1" }, "previous_data": [], "resource_type": "accountAdditionalConfig.update", "account_slug": "tab", "custom": [] }

5. We get hit on /_ah/api/esb/v1/accountAdditionalConfigCacheRefresh with above event as request body

6. We get resource, eventSubType, and accountSlug, from the event

7. if resource == account and eventSubType == riskScore then we will call fetchAccountAdditionalConfig(accountSlug:”tab”, forceRefresh:true); it will update the cache for accountAdditionalConfig