still chasing solution #75
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: Node.js CI | |
| on: | |
| push: | |
| branches: [ main ] | |
| pull_request: | |
| branches: [ main ] | |
| jobs: | |
| build: | |
| runs-on: ubuntu-latest | |
| strategy: | |
| matrix: | |
| node-version: [20] # Specify Node.js 20 | |
| # Output whether the build job runs based on the file changes | |
| outputs: | |
| should_run_build: ${{ steps.build_check.outputs.build_ran }} | |
| steps: | |
| - name: Checkout repository | |
| uses: actions/checkout@v3 | |
| with: | |
| fetch-depth: 2 # Fetch the last two commits to ensure `git diff` works | |
| - name: Check if TypeScript files were modified | |
| id: build_check | |
| run: | | |
| git fetch origin main --depth=2 | |
| PREVIOUS_COMMIT=$(git rev-parse HEAD~1) | |
| MODIFIED_FILES=$(git diff --name-only $PREVIOUS_COMMIT HEAD) | |
| if [[ "$MODIFIED_FILES" == *"src/**/*.ts"* ]]; then | |
| echo "Build should run." | |
| echo "::set-output name=build_ran::true" | |
| else | |
| echo "No TypeScript files were modified." | |
| echo "::set-output name=build_ran::false" | |
| fi | |
| - name: Setup Node.js | |
| if: steps.build_check.outputs.build_ran == 'true' | |
| uses: actions/setup-node@v3 | |
| with: | |
| node-version: ${{ matrix.node-version }} | |
| - name: Install dependencies | |
| if: steps.build_check.outputs.build_ran == 'true' | |
| run: npm install | |
| - name: Compile TypeScript | |
| if: steps.build_check.outputs.build_ran == 'true' | |
| run: npx tsc | |
| - name: Run tests | |
| if: steps.build_check.outputs.build_ran == 'true' | |
| run: npm test | |
| - name: Upload artifacts | |
| if: steps.build_check.outputs.build_ran == 'true' | |
| uses: actions/upload-artifact@v3 | |
| with: | |
| name: dist | |
| path: ./dist | |
| deploy: | |
| runs-on: ubuntu-latest | |
| needs: build | |
| steps: | |
| - name: Checkout repository | |
| uses: actions/checkout@v3 | |
| with: | |
| fetch-depth: 2 # Fetch the last two commits to ensure `git diff` works | |
| - name: Download artifacts | |
| if: needs.build.outputs.should_run_build == 'true' | |
| uses: actions/download-artifact@v3 | |
| with: | |
| name: dist | |
| - name: Authenticate to Google Cloud for clingen-swc | |
| if: needs.build.outputs.should_run_build == 'true' | |
| uses: google-github-actions/auth@v1 | |
| with: | |
| credentials_json: ${{ secrets.GCP_SA_KEY }} | |
| - name: Setup Google Cloud SDK | |
| if: needs.build.outputs.should_run_build == 'true' | |
| uses: google-github-actions/setup-gcloud@v1 | |
| with: | |
| version: 'latest' | |
| - name: Get modified files | |
| run: | | |
| git fetch origin main --depth=2 | |
| PREVIOUS_COMMIT=$(git rev-parse HEAD~1) | |
| MODIFIED_FILES=$(git diff --name-only $PREVIOUS_COMMIT HEAD) | |
| echo "$MODIFIED_FILES" > modified_files.txt | |
| echo "$MODIFIED_FILES" | |
| - name: Execute clingen-stage BigQuery Function Scripts | |
| run: | | |
| echo "Executing BigQuery function scripts for clingen-stage in alphabetical order..." | |
| MODIFIED_FILES=$(cat modified_files.txt) | |
| for file in $(find ./scripts -type f -name '*-func.sql' | sort); do | |
| if echo "$MODIFIED_FILES" | grep -q "$file"; then | |
| echo "Executing $file..." | |
| bq query --use_legacy_sql=false --project_id=$PROJECT_ID < "$file" | |
| else | |
| echo "Skipping $file as it was not modified." | |
| fi | |
| done | |
| env: | |
| PROJECT_ID: 'clingen-stage' | |
| - name: Execute clingen-dev BigQuery Function Scripts | |
| run: | | |
| echo "Executing BigQuery function scripts for clingen-dev in alphabetical order..." | |
| MODIFIED_FILES=$(cat modified_files.txt) | |
| for file in $(find ./scripts -type f -name '*-func.sql' | sort); do | |
| if echo "$MODIFIED_FILES" | grep -q "$file"; then | |
| echo "Executing $file..." | |
| bq query --use_legacy_sql=false --project_id=$PROJECT_ID < "$file" | |
| else | |
| echo "Skipping $file as it was not modified." | |
| fi | |
| done | |
| env: | |
| PROJECT_ID: 'clingen-dev' | |
| - name: Execute clingen-dev BigQuery Procedure Scripts | |
| run: | | |
| echo "Executing BigQuery procedure scripts for clingen-dev in alphabetical order..." | |
| MODIFIED_FILES=$(cat modified_files.txt) | |
| for file in $(find ./scripts -type f -name '*-proc.sql' | sort); do | |
| if echo "$MODIFIED_FILES" | grep -q "$file"; then | |
| echo "Executing $file..." | |
| bq query --use_legacy_sql=false --project_id=$PROJECT_ID < "$file" | |
| else | |
| echo "Skipping $file as it was not modified." | |
| fi | |
| done | |
| env: | |
| PROJECT_ID: 'clingen-dev' |