もう手作業は卒業！Github Actionsでレポート作成を自動化する

name: Process PDF and Create CSV

on:
  schedule:
    - cron: '0 9 * * 6'  # 土曜の9時（UTC）に実行
  workflow_dispatch:   # 手動実行を可能にする

jobs:
  process_pdf_job:
    runs-on: ubuntu-latest
    steps:
      - name: Checkout code
        uses: actions/checkout@v3

      - name: Set up Python
        uses: actions/setup-python@v4
        with:
          python-version: '3.10'

      - name: Install dependencies
        run: |
          python -m pip install --upgrade pip
          pip install -r requirements.txt

      - name: Run Python script
        run: python actions/process_pdf.py

      - name: Commit and push CSV
        run: |
           git config user.name github-actions
           git config user.email github-actions@github.com
           git add public
           git commit -m "Update CSVs" || echo "No changes to commit"
           git push origin main
  
      - name: Archive the output folder
        run: tar -czf public.tar.gz public
      
      - name: Upload artifact
        uses: actions/upload-artifact@v4
        with:
          name: public-folder
          path: public.tar.gz

  deploy:
    runs-on: ubuntu-latest
    needs: process_pdf_job
    steps:
      - name: Download artifact
        uses: actions/download-artifact@v4
        with:
          name: public-folder

      - name: Set up SSH
        uses: webfactory/ssh-agent@v0.9.0
        with:
          ssh-private-key: ${{ secrets.WEB_SSH_KEY }}

      - name: Backup the contents on VPS
        run: |
          ssh -o StrictHostKeyChecking=no user@your-vps-ip 'bash -s' << 'EOF'

          BACKUP_DIR="/path/to/backup"
          TARGET_DIR="/path/to/public"

          DATE=$(date +"%Y%m%d")
          tar -czvf "$BACKUP_DIR/backup_$DATE.tar.gz" "$TARGET_DIR"
          rm -rf "$TARGET_DIR"

          echo "Backup completed: $BACKUP_DIR/backup_$DATE.tar.gz"

          EOF

      - name: Deploy to VPS using scp
        run: |
          scp -o StrictHostKeyChecking=no public.tar.gz user@your-vps-ip:/path/to

      - name: Extract files on VPS
        run: |
          ssh -o StrictHostKeyChecking=no user@your-vps-ip "tar -xzf /path/to/public.tar.gz -C /path/to && rm /path/to/public.tar.gz && docker exec nginx-release nginx -s reload"