prereq: oci cli must be working in oci cloud shell
Open oci cloud shell
Run git clone https://github.com/mikarinneoracle/atp-ords-liquibase-demo.git
Edit script.sh with oci code editor
=> add your oci compartment by replacing <YOUR COMPARTMENT OCID> and the region if necessary (lines 1-2):
export region='eu-amsterdam-1' export compt_ocid='<YOUR COMPARTMENT OCID>'
Note: Just make sure you are running the Cloud Shell in the same region as this one.
Run sh script.sh
Script will create "pricing" ATP instance and update the database with a schema, ORDS and APEX with Liquibase. Then it will update the html content with generated url's and upload the the content to the "pricing" Object Storage bucket.
Access pricing bucket from your browser and open the index.html
Access APEX "price admin" application from the Admin -link on the page.
APEX user is priceadmin and password is WelcomeFolks123#!
Edit prices and options and then save and reload the html page.
After making sure the html page works (do a few reloads to the page if necessary) delete resources manually.
Part 2 - deploying single page app with ATP, ORDS and APEX using Terraform (oci resource manager stack and JSON) from cloud shell
Open oci cloud shell
Run git clone https://github.com/mikarinneoracle/atp-ords-liquibase-demo.git
Edit script-tf-json.sh with oci code editor
=> add your oci compartment by replacing <YOUR COMPARTMENT OCID> and the region if necessary (lines 1-2):
export region='eu-amsterdam-1' export compt_ocid='<YOUR COMPARTMENT OCID>'
Note: Just make sure you are running the Cloud Shell in the same region as this one.
You can also set the always-free to true if you want to use the always-free option of the ATP in
vars.json.
Run sh script-tf-json.sh
Note: If you run Part 2 right after Part 1, first delete the "pricing" resources manually (ATP and Object Storage).
Script will run in 2 parts.
First it will create a Resource Manager Terraform Stack and update it with vars.json to create the infra for the same resources as in Part 1.
Then it will update the RM Terraform Stack with vars.json having the generated url's and run the Stack again to update the html content in Object Storage.
Note: In case you wonder the terraform (RM Stack) does not use oci cli. It uses local-exec but not oci cli.
Access pricing bucket from your browser and open the index.html
Access APEX "price admin" application from the Admin -link on the page.
APEX user is priceadmin and password is WelcomeFolks123#!
Edit prices and options and then save and reload the html page.
After making sure the html page works (do a few reloads to the page if necessary) delete all created resources with Terraform by clicking destroy on the RM Stack in the cloud console.