Enhance Parameter Store examples with comments and formatting #644
Workflow file for this run
This file contains hidden or 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: tests | |
| on: push | |
| jobs: | |
| run_tests: | |
| runs-on: ubuntu-latest | |
| env: | |
| AZURE_TENANT_ID: ${{ secrets.TEST_AZURE_TENANT_ID }} | |
| AZURE_CLIENT_ID: ${{ secrets.TEST_AZURE_CLIENT_ID }} | |
| AZURE_CLIENT_SECRET: ${{ secrets.TEST_AZURE_CLIENT_SECRET }} | |
| AZURE_USERNAME: ${{ secrets.TEST_AZURE_USERNAME }} | |
| AZURE_PASSWORD: ${{ secrets.TEST_AZURE_PASSWORD }} | |
| AZURE_CLIENT_CERTIFICATE_PATH: ${{ secrets.TEST_AZURE_CLIENT_CERTIFICATE_PATH }} | |
| AWS_REGION: ${{ secrets.TEST_AWS_REGION }} | |
| AWS_ACCESS_KEY_ID: ${{ secrets.TEST_AWS_ACCESS_KEY_ID }} | |
| AWS_SECRET_ACCESS_KEY: ${{ secrets.TEST_AWS_SECRET_ACCESS_KEY }} | |
| VAULT_ADDR: ${{ secrets.TEST_VAULT_ADDR }} | |
| HCP_ORG_ID: ${{ secrets.TEST_HCP_ORG_ID }} | |
| HCP_PROJECT_ID: ${{ secrets.TEST_HCP_PROJECT_ID }} | |
| HCP_APP_NAME: ${{ secrets.TEST_HCP_APP_NAME }} | |
| steps: | |
| - name: Checkout the repository | |
| uses: actions/checkout@v4 | |
| - name: Set up JDK 11 | |
| uses: actions/setup-java@v1 | |
| with: | |
| java-version: 11 | |
| - name: Cache Maven packages | |
| uses: actions/cache@v4 | |
| with: | |
| path: ~/.m2 | |
| key: ${{ runner.os }}-m2-${{ hashFiles('**/pom.xml') }} | |
| restore-keys: ${{ runner.os }}-m2 | |
| - name: Install dependencies | |
| run: mvn install -DskipTests | |
| - name: Set GCP environment variables | |
| run : | | |
| echo "GOOGLE_APPLICATION_CREDENTIALS=$HOME/.gcp/config.json" >> $GITHUB_ENV | |
| - name: Prepare certificate and properties files | |
| run: | | |
| mkdir -p $HOME/.azure | |
| mkdir -p $HOME/.oci | |
| mkdir -p $HOME/.gcp | |
| # Prepare certificate | |
| echo "${{ secrets.TEST_AZURE_CERTIFICATE }}" > $HOME/.azure/ojdbc-plugin-test-app.pem | |
| # Generate oci config | |
| echo "${{ secrets.TEST_OCI_API_KEY }}" > $HOME/.oci/oci-api-key.pem | |
| echo "${{ secrets.TEST_OCI_CONFIG_PROFILE }}" > $HOME/.oci/config | |
| # Convert .pem to .pfx file | |
| openssl pkcs12 -export -in ${{ secrets.TEST_AZURE_CLIENT_CERTIFICATE_PATH }} -passout pass:${{ secrets.TEST_AZURE_CLIENT_PFX_PASSWORD }} -out ojdbc-provider-azure/ojdbc-provider-test-app.pfx | |
| # Generate ojdbc-provider-azure/test.properties | |
| echo -e "AZURE_MANAGED_IDENTITY=false\n | |
| AZURE_TENANT_ID=${{ secrets.TEST_AZURE_TENANT_ID }}\n | |
| AZURE_CLIENT_ID=${{ secrets.TEST_AZURE_CLIENT_ID }}\n | |
| AZURE_CLIENT_SECRET=${{ secrets.TEST_AZURE_CLIENT_SECRET }}\n | |
| AZURE_CLIENT_CERTIFICATE_PATH=${{ secrets.TEST_AZURE_CLIENT_CERTIFICATE_PATH }}\n | |
| AZURE_CLIENT_PFX_CERTIFICATE_PATH=./ojdbc-provider-test-app.pfx\n | |
| AZURE_CLIENT_PFX_PASSWORD=${{ secrets.TEST_AZURE_CLIENT_PFX_PASSWORD }}\n | |
| AZURE_USERNAME=${{ secrets.TEST_AZURE_USERNAME }}\n | |
| AZURE_PASSWORD=${{ secrets.TEST_AZURE_PASSWORD }}\n | |
| AZURE_TOKEN_SCOPE=${{ secrets.TEST_AZURE_TOKEN_SCOPE }}\n | |
| AZURE_APP_CONFIG_NAME=${{ secrets.TEST_AZURE_APP_CONFIG_NAME }}\n | |
| AZURE_APP_CONFIG_KEY=${{ secrets.TEST_AZURE_APP_CONFIG_KEY }}\n | |
| AZURE_APP_CONFIG_KEY_INVALID_PROPERTIES=${{ vars.TEST_AZURE_APP_CONFIG_KEY_INVALID_PROPERTIES }}\n | |
| AZURE_APP_CONFIG_KEY_NON_WHITELISTED_PROPERTIES=${{ vars.TEST_AZURE_APP_CONFIG_KEY_NON_WHITELISTED_PROPERTIES }}\n | |
| AZURE_APP_CONFIG_LABEL=${{ secrets.TEST_AZURE_APP_CONFIG_LABEL }}\n | |
| AZURE_KEY_VAULT_URL=${{ secrets.TEST_AZURE_KEY_VAULT_URL }}\n | |
| AZURE_KEY_VAULT_SECRET_NAME=${{ secrets.TEST_AZURE_KEY_VAULT_SECRET_NAME }}\n | |
| AZURE_KEY_VAULT_SECRET_PAYLOAD_NAME=${{ secrets.TEST_AZURE_KEY_VAULT_SECRET_PAYLOAD_NAME }}\n | |
| AZURE_KEY_VAULT_SECRET_PAYLOAD_NAME_MULTIPLE_KEYS=${{ secrets.TEST_AZURE_KEY_VAULT_SECRET_PAYLOAD_NAME_MULTIPLE_KEYS }}\n | |
| AZURE_KEY_VAULT_SECRET_PAYLOAD_KEY=${{ secrets.TEST_AZURE_KEY_VAULT_SECRET_PAYLOAD_KEY }}\n | |
| AZURE_PKCS12_TLS_WALLET_SECRET_NAME=${{ secrets.TEST_AZURE_PKCS12_TLS_WALLET_SECRET_NAME }}\n | |
| AZURE_PKCS12_TLS_WALLET_PASSWORD=${{ secrets.TEST_AZURE_PKCS12_TLS_WALLET_PASSWORD }}\n | |
| AZURE_SSO_TLS_WALLET_SECRET_NAME=${{ secrets.TEST_AZURE_SSO_TLS_WALLET_SECRET_NAME }}\n | |
| AZURE_PEM_TLS_WALLET_SECRET_NAME=${{ secrets.TEST_AZURE_PEM_TLS_WALLET_SECRET_NAME }}\n | |
| AZURE_PEM_TLS_WALLET_PASSWORD=${{ secrets.TEST_AZURE_PEM_TLS_WALLET_PASSWORD }}\n | |
| AZURE_CORRUPTED_TLS_WALLET_SECRET_NAME=${{ secrets.TEST_AZURE_CORRUPTED_TLS_WALLET_SECRET_NAME }}\n | |
| AZURE_PKCS12_SEPS_WALLET_SECRET_NAME=${{ secrets.TEST_AZURE_PKCS12_SEPS_WALLET_SECRET_NAME }}\n | |
| AZURE_PKCS12_SEPS_WALLET_PASSWORD=${{ secrets.TEST_AZURE_PKCS12_SEPS_WALLET_PASSWORD }}\n | |
| AZURE_SSO_SEPS_WALLET_SECRET_NAME=${{ secrets.TEST_AZURE_SSO_SEPS_WALLET_SECRET_NAME }}\n | |
| AZURE_CORRUPTED_SEPS_WALLET_SECRET_NAME=${{ secrets.TEST_AZURE_CORRUPTED_SEPS_WALLET_SECRET_NAME }}\n | |
| AZURE_SEPS_CONNECTION_STRING_INDEX=${{ secrets.TEST_AZURE_SEPS_CONNECTION_STRING_INDEX }}\n | |
| AZURE_TNS_NAMES_SECRET_NAME=${{ secrets.TEST_AZURE_TNS_NAMES_SECRET_NAME }}\n | |
| AZURE_TNS_ALIAS_SECRET_NAME=${{ secrets.TEST_AZURE_TNS_ALIAS_SECRET_NAME }}\n | |
| AZURE_NON_BASE64_TNS_NAMES_SECRET_NAME=${{ secrets.TEST_AZURE_NON_BASE64_TNS_NAMES_SECRET_NAME }}\n | |
| " >> ojdbc-provider-azure/test.properties | |
| # Generate ojdbc-provider-oci/test.properties | |
| echo -e "OCI_CONFIG_FILE=${{ secrets.TEST_OCI_CONFIG_FILE }}\n | |
| OCI_CONFIG_PROFILE=DEFAULT\n | |
| OCI_CLOUD_SHELL=false\n | |
| OCI_INSTANCE_PRINCIPAL=false\n | |
| OCI_RESOURCE_PRINCIPAL=false\n | |
| OCI_TOKEN_SCOPE=${{ secrets.TEST_OCI_TOKEN_SCOPE }}\n | |
| OCI_PASSWORD_OCID=${{ secrets.TEST_OCI_PASSWORD_OCID }}\n | |
| OCI_DATABASE_OCID=${{ secrets.TEST_OCI_DATABASE_OCID }}\n | |
| OCI_COMPARTMENT_ID=${{ secrets.TEST_OCI_COMPARTMENT_ID }}\n | |
| OCI_DB_TOOLS_CONNECTION_OCID_KEYSTORE=${{ secrets.TEST_OCI_DB_TOOLS_CONNECTION_OCID_KEYSTORE }}\n | |
| OCI_DB_TOOLS_CONNECTION_OCID_PKCS12=${{ secrets.TEST_OCI_DB_TOOLS_CONNECTION_OCID_PKCS12 }}\n | |
| OCI_DB_TOOLS_CONNECTION_OCID_SSO=${{ secrets.TEST_OCI_DB_TOOLS_CONNECTION_OCID_SSO }}\n | |
| OCI_OBJECT_STORAGE_URL=${{ secrets.TEST_OCI_OBJECT_STORAGE_URL }}\n | |
| OCI_OBJECT_STORAGE_URL_MULTIPLE_KEYS=${{ secrets.TEST_OCI_OBJECT_STORAGE_URL_MULTIPLE_KEYS }}\n | |
| OCI_OBJECT_STORAGE_URL_KEY=${{ secrets.TEST_OCI_OBJECT_STORAGE_URL_KEY }}\n | |
| OCI_PASSWORD_PAYLOAD_OCID=${{ secrets.TEST_OCI_PASSWORD_PAYLOAD_OCID }}\n | |
| OCI_PASSWORD_PAYLOAD_OCID_MULTIPLE_KEYS=${{ secrets.TEST_OCI_PASSWORD_PAYLOAD_OCID_MULTIPLE_KEYS }}\n | |
| OCI_PASSWORD_PAYLOAD_OCID_KEY=${{ secrets.TEST_OCI_PASSWORD_PAYLOAD_OCID_KEY }}\n | |
| OCI_USERNAME_OCID=${{ secrets.TEST_OCI_PASSWORD_OCID }}\n | |
| OCI_SSO_TLS_WALLET_OCID=${{ secrets.TEST_OCI_SSO_TLS_WALLET_OCID }}\n | |
| OCI_PKCS12_TLS_WALLET_OCID=${{ secrets.TEST_OCI_PKCS12_TLS_WALLET_OCID }}\n | |
| OCI_PEM_TLS_WALLET_OCID=${{ secrets.TEST_OCI_PEM_TLS_WALLET_OCID }}\n | |
| OCI_CORRUPTED_SEPS_WALLET_OCID=${{ secrets.TEST_OCI_CORRUPTED_SEPS_WALLET_OCID }}\n | |
| OCI_PKCS12_TLS_WALLET_PASSWORD=${{ secrets.TEST_OCI_PKCS12_TLS_WALLET_PASSWORD }}\n | |
| OCI_PEM_TLS_WALLET_PASSWORD=${{ secrets.TEST_OCI_PEM_TLS_WALLET_PASSWORD }}\n | |
| OCI_SSO_SEPS_WALLET_OCID=${{ secrets.TEST_OCI_SSO_SEPS_WALLET_OCID }}\n | |
| OCI_PKCS12_SEPS_WALLET_OCID=${{ secrets.TEST_OCI_PKCS12_SEPS_WALLET_OCID }}\n | |
| OCI_CORRUPTED_TLS_WALLET_OCID=${{ secrets.TEST_OCI_CORRUPTED_TLS_WALLET_OCID }}\n | |
| OCI_PKCS12_SEPS_WALLET_PASSWORD=${{ secrets.TEST_OCI_PKCS12_SEPS_WALLET_PASSWORD }}\n | |
| OCI_SEPS_CONNECTION_STRING_INDEX=${{ secrets.TEST_OCI_SEPS_CONNECTION_STRING_INDEX }}\n | |
| OCI_TNS_NAMES_OCID=${{ secrets.OCI_TNS_NAMES_OCID }}\n | |
| OCI_TNS_NAMES_ALIAS=${{ secrets.OCI_TNS_NAMES_ALIAS }}\n | |
| OCI_NON_BASE64_TNS_NAMES_OCID=${{ secrets.OCI_NON_BASE64_TNS_NAMES_OCID }}\n | |
| " >> ojdbc-provider-oci/test.properties | |
| # Generate ojdbc-provider-jackson-oson/test.properties | |
| echo -e "JACKSON_OSON_URL=${{ secrets.TEST_JACKSON_OSON_URL }}\n | |
| JACKSON_OSON_USERNAME=${{ secrets.TEST_JACKSON_OSON_USERNAME }}\n | |
| JACKSON_OSON_PASSWORD=${{ secrets.TEST_JACKSON_OSON_PASSWORD }}\n | |
| " >> ojdbc-provider-jackson-oson/test.properties | |
| # Generate ojdbc-provider-aws/test.properties | |
| echo -e "AWS_S3_URL=${{ secrets.TEST_AWS_S3_URL }}\n | |
| AWS_SECRETS_MANAGER_URL=${{ secrets.TEST_AWS_SECRETS_MANAGER_URL }}\n | |
| " >> ojdbc-provider-aws/test.properties | |
| # Generate GCP config | |
| echo "${{ secrets.TEST_GCP_CONFIG }}" > $HOME/.gcp/config.json | |
| echo "${{ secrets.GCP_TEST_PROPERTIES }}" > ojdbc-provider-gcp/test.properties | |
| # Generate ojdbc-provider-hashicorp/test.properties | |
| echo -e "VAULT_ADDR=${{ secrets.TEST_VAULT_ADDR }}\n | |
| DEDICATED_VAULT_SECRET_PATH=${{ secrets.TEST_DEDICATED_VAULT_SECRET_PATH }}\n | |
| DEDICATED_VAULT_SECRET_PATH_WITH_MULTIPLE_KEYS=${{ secrets.TEST_DEDICATED_VAULT_SECRET_PATH_WITH_MULTIPLE_KEYS }}\n | |
| VAULT_USERNAME=${{ secrets.TEST_VAULT_USERNAME }}\n | |
| VAULT_PASSWORD=${{ secrets.TEST_VAULT_PASSWORD }}\n | |
| VAULT_NAMESPACE=${{ secrets.TEST_VAULT_NAMESPACE }}\n | |
| ROLE_ID=${{ secrets.TEST_ROLE_ID }}\n | |
| SECRET_ID=${{ secrets.TEST_SECRET_ID }}\n | |
| GITHUB_TOKEN=${{ secrets.TEST_GITHUB_TOKEN }}\n | |
| KEY=${{ secrets.TEST_KEY }}\n | |
| HCP_ORG_ID=${{ secrets.TEST_HCP_ORG_ID }}\n | |
| HCP_PROJECT_ID=${{ secrets.TEST_HCP_PROJECT_ID }}\n | |
| HCP_APP_NAME=${{ secrets.TEST_HCP_APP_NAME }}\n | |
| HCP_CLIENT_ID=${{ secrets.TEST_HCP_CLIENT_ID }}\n | |
| HCP_CLIENT_SECRET=${{ secrets.TEST_HCP_CLIENT_SECRET }}\n | |
| SECRET_NAME=${{ secrets.TEST_SECRET_NAME }}\n | |
| SECRET_NAME_WITH_MULTIPLE_KEYS=${{ secrets.TEST_SECRET_NAME_WITH_MULTIPLE_KEYS }}\n | |
| " >> ojdbc-provider-hashicorp/test.properties | |
| - name: Run tests with Maven | |
| run: mvn -B test --file pom.xml | |
| - name: Clean up | |
| run: | | |
| rm $HOME/.oci/oci-api-key.pem | |
| rm $HOME/.oci/config | |
| rm ojdbc-provider-oci/test.properties | |
| rm $HOME/.azure/ojdbc-plugin-test-app.pem | |
| rm ojdbc-provider-azure/ojdbc-provider-test-app.pfx | |
| rm ojdbc-provider-azure/test.properties | |
| rm $HOME/.gcp/config.json | |
| rm ojdbc-provider-gcp/test.properties | |
| rm ojdbc-provider-jackson-oson/test.properties | |
| rm ojdbc-provider-aws/test.properties | |
| rm ojdbc-provider-hashicorp/test.properties |