stop-qa-workflow.yaml

stop-qa-workflow.yaml

- name: 'Check Running DB Instance'
  run: |
    echo "::set-env name=DB_STATE::$( \
        oci db autonomous-database get \
        --autonomous-database-id ${{ secrets.AUTONOMOUS_DB_OCID }} \
        --query "data.\"lifecycle-state\"" \
        --raw-output \
    )"
- name: 'Stop DB'
  if: ${{env.DB_STATE == 'AVAILABLE'}}
  run: |
    oci db autonomous-database stop \
      --autonomous-database-id  ${{ secrets.AUTONOMOUS_DB_OCID }}
- name: 'Check Running VM Instance'
  run: |
    echo "::set-env name=INSTANCE_OCID::$( \
     oci compute instance list \
     --lifecycle-state RUNNING \
     --compartment-id ${{secrets.VM_COMPARTMENT_OCID}} \
     --display-name ${{env.INSTANCE_NAME}} \
     --query "data [0].id" \
     --raw-output \
    )"
- name: 'Stop VM'
  if: ${{env.INSTANCE_OCID}}
  run: |
    oci compute instance action \
      --action stop \
      --instance-id ${{ env.INSTANCE_OCID }}