sync_benchmark_files_to_gsheet.yaml

name: Synchronize k-means benchmark result file with a google sheet

on:
  push:
    branches: main

jobs:
  sync_benchmark_result_file_with_gsheet:
    name: Run synchronization script
    runs-on: ubuntu-latest
    environment: Publish

    steps:
    - name: Checkout code
      uses: actions/checkout@v3

    - name: Install pre-requisites
      run: pip install numpy pandas gspread

    - name: Synchronize the worksheet
      env:
        GSPREAD_SERVICE_ACCOUNT_AUTH_KEY: ${{secrets.GSPREAD_SERVICE_ACCOUNT_AUTH_KEY}}
        GSPREAD_URL: ${{vars.GSPREAD_URL}}
      run: |
        python ./benchmarks/kmeans/consolidate_result_csv.py ./benchmarks/kmeans/results.csv --check-csv
        python ./benchmarks/pca/consolidate_result_csv.py ./benchmarks/pca/results.csv --check-csv
        python ./benchmarks/ridge/consolidate_result_csv.py ./benchmarks/ridge/results.csv --check-csv
        echo "$GSPREAD_SERVICE_ACCOUNT_AUTH_KEY" > service_account.json
        python ./benchmarks/kmeans/consolidate_result_csv.py ./benchmarks/kmeans/results.csv \
          --sync-to-gspread --gspread-url $GSPREAD_URL --gspread-auth-key ./service_account.json
        python ./benchmarks/pca/consolidate_result_csv.py ./benchmarks/pca/results.csv \
          --sync-to-gspread --gspread-url $GSPREAD_URL --gspread-auth-key ./service_account.json
        python ./benchmarks/ridge/consolidate_result_csv.py ./benchmarks/ridge/results.csv \
          --sync-to-gspread --gspread-url $GSPREAD_URL --gspread-auth-key ./service_account.json