ec2-deploy.yml

name: Deploy to EC2 with Prisma Migrations and Cleanup

on:
  push:
    branches:
      - master  # Specify your deployment branch

jobs:
  deploy:
    runs-on: ubuntu-latest

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

      - name: Add SSH Key
        uses: webfactory/ssh-agent@v0.5.3
        with:
          ssh-private-key: ${{ secrets.SSH_KEY }}

      - name: Deploy to EC2, Clean Up Old Migrations, and Run Prisma Migrations
        run: |
          ssh -o StrictHostKeyChecking=no ubuntu@${{ secrets.EC2_IP }} << 'EOF'
            cd /home/ubuntu/Campus-Chatter/backend    # Change this to your project path on EC2

            # Stash any local changes
            git stash

            # Pull the latest changes from master
            git pull origin master

            # Remove old migration files
            rm -rf prisma/migrations

            # Install any new dependencies
            npm install

            # Apply Prisma migrations using deploy for production (instead of dev)
            npx prisma migrate deploy --force

            # Compile TypeScript
            tsc -b

            # Restart your backend service using PM2
            pm2 restart dist/index.js
          EOF