flyer-crawler.projectium.com/.gitea/workflows/deploy.yml

# FILE: .gitea/workflows/deploy.yml
#
# deploy to  production which is an ubuntu co-lo server with nginx + postgres
#
# note to AI - the order in this file matters - also, minor changes to this file can have big impacts and is easy to break
name: Deploy to Web Server flyer-crawler.projectium.com

on:
  push:
    branches:
      - main # This pipeline runs only on a push to the 'main' branch.

jobs:
  deploy:
    runs-on: projectium.com # This job runs on your self-hosted Gitea runner.

    # Environment variables are used to pass secrets and configuration to the steps below.
    # These must be configured as secrets in your Gitea repository settings.
    env:
      # Public keys needed for the React build process.

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

      # Add this NEW STEP FOR DEBUGGING
      - name: Show Git REF
        run: |
          echo "Gitea ref: ${{ gitea.ref }}"
          echo "Gitea ref_name: ${{ gitea.ref_name }}" # often more useful (e.g., 'main' or 'my-feature-branch')
          echo "Gitea ref_type: ${{ gitea.ref_type }}" # 'branch' or 'tag'
          echo "Gitea SHA: ${{ gitea.sha }}"
          echo "Triggering actor: ${{ gitea.actor }}"
          echo "Repository: ${{ gitea.repository }}"

      - name: Setup Node.js
        uses: actions/setup-node@v3
        with:
          node-version: '20'
          cache: 'npm' # Re-enable the cache. If this fails, we will remove it again.
          cache-dependency-path: '**/package-lock.json'

      # The setup-node action with caching handles installation correctly.
      # If dependencies are not found in cache, it will run 'npm ci' automatically.
      # If they are found, it restores them. This is the standard, reliable way.
      - name: Install Dependencies
        run: npm ci # 'ci' is faster and safer for CI/CD than 'install'.

      # --- NEW DEBUGGING STEPS ---
      - name: Verify Project Structure
        run: |
          echo "--- Current Working Directory ---"
          pwd
          echo "--- Listing Root Directory ---"
          ls -alF
          echo "--- Listing SRC Directory ---"
          ls -alF src

      - name: Lint TypeScript Code
        run: npm run lint # Run the linter to check for code quality issues.
        continue-on-error: true # Allows the workflow to proceed even if linting fails.

      - name: Setup Test Database
        id: setup_test_db # Add an ID to reference this step's outcome later.
        run: |
          echo "--- Creating test database and user ---"
          # Execute the setup script as the 'postgres' superuser.
          # This creates the 'flyer-crawler-test' database and 'test_runner' role.
          sudo -u postgres psql -f sql/test_setup.sql

      - name: Run Unit Tests
        # We override the production DB variables for this step only.
        # The 'global-setup.ts' will use these to connect to the test database,
        # create the schema, and seed data before tests run.
        env:
          DB_HOST: localhost
          DB_PORT: 5432
          DB_USER: test_runner
          DB_PASSWORD: a_secure_test_password
          DB_DATABASE: flyer-crawler-test
        run: npm test # Run the test suite against the temporary test database.
          # also Run the test suite to ensure code correctness.

      - name: Teardown Test Database
        # This step runs regardless of whether the tests passed or failed.
        # It will only execute if the 'setup_test_db' step was successful, preventing errors if setup failed.
        if: always() && steps.setup_test_db.outcome == 'success'
        run: |
          echo "--- Dropping test database and user ---"
          sudo -u postgres psql -f sql/test_teardown.sql

      - name: Archive Code Coverage Report
        # This action saves the generated HTML coverage report as a downloadable artifact.
        uses: actions/upload-artifact@v3
        with:
          name: code-coverage-report
          path: coverage/

      # --- Frontend Deployment ---
      - name: Build React Application
        # We set the environment variable directly in the command line for this step.
        # This maps the Gitea secret to the environment variable the application expects.
        run: VITE_API_KEY=${{ secrets.VITE_GOOGLE_GENAI_API_KEY }} npm run build

      - name: Deploy Frontend via Local Copy
        run: |
          echo "Deploying frontend files to local web server path..."
          # Ensure the destination directory exists before copying.
          mkdir -p "/var/www/flyer-crawler.projectium.com"
          # Use rsync to efficiently copy files from the 'dist' output to the web server directory.
          # The '--delete' flag removes old files from the destination, ensuring a clean deployment.
          # We exclude '.env.local' to prevent deleting the server-specific environment file.
          rsync -avz --delete --exclude '.env.local' dist/ "/var/www/flyer-crawler.projectium.com"
          echo "Local deployment complete."