Oracle: delius-core-stage-delius-oracle-statistics #47
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name: "Oracle: Statistics" | |
| run-name: "Oracle: ${{ github.event.inputs.TargetEnvironment }}-delius-oracle-statistics" | |
| on: | |
| workflow_dispatch: | |
| inputs: | |
| TargetEnvironment: | |
| description: "Target environment" | |
| required: true | |
| type: choice | |
| options: | |
| - "delius-core-dev" | |
| - "delius-core-test" | |
| - "delius-core-training" | |
| - "delius-core-stage" | |
| - "delius-core-preprod" | |
| - "delius-core-prod" | |
| GatherNewStatistics: | |
| description: "Gather new statistics for Delius database." | |
| type: choice | |
| default: "no" | |
| options: | |
| - "no" | |
| - "yes" | |
| GatherParallelism: | |
| description: "Degree of Parallelism to use for gathering new statistics (ignored if GatherNewStatistics = no)." | |
| type: choice | |
| default: "1" | |
| options: | |
| - "1" | |
| - "2" | |
| - "4" | |
| - "8" | |
| - "16" | |
| - "32" | |
| ExportBackupStatisticsToS3: | |
| description: "Use Data Pump to export a backup of the current statistics and copy the file to S3." | |
| type: choice | |
| default: "no" | |
| options: | |
| - "no" | |
| - "yes" | |
| StatisticsIdentifier: | |
| description: "Optional identifier for Statistics export." | |
| type: string | |
| default: "" | |
| ImportSourceEnvironment: | |
| description: "Source environment for import of statistics." | |
| default: "None" | |
| type: choice | |
| options: | |
| - "None" | |
| - "delius-core-dev" | |
| - "delius-core-stage" | |
| - "delius-core-preprod" | |
| VerboseOutput: | |
| description: "Verbose Output level" | |
| type: choice | |
| default: "" | |
| options: | |
| - "" | |
| - "-vv" | |
| - "-vvv" | |
| - "-vvvv" | |
| SourceCodeVersion: | |
| description: "Source version for the hmpps-delius-operation-automation. Enter a pull request, branch, commit ID, tag, or reference." | |
| type: string | |
| default: "main" | |
| SourceConfigVersion: | |
| description: "Source version for the modernisation-platform-configuration-management. Enter a pull request, branch, commit ID, tag, or reference." | |
| type: string | |
| default: "main" | |
| env: | |
| ansible_config: operations/playbooks/ansible.cfg | |
| command: ansible-playbook operations/playbooks/oracle_statistics/oracle_statistics.yml | |
| inventory: inventory/ansible | |
| permissions: | |
| contents: read | |
| packages: read | |
| id-token: write | |
| jobs: | |
| oracle_gather_delius_statistics: | |
| if: ${{ github.event.inputs.ImportSourceEnvironment == 'None' }} | |
| name: oracle-gather-delius-statistics | |
| environment: ${{ github.event.inputs.TargetEnvironment }} | |
| runs-on: ubuntu-latest | |
| container: | |
| image: ghcr.io/ministryofjustice/hmpps-delius-operational-automation:0.78.0 | |
| timeout-minutes: 1440 | |
| continue-on-error: false | |
| steps: | |
| - name: Prepare Target Name | |
| id: preparetargetname | |
| run: echo TargetHost="environment_name_$(echo ${{ github.event.inputs.TargetEnvironment }} | sed 's/delius-core-dev/delius_core_development_dev/;s/delius-core-test/delius_core_test_test/;s/delius-core-training/delius_core_test_training/;s/delius-core-stage/delius_core_preproduction_stage/;s/delius-core-preprod/delius_core_preproduction_preprod/;s/delius-core-prod/delius_core_production_prod/')_delius_primarydb" >> $GITHUB_OUTPUT | |
| - name: Checkout Ansible Playbooks and Roles From hmpps-delius-operation-automation | |
| uses: actions/checkout@v4 | |
| with: | |
| sparse-checkout-cone-mode: false | |
| sparse-checkout: | | |
| playbooks/oracle_statistics | |
| playbooks/ansible.cfg | |
| path: operations | |
| ref: ${{ github.event.inputs.SourceCodeVersion }} | |
| fetch-depth: 0 | |
| - name: Checkout Ansible Inventory From modernisation-platform-configuration-management | |
| uses: actions/checkout@v4 | |
| with: | |
| repository: ministryofjustice/modernisation-platform-configuration-management | |
| sparse-checkout-cone-mode: false | |
| sparse-checkout: | | |
| ansible/hosts | |
| ansible/group_vars | |
| path: inventory | |
| ref: ${{ github.event.inputs.SourceConfigVersion }} | |
| fetch-depth: 0 | |
| - name: Configure AWS Credentials | |
| id: login-aws | |
| uses: aws-actions/configure-aws-credentials@v4 | |
| with: | |
| role-to-assume: "arn:aws:iam::${{ vars.AWS_ACCOUNT_ID }}:role/modernisation-platform-oidc-cicd" | |
| role-session-name: "hmpps-delius-operational-automation-${{ github.run_number }}" | |
| role-duration-seconds: 21600 | |
| aws-region: "eu-west-2" | |
| - name: Start Ansible Gather Delius Statistics | |
| shell: bash | |
| run: | | |
| export ANSIBLE_CONFIG=$ansible_config | |
| $command -i $inventory -e ansible_aws_ssm_bucket_name=${{ vars.ANSIBLE_AWS_SSM_BUCKET_NAME }} \ | |
| -e hosts=${{ steps.preparetargetname.outputs.TargetHost }} \ | |
| -e import_source_environment=None \ | |
| -e gather_new_statistics=${{ github.event.inputs.GatherNewStatistics }} \ | |
| -e statistics_identifier=${{ github.event.inputs.StatisticsIdentifier }} \ | |
| -e export_to_s3=${{ github.event.inputs.ExportBackupStatisticsToS3 }} \ | |
| -e parallelism=${{ github.event.inputs.GatherParallelism }} ${{ github.event.inputs.VerboseOutput }} | |
| oracle_export_delius_statistics: | |
| if: ${{ github.event.inputs.ImportSourceEnvironment != 'None' }} | |
| name: oracle-export-delius-statistics | |
| environment: ${{ github.event.inputs.ImportSourceEnvironment }} | |
| runs-on: ubuntu-latest | |
| container: | |
| image: ghcr.io/ministryofjustice/hmpps-delius-operational-automation:0.78.0 | |
| timeout-minutes: 1440 | |
| continue-on-error: false | |
| outputs: | |
| RemoteStatisticsIdentifier: ${{ steps.preparetargetname.outputs.RemoteStatisticsIdentifier }} | |
| steps: | |
| - name: Prepare Target Name And Remote Statistics Identifier | |
| id: preparetargetname | |
| shell: bash | |
| run: | | |
| echo TargetHost="environment_name_$(echo ${{ github.event.inputs.ImportSourceEnvironment }} | sed 's/delius-core-dev/delius_core_development_dev/;s/delius-core-test/delius_core_test_test/;s/delius-core-training/delius_core_test_training/;s/delius-core-stage/delius_core_preproduction_stage/;s/delius-core-preprod/delius_core_preproduction_preprod/;s/delius-core-prod/delius_core_production_prod/')_delius_primarydb" >> $GITHUB_OUTPUT | |
| if [[ -z ${{ github.event.inputs.StatisticsIdentifier }} ]] | |
| then | |
| DATE=$(date +"%Y%m%dT%H%M%S") | |
| ENV=$(echo ${{ github.event.inputs.ImportSourceEnvironment }} | awk -F- '{print $NF}') | |
| RemoteStatisticsIdentifier="${ENV^^}_${DATE}" | |
| else | |
| RemoteStatisticsIdentifier="${{ github.event.inputs.StatisticsIdentifier }}" | |
| fi | |
| echo RemoteStatisticsIdentifier="${RemoteStatisticsIdentifier}" >> $GITHUB_OUTPUT | |
| - name: Checkout Ansible Playbooks and Roles From hmpps-delius-operation-automation | |
| uses: actions/checkout@v4 | |
| with: | |
| sparse-checkout-cone-mode: false | |
| sparse-checkout: | | |
| playbooks/oracle_statistics | |
| playbooks/ansible.cfg | |
| path: operations | |
| ref: ${{ github.event.inputs.SourceCodeVersion }} | |
| fetch-depth: 0 | |
| - name: Checkout Ansible Inventory From modernisation-platform-configuration-management | |
| uses: actions/checkout@v4 | |
| with: | |
| repository: ministryofjustice/modernisation-platform-configuration-management | |
| sparse-checkout-cone-mode: false | |
| sparse-checkout: | | |
| ansible/hosts | |
| ansible/group_vars | |
| path: inventory | |
| ref: ${{ github.event.inputs.SourceConfigVersion }} | |
| fetch-depth: 0 | |
| - name: Configure AWS Credentials | |
| id: login-aws | |
| uses: aws-actions/configure-aws-credentials@v4 | |
| with: | |
| role-to-assume: "arn:aws:iam::${{ vars.AWS_ACCOUNT_ID }}:role/modernisation-platform-oidc-cicd" | |
| role-session-name: "hmpps-delius-operational-automation-${{ github.run_number }}" | |
| role-duration-seconds: 21600 | |
| aws-region: "eu-west-2" | |
| - name: Start Ansible Export Delius Statistics From Remote Environment | |
| shell: bash | |
| run: | | |
| export ANSIBLE_CONFIG=$ansible_config | |
| $command -i $inventory -e ansible_aws_ssm_bucket_name=${{ vars.ANSIBLE_AWS_SSM_BUCKET_NAME }} \ | |
| -e hosts=${{ steps.preparetargetname.outputs.TargetHost }} \ | |
| -e import_source_environment=${{ github.event.inputs.ImportSourceEnvironment }} \ | |
| -e gather_new_statistics=no \ | |
| -e statistics_identifier=${{ steps.preparetargetname.outputs.RemoteStatisticsIdentifier }} \ | |
| -e export_to_s3=yes \ | |
| -e parallelism=${{ github.event.inputs.GatherParallelism }} ${{ github.event.inputs.VerboseOutput }} | |
| oracle_import_delius_statistics: | |
| needs: oracle_export_delius_statistics | |
| name: oracle-import-delius-statistics | |
| environment: ${{ github.event.inputs.TargetEnvironment }} | |
| runs-on: ubuntu-latest | |
| container: | |
| image: ghcr.io/ministryofjustice/hmpps-delius-operational-automation:0.78.0 | |
| timeout-minutes: 1440 | |
| continue-on-error: false | |
| steps: | |
| - name: Prepare Target Name | |
| id: preparetargetname | |
| run: echo TargetHost="environment_name_$(echo ${{ github.event.inputs.TargetEnvironment }} | sed 's/delius-core-dev/delius_core_development_dev/;s/delius-core-test/delius_core_test_test/;s/delius-core-training/delius_core_test_training/;s/delius-core-stage/delius_core_preproduction_stage/;s/delius-core-preprod/delius_core_preproduction_preprod/;s/delius-core-prod/delius_core_production_prod/')_delius_primarydb" >> $GITHUB_OUTPUT | |
| - name: Checkout Ansible Playbooks and Roles From hmpps-delius-operation-automation | |
| uses: actions/checkout@v4 | |
| with: | |
| sparse-checkout-cone-mode: false | |
| sparse-checkout: | | |
| playbooks/oracle_statistics | |
| playbooks/ansible.cfg | |
| path: operations | |
| ref: ${{ github.event.inputs.SourceCodeVersion }} | |
| fetch-depth: 0 | |
| - name: Checkout Ansible Inventory From modernisation-platform-configuration-management | |
| uses: actions/checkout@v4 | |
| with: | |
| repository: ministryofjustice/modernisation-platform-configuration-management | |
| sparse-checkout-cone-mode: false | |
| sparse-checkout: | | |
| ansible/hosts | |
| ansible/group_vars | |
| path: inventory | |
| ref: ${{ github.event.inputs.SourceConfigVersion }} | |
| fetch-depth: 0 | |
| - name: Configure AWS Credentials | |
| id: login-aws | |
| uses: aws-actions/configure-aws-credentials@v4 | |
| with: | |
| role-to-assume: "arn:aws:iam::${{ vars.AWS_ACCOUNT_ID }}:role/modernisation-platform-oidc-cicd" | |
| role-session-name: "hmpps-delius-operational-automation-${{ github.run_number }}" | |
| role-duration-seconds: 21600 | |
| aws-region: "eu-west-2" | |
| - name: Start Ansible Import Delius Statistics From Remote Environment | |
| shell: bash | |
| run: | | |
| export ANSIBLE_CONFIG=$ansible_config | |
| $command -i $inventory -e ansible_aws_ssm_bucket_name=${{ vars.ANSIBLE_AWS_SSM_BUCKET_NAME }} \ | |
| -e hosts=${{ steps.preparetargetname.outputs.TargetHost }} \ | |
| -e import_source_environment=${{ github.event.inputs.ImportSourceEnvironment }} \ | |
| -e gather_new_statistics=no \ | |
| -e statistics_identifier=${{ needs.oracle_export_delius_statistics.outputs.RemoteStatisticsIdentifier }} \ | |
| -e export_to_s3=no \ | |
| -e parallelism=${{ github.event.inputs.GatherParallelism }} ${{ github.event.inputs.VerboseOutput }} |