updated command behavior #4
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: 'StackQL Exec Test' | |
| on: | |
| push: | |
| branches: | |
| - main | |
| pull_request: | |
| jobs: | |
| stackql-exec-google-example: | |
| strategy: | |
| matrix: | |
| os: [ubuntu-latest, windows-latest, macos-latest] | |
| runs-on: ${{matrix.os}} | |
| name: 'StackQL exec Google ' | |
| steps: | |
| - name: Checkout | |
| uses: actions/[email protected] | |
| # | |
| # run a query that does not return data (using the `is_command` input) | |
| # | |
| - name: pull providers | |
| id: stackql-command | |
| uses: ./ | |
| with: | |
| is_command: true | |
| query: "REGISTRY PULL github; | |
| REGISTRY PULL google;" | |
| # | |
| # run a query using the `query` input | |
| # | |
| - name: github query example using the query input | |
| id: stackql-query | |
| uses: ./ | |
| with: | |
| query: | | |
| select visibility, count(*) as number_of_repos | |
| from github.repos.repos | |
| where org = 'stackql' | |
| group by visibility | |
| env: | |
| STACKQL_GITHUB_USERNAME: ${{ secrets.STACKQL_GITHUB_USERNAME }} | |
| STACKQL_GITHUB_PASSWORD: ${{ secrets.STACKQL_GITHUB_PASSWORD }} | |
| # `csv` output | |
| - name: github query example using the query input (csv output) | |
| id: stackql-query-csv-output | |
| uses: ./ | |
| with: | |
| query_output: csv | |
| query: | | |
| select visibility, count(*) as number_of_repos | |
| from github.repos.repos | |
| where org = 'stackql' | |
| group by visibility | |
| env: | |
| STACKQL_GITHUB_USERNAME: ${{ secrets.STACKQL_GITHUB_USERNAME }} | |
| STACKQL_GITHUB_PASSWORD: ${{ secrets.STACKQL_GITHUB_PASSWORD }} | |
| # `table` output | |
| - name: github query example using the query input (table output) | |
| id: stackql-query-table-output | |
| uses: ./ | |
| with: | |
| query_output: table | |
| query: | | |
| select visibility, count(*) as number_of_repos | |
| from github.repos.repos | |
| where org = 'stackql' | |
| group by visibility | |
| env: | |
| STACKQL_GITHUB_USERNAME: ${{ secrets.STACKQL_GITHUB_USERNAME }} | |
| STACKQL_GITHUB_PASSWORD: ${{ secrets.STACKQL_GITHUB_PASSWORD }} | |
| # `text` output | |
| - name: github query example using the query input (text output) | |
| id: stackql-query-text-output | |
| uses: ./ | |
| with: | |
| query_output: text | |
| query: | | |
| select visibility, count(*) as number_of_repos | |
| from github.repos.repos | |
| where org = 'stackql' | |
| group by visibility | |
| env: | |
| STACKQL_GITHUB_USERNAME: ${{ secrets.STACKQL_GITHUB_USERNAME }} | |
| STACKQL_GITHUB_PASSWORD: ${{ secrets.STACKQL_GITHUB_PASSWORD }} | |
| # | |
| # run a query using the `query_file_path` input | |
| # | |
| - name: google query example with query file | |
| id: stackql-query-file | |
| uses: ./ | |
| with: | |
| query_file_path: './stackql_scripts/google-instances-by-status.iql' | |
| env: | |
| GOOGLE_CREDENTIALS: ${{ secrets.GOOGLE_CREDENTIALS }} | |
| # | |
| # run a query using the `query_file_path` and `vars` inputs | |
| # | |
| - name: google query example with query file using vars | |
| id: stackql-query-file-with-vars | |
| uses: ./ | |
| with: | |
| query_file_path: './stackql_scripts/google-instances-by-status-with-inline-jsonnet-block.iql' | |
| vars: GOOGLE_PROJECT=${{ env.GOOGLE_PROJECT }},GOOGLE_ZONE=${{ env.GOOGLE_ZONE }} | |
| env: | |
| GOOGLE_CREDENTIALS: ${{ secrets.GOOGLE_CREDENTIALS }} | |
| GOOGLE_PROJECT: ${{ vars.GOOGLE_PROJECT }} | |
| GOOGLE_ZONE: ${{ vars.GOOGLE_ZONE }} | |
| # | |
| # run a query using the `query_file_path`, `data_file_path` and `vars` inputs | |
| # | |
| - name: google query example with query file and data file using vars | |
| id: stackql-query-file-with-data-file-and-vars | |
| uses: ./ | |
| with: | |
| query_file_path: './stackql_scripts/google-instances-by-status-with-external-data-file.iql' | |
| data_file_path: './stackql_scripts/google-instances-by-status-with-external-data-file.jsonnet' | |
| vars: GOOGLE_PROJECT=${{ env.GOOGLE_PROJECT }},GOOGLE_ZONE=${{ env.GOOGLE_ZONE }} | |
| env: | |
| GOOGLE_CREDENTIALS: ${{ secrets.GOOGLE_CREDENTIALS }} | |
| GOOGLE_PROJECT: ${{ vars.GOOGLE_PROJECT }} | |
| GOOGLE_ZONE: ${{ vars.GOOGLE_ZONE }} | |
| - name: validate stackql-exec output | |
| shell: bash | |
| run: | | |
| # Get the output of the pull providers command (stackql-command) | |
| output="${{ steps.stackql-command.outputs.exec-result }}" | |
| regex="([a-zA-Z]+) provider, version 'v[0-9.]+' successfully installed" | |
| echo "$output" | while IFS= read -r line; do | |
| # Skip empty lines | |
| if [[ -z "$line" ]]; then | |
| continue | |
| fi | |
| if ! echo "$line" | grep -qE "$regex"; then | |
| echo "failed line: $line" | |
| exit 1 | |
| fi | |
| done | |
| # validate github query example using the query input (stackql-query) | |
| if [ -z '${{ steps.stackql-query.outputs.exec-result }}' ]; then | |
| echo "exec-stackql output does not contain expected result" | |
| exit 1 | |
| fi | |
| # validate google query example with query file (stackql-query-file) | |
| if [ -z '${{ steps.stackql-query-file.outputs.exec-result }}' ]; then | |
| echo "exec-stackql output does not contain expected result" | |
| exit 1 | |
| fi | |
| # validate google query example with query file using vars (stackql-query-file-with-vars) | |
| if [ -z '${{ steps.stackql-query-file-with-vars.outputs.exec-result }}' ]; then | |
| echo "exec-stackql output does not contain expected result" | |
| exit 1 | |
| fi | |
| # validate google query example with query file and data file using vars (stackql-query-file-with-data-file-and-vars) | |
| if [ -z '${{ steps.stackql-query-file-with-data-file-and-vars.outputs.exec-result }}' ]; then | |
| echo "exec-stackql output does not contain expected result" | |
| exit 1 | |
| fi |