dheepak-aot commented 3 weeks ago

ECert feedback file processing Part 2

Remove the existing column

[x] DB Migration to remove the existing obsolete column error_code and drop the unique constraint based on error_code and add a unique constraint to use ecert_feedback_error_id
[x] Removed errorCode from the entity object
[x] Updated the IER12 code portion which was using the error code from disbursement_feedback_error to use error code from relationship eCertFeedbackError

[x] Created a service to get the key value pair of e-Cert feedback error code and it's respective error id in the table sims.ecert_feedback_errors. example:
```
{
"ERR01" : 1,
"ERR10" : 2
}
```
Note: Having the error code map will avoid going to database every time to get the error id for a given error code to create a feedback error record
[x] Updated ECert file handler to use the error code map and create feedback entries to disbursement_feedback_errors using the error id of the respective error code received.
[x] Updated ECert file handler to throw error and abort the processing of the file when one or more received error codes are not present in the system (in the table sims.ecert_feedback_errors. As per business we are suppose to get new error codes if introduced well in advance from federal.