Plan for Creation of Oracle Database API

[marcellmueller]

Description:

Development spike to get access to the Oracle database via an API. More refinement on this is needed but I think the general idea will be to deploy the nr-oracle-service chart to OpenShift then access it via an API. The nr-epd-organics-info docs have instructions on how they do local development while connecting to the Oracle database via their API.

It would be amazing if this resulted in the ability to access the api locally similar to the local development instructions here:

https://github.com/bcgov/nr-epd-organics-info

Relevant repos repos:

helm chart that exposes a openshift service endpoint to get JSON over
https://github.com/bcgov/nr-oracle-service

this product is using that Helm Chart
https://github.com/bcgov/nr-epd-organics-info/blob/main/backend/src/v1/ams-oracle-connector/ams.oracle.connector.service.ts

Sample query that gets passed over to nr-oracle-service and json response is recieved, https://github.com/bcgov/nr-epd-organics-info/blob/main/backend/src/v1/ams-oracle-connector/omrr-query.ts

Dependencies

• Blocked by Set up OpenShift development namespace #69

Acceptance Criteria:

• plan to implement an oracle api (#90)
  • details to be added to #90

[JLWade]

@mishraomp hoping you can take lead and assist Marcel with this one