ojdbc-extensions/.github/workflows/run-tests.yaml at a922d2bfa9d10be4dbac3fa2cf01842e66779c3d · oracle/ojdbc-extensions · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
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 }}
    steps:
      - name: Checkout the repository
        uses: actions/checkout@v4
      - name: Set up JDK 17
        uses: actions/setup-java@v5
        with:
          distribution: 'oracle'
          java-version: '17'
      - 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-observability/test.properties
          echo -e "OBSERVABILITY_URL=${{ secrets.TEST_JACKSON_OSON_URL }}\n
          OBSERVABILITY_USERNAME=${{ secrets.TEST_JACKSON_OSON_USERNAME }}\n
          OBSERVABILITY_PASSWORD=${{ secrets.TEST_JACKSON_OSON_PASSWORD }}\n
          " >> ojdbc-provider-observability/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


      - 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-observability/test.properties

          rm ojdbc-provider-aws/test.properties