tests_and_ci.yml

name: Docker Image CI for GHCR
on: 
  push:
  pull_request:
    branches: [ main ]
jobs:
  run_pytest:
    runs-on: ubuntu-latest
    steps:
      - uses: actions/checkout@v3

      - name: Start MySQL Server
        run: docker run -d -p 3800:3306 --name mysql -e MYSQL_ROOT_PASSWORD=dbtestpassword -e MYSQL_DATABASE=ghworkflow_testdb mysql@sha256:566007208a3f1cc8f9df6b767665b5c9b800fc4fb5f863d17aa1df362880ed04

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

      - name: Install MySQL Client
        run: sudo apt-get install -y mysql-client

      - name: Wait for MySQL Server to Start
        run: sleep 10

      - name: Add Testing Database
        run: mysql -h 127.0.0.1 -u root -pdbtestpassword -P 3800 -e "CREATE DATABASE testing_ghworkflow_testdb;"

      - name: Copy data into database
        run: mysql -h 127.0.0.1 -u root -pdbtestpassword -P 3800 ghworkflow_testdb < ./archive/latest.sql


      - name: Install Poetry
        uses: snok/install-poetry@v1
      - name: Install Dependencies
        run: |
          poetry install --no-root --no-interaction
      - name: Run Tests
        run: |
          poetry run pytest
        env:
          MYSQLDATABASE: 'ghworkflow_testdb'
          MYSQLUSER: 'root'
          MYSQLPASSWORD: 'dbtestpassword'
          MYSQLHOST: 'localhost'
          MYSQLPORT: '3800'

          TESTING_MYSQLDATABASE: 'testing_ghworkflow_testdb'
          TESTING_MYSQLUSER: 'root'
          TESTING_MYSQLPASSWORD: 'dbtestpassword'
          TESTING_MYSQLHOST: 'localhost'
          TESTING_MYSQLPORT: '3800'

  build_and_publish:
    runs-on: ubuntu-latest
    needs: test
    if: github.event_name == 'push' && github.ref == 'refs/heads/main'
    steps:
      - uses: actions/checkout@v3
      - name: Build and push the image
        run: |
          docker login --username thearyadev --password ${{ secrets.GH_PAT }} ghcr.io
          docker build . --tag ghcr.io/thearyadev/top500-aggregator:latest
          docker push ghcr.io/thearyadev/top500-aggregator:latest