Simple Java program
Budget: ₹600 – ₹1,500 INR
We need to fetch the data from database (result returned as json)
1. we have list of unique id stored in Map.
2. we have to iterate the Map and take each id and using that id search it in database.
3. Database search returns the result in json.
4. We have to parse the json and store as key value (key will be attributes name and value bill be atributes value from json) and stored against each id from previous MAP
5. We have to store all records from json in MAP
6. Read csv/txt file, it has 3 line in it, all 3 lines have fixed length.
7. All line has some attributes as fixed value some attributes as value to be change
8. Line 1 and line 3 are fixed, it can not be multiple line.
9. Line 2 can be multiple, e.g: if we store 5 value in Map and we fetch all 5 value from database and parse json, we have to add all 5 set of data in line 2.
10. it means line 2 start with first data and than it goes to line 3, 4, 5, 6 and than line 3 goes to line 7.
11. So line 1 will always be line 1 and line 3 will be always last line and from line 2 it depends on number of record. I have attached example txt file for reference.
12. The value which is value to be change will get replace with the value which we have parsed from json and stored in MAP. so we have to iterate MAP and replace the value
13. Than we have to create csv file based on new record.
14. we should not have any spaces in the file.
1. we have list of unique id stored in Map.
2. we have to iterate the Map and take each id and using that id search it in database.
3. Database search returns the result in json.
4. We have to parse the json and store as key value (key will be attributes name and value bill be atributes value from json) and stored against each id from previous MAP
5. We have to store all records from json in MAP
6. Read csv/txt file, it has 3 line in it, all 3 lines have fixed length.
7. All line has some attributes as fixed value some attributes as value to be change
8. Line 1 and line 3 are fixed, it can not be multiple line.
9. Line 2 can be multiple, e.g: if we store 5 value in Map and we fetch all 5 value from database and parse json, we have to add all 5 set of data in line 2.
10. it means line 2 start with first data and than it goes to line 3, 4, 5, 6 and than line 3 goes to line 7.
11. So line 1 will always be line 1 and line 3 will be always last line and from line 2 it depends on number of record. I have attached example txt file for reference.
12. The value which is value to be change will get replace with the value which we have parsed from json and stored in MAP. so we have to iterate MAP and replace the value
13. Than we have to create csv file based on new record.
14. we should not have any spaces in the file.