makefile

## Copyright © 2021, Oracle and/or its affiliates. 
## All rights reserved. The Universal Permissive License (UPL), Version 1.0 as shown at http://oss.oracle.com/licenses/upl

SHELL = bash
.ONESHELL:

# Default environment
ENV := dev
ENV_FILE := $(ENV).env

# HELP
# This will output the help for each task
# thanks to https://marmelab.com/blog/2016/02/29/auto-documented-makefile.html
.PHONY: help

help: ## This help.
	@awk 'BEGIN {FS = ":.*?## "} /^[a-zA-Z_-]+:.*?## / {printf "\033[36m%-30s\033[0m %s\n", $$1, $$2}' $(MAKEFILE_LIST)

.DEFAULT_GOAL := help

.PHONY: sql
sql: ## SQLcl shell as APEX ADMIN user
	. ./$(ENV_FILE); \
	echo $$APEX_ADMIN_EMAIL; \
	echo $$WALLET_FILE; \
	export PATH=$$PATH:$(PWD)/sqlcl/bin/; \
	sql -cloudconfig ./$(ENV)-wallet.zip $${APEX_ADMIN_USER}/$${APEX_ADMIN_PWD}@$${DB_SERVICE} 

.PHONY: sql-schema
sql-schema: ## SQLcl shell as SCHEMA user
	. ./$(ENV_FILE); \
	echo $$APEX_ADMIN_EMAIL; \
	echo $$WALLET_FILE; \
	export PATH=$$PATH:$(PWD)/sqlcl/bin/; \
	sql -cloudconfig ./$(ENV)-wallet.zip $${SCHEMA}/$${SCHEMA_ADMIN_PWD}@$${DB_SERVICE} 

.PHONY: wallet
wallet: ## Get the Database wallet
	@ . ./$(ENV_FILE); \
	export WALLET_PWD=`printf $$(xxd -l 14 -p /dev/urandom | tr 'acegikmoqsuwy' 'ACEGIKMOQSUWY')`; \
	[[ ! -f ./$(ENV)-wallet.zip ]] && oci db autonomous-database generate-wallet --autonomous-database-id $${DB_OCID} --file $(ENV)-wallet.zip --password "$${WALLET_PWD}" || echo "Wallet exists"

.PHONY: clean-wallets 
clean-wallets: ## remove the wallets
	@find . -type f -iname \*-wallet.zip -exec rm {} \;

.PHONY: tf-apply
tf-apply: ## Run the terraform stack
	cd terraform; \
	. ./TF_VARS.sh; \
	terraform init; \
	terraform apply

.PHONY: tf-destroy
tf-destroy: clean-wallets ## Destroy the terraform stack
	cd terraform; \
	. ./TF_VARS.sh; \
	terraform destroy

.PHONY: create-apex-admin
create-apex-admin: wallet ## Create the APEX admin user
	. ./$(ENV_FILE); \
	export PATH=$$PATH:$(PWD)/sqlcl/bin/; \
	sql -cloudconfig ./$(ENV)-wallet.zip $${DB_ADMIN_USER}/$${DB_ADMIN_PWD}@$${DB_SERVICE} <<- EOF @./scripts/sql/admin/create_apex_admin.sql "$${APEX_ADMIN_USER}" "$${APEX_ADMIN_PWD}" \
	EOF

.PHONY: delete-apex-admin
delete-apex-admin: wallet ## Delete the APEX admin user
	. ./$(ENV_FILE); \
	export PATH=$$PATH:$(PWD)/sqlcl/bin/; \
	sql -cloudconfig ./$(ENV)-wallet.zip $${DB_ADMIN_USER}/$${DB_ADMIN_PWD}@$${DB_SERVICE} <<- EOF @./scripts/sql/admin/remove_apex_admin.sql "$${APEX_ADMIN_USER}" \
	EOF

.PHONY: create-cloud-creds
create-cloud-creds: wallet ## Create default cloud credential for the APEX ADMIN user to use datapump to Object Storage 
	. ./$(ENV_FILE); \
	export PATH=$$PATH:$(PWD)/sqlcl/bin/; \
	sql -cloudconfig ./$(ENV)-wallet.zip $${DB_ADMIN_USER}/$${DB_ADMIN_PWD}@$${DB_SERVICE} <<- EOF @./scripts/sql/admin/create_cloud_credentials.sql "$${APEX_ADMIN_EMAIL}" "$${APEX_ADMIN_TOKEN}" \
	EOF

.PHONY: create-schema
create-schema: wallet ## Create schema
	. ./$(ENV_FILE); \
	export PATH=$$PATH:$(PWD)/sqlcl/bin/; \
	sql -cloudconfig ./$(ENV)-wallet.zip $${APEX_ADMIN_USER}/$${APEX_ADMIN_PWD}@$${DB_SERVICE} <<- EOF @./scripts/sql/admin/create_schema.sql "$${SCHEMA}" "$${SCHEMA_ADMIN_PWD}" \
	EOF

