Challenge Overview
For this challenge, we'd like to switch identity-service app to postgres from Informix database.
Detailed Specification
- First setup identity-service application with existing Informix DB. Refer to source code & Readme.md available at zip folder. Also refer Readme.md under “Docker” folder Note: The readme.md document has generic setup written, feel free to update environment variables per your system need. (Informix DB setup is part of this source)
- Clone repo https://github.com/topcoder-platform/informix-postgres-migrator/tree/master/tc-database-scripts/. And setup postgres DB by running docker-compose command. (refer Readme.md)
- Figure out Informix DB connection/queries and migrate Identity-Service app fully to Postgres 9.6. Ignore other DB Items.
- Figure out unit-test approach & cases for all Postgres DB related use-cases. Automation of unit test-cases encouraged.
- Figure out functionality test-case approach & cases related to Postgres DB operation. For example: /sourcecode/docker/readme.md#identity-service paragraph has POST example with DB operation. And /sourcecode/readme.md#verify has DB transaction. Leverage folder “doc/groups” json collection. This postman collection mostly covers functionality/DB related transaction.
Final Submission Guidelines
- Modified Code for Postgres. It’s better to submit the code changes as patch.(but this is optional).
- Matrix for functionality/unit-test case and Automation Scripts. Expectations is 100% pass.
- Clear Setup documentation.