migrations-check.yml

name: Migrations check on mysql8

on:
  workflow_dispatch:
  pull_request:
  push:
    branches:
      - master

jobs:
  check_migrations:
    name: check migrations
    runs-on: ${{ matrix.os }}
    strategy:
      matrix:
        os: [ ubuntu-20.04, ubuntu-latest ]
        python-version: [ 3.8 ]

    steps:
    - name: Checkout repo
      uses: actions/checkout@v4

    - name: Setup Python ${{ matrix.python-version }}
      uses: actions/setup-python@v5
      with:
        python-version: ${{ matrix.python-version }}

    - name: Install system Packages
      run: |
        sudo apt-get update
        sudo apt-get install -y libxmlsec1-dev
  
    - name: Get pip cache dir
      id: pip-cache-dir
      run: |
        echo "dir=$(pip cache dir)" >> $GITHUB_OUTPUT

    - name: Cache pip dependencies
      id: cache-dependencies
      uses: actions/cache@v4
      with:
        path: ${{ steps.pip-cache-dir.outputs.dir }}
        key: ${{ runner.os }}-pip-${{ hashFiles('requirements/pip_tools.txt') }}
        restore-keys: ${{ runner.os }}-pip-

    - name: Ubuntu and MySQL Versions
      run: |
        lsb_release -a
        mysql -V

    - name: Install Python dependencies
      run: |
        pip install -r requirements/pip-tools.txt
        pip install -r requirements/test.txt
        pip install -r requirements/base.txt
        pip uninstall -y mysqlclient
        pip install --no-binary mysqlclient mysqlclient

    - name: Initiate Services
      run: |
        sudo /etc/init.d/mysql start

    - name: Reset mysql password
      run: |
        cat <<EOF | mysql -h 127.0.0.1 -u root --password=root
          UPDATE mysql.user SET authentication_string = null WHERE user = 'root';
          FLUSH PRIVILEGES;
        EOF

    - name: Run migrations
      env:
        DB_ENGINE: django.db.backends.mysql
        MYSQL_DATABASE: submissions_db
        MYSQL_USER: root
        MYSQL_ROOT_PASSWORD:
        MYSQL_HOST: localhost
        MYSQL_PORT: 3306
      run: |
        echo "CREATE DATABASE IF NOT EXISTS submissions_db;" | sudo mysql -u root
        echo "Testing migrations."
        if python ./manage.py makemigrations --dry-run | grep -q 'No changes detected'; then
          echo "Migrations up to date."
        else
          echo "ERROR: Missing migration files for model changes. Run ./manage.py makemigrations"
          exit 1
        fi