.PHONY: delete-schema
delete-schema: wallet ## Delete schema
	. ./$(ENV_FILE); \
	export PATH=$$PATH:$(PWD)/sqlcl/bin/; \
	sql -cloudconfig ./$(ENV)-wallet.zip $${APEX_ADMIN_USER}/$${APEX_ADMIN_PWD}@$${DB_SERVICE} <<- EOF @./scripts/sql/admin/remove_schema.sql "$${SCHEMA}" \
	EOF

.PHONY: create-ws
create-ws: create-schema ## Create schema, workspace, add schema to workspace and create workspace admin user
	. ./$(ENV_FILE); \
	export PATH=$$PATH:$(PWD)/sqlcl/bin/; \
	sql -cloudconfig ./$(ENV)-wallet.zip $${APEX_ADMIN_USER}/$${APEX_ADMIN_PWD}@$${DB_SERVICE} <<- EOF @./scripts/sql/admin/create_workspace.sql "$${SCHEMA}" "$${APEX_ADMIN_USER}" "$${WORKSPACE_ADMIN}" "$${WORKSPACE_ADMIN_PWD}" "$${WORKSPACE_ADMIN_EMAIL}" "$${WORKSPACE_NAME}" \
	EOF

.PHONY: delete-ws
delete-ws: wallet ## Delete workspace and its users
	. ./$(ENV_FILE); \
	export PATH=$$PATH:$(PWD)/sqlcl/bin/; \
	sql -cloudconfig ./$(ENV)-wallet.zip $${APEX_ADMIN_USER}/$${APEX_ADMIN_PWD}@$${DB_SERVICE} <<- EOF @./scripts/sql/admin/remove_workspace.sql "$${WORKSPACE_NAME}" "$${WORKSPACE_ADMIN}" \
	EOF

.PHONY: export-app
export-app: wallet ## Export the Apex App. Specify ID=<app_id>
ifndef ID
	$(error ID is not set)
endif
	. ./$(ENV_FILE); \
	export PATH=$$PATH:$(PWD)/sqlcl/bin/; \
	sql -cloudconfig ./$(ENV)-wallet.zip $${SCHEMA}/$${SCHEMA_ADMIN_PWD}@$${DB_SERVICE} <<- EOF @./scripts/sql/change_tracking/export_app.sql $(ID) \
	EOF

.PHONY: import-app
import-app: wallet ## Import the Apex App. Specify ID=<app_id> NEWID=<new_app_id> (defaults to ID)
ifndef ID
	@echo ID is not set
	@exit 1
endif
ifndef NEWID
	$(eval NEWID := $(ID))
endif
	@. ./$(ENV_FILE); \
	export PATH=$$PATH:$(PWD)/sqlcl/bin/; \
	sql -cloudconfig ./$(ENV)-wallet.zip $${SCHEMA}/$${SCHEMA_ADMIN_PWD}@$${DB_SERVICE} <<- EOF @./scripts/sql/change_tracking/apex_install_overrides.sql "$${WORKSPACE_NAME}" "$${SCHEMA}" $(ID) $(NEWID) "apps/f$(ID).sql" \
	EOF

.PHONY: changelog
changelog: wallet ## Generate a new Change Log for the schema
	. ./$(ENV_FILE); \
	export PATH=$$PATH:$(PWD)/sqlcl/bin/; \
	sql -cloudconfig ./$(ENV)-wallet.zip $${SCHEMA}/$${SCHEMA_ADMIN_PWD}@$${DB_SERVICE} <<- EOF @./scripts/sql/change_tracking/gen_schema.sql \
	EOF

.PHONY: update-schema
update-schema: wallet ## Apply the Change Log to the schema
	. ./$(ENV_FILE); \
	export PATH=$$PATH:$(PWD)/sqlcl/bin/; \
	sql -cloudconfig ./$(ENV)-wallet.zip $${SCHEMA}/$${SCHEMA_ADMIN_PWD}@$${DB_SERVICE} <<- EOF @./scripts/sql/change_tracking/apply_changelog.sql \
	EOF

.PHONY: rollback-schema
rollback-schema: wallet ## Rollback all Change Logs
	. ./$(ENV_FILE); \
	export PATH=$$PATH:$(PWD)/sqlcl/bin/; \
	sql -cloudconfig ./$(ENV)-wallet.zip $${SCHEMA}/$${SCHEMA_ADMIN_PWD}@$${DB_SERVICE} <<- EOF @./scripts/sql/change_tracking/rollback.sql \
	EOF

.PHONY: snapshot
snapshot: export-app changelog ## Create a new change Log, and export the app. Specify ID=<app_id>

.PHONY: update
update: update-schema import-app ## Apply the Change Log & import the app. Specify ID=<app_id> NEWID=<new_app_id> (defaults to ID)

.PHONY: rollback
rollback: rollback-schema import-app ## Rollback changes. Specify ID=<app_id> NEWID=<new_app_id>

.PHONY: init
init: clean-wallets tf-apply ## Deploy the database(s) and setup all the defined environments
	find . -type f -iname \*.env | awk -F"." '{print $$2}' | tr -d "/" | xargs -I{} make create-apex-admin ENV={}
	find . -type f -iname \*.env | awk -F"." '{print $$2}' | tr -d "/" | xargs -I{} make create-ws ENV={}

.PHONY: test
test: ## Test (WIP)
	echo "running tests"