migrations.yml

name: Test migrations

on: [push]

jobs:
    test-migrations:
        name: Test migrations
        runs-on: ubuntu-latest
        services:
            mysql:
                image: mysql:5.7
                env:
                    MYSQL_DATABASE: api_db
                    MYSQL_ROOT_PASSWORD: testbench
                    MYSQL_USER: sys
                    MYSQL_PASSWORD: password
                options: --health-cmd="mysqladmin ping" --health-interval=10s --health-timeout=5s --health-retries=3
                ports:
                    - "3308:3306"
        steps:
            - name: Checkout repository
              uses: actions/checkout@v2
            - name: Use php 7.3
              uses: shivammathur/setup-php@v2
              with:
                  php-version: 7.3
                  extensions: fileinfo, dom, tokenizer, simplexml, curl
                  coverage: none
            - name: Cache module
              uses: actions/cache@v1.1.2
              with:
                  path: ~/.composer/cache/
                  key: composer-cache
            - name: Install dependencies
              run: |
                  php -v && composer --version
                  composer install --no-suggest --no-interaction --optimize-autoloader
            - name: Run all migrations
              env:
                  DB_HOST: 127.0.0.1
                  DB_PORT: ${{ job.services.mysql.ports['3306'] }}
                  DB_DATABASE: api_db
                  DB_USERNAME: sys
                  DB_PASSWORD: password
              run: php artisan migrate --step --database=mysql --verbose --force

    test-migrations-and-rollback:
        name: Test migrations and rollback
        runs-on: ubuntu-latest
        services:
            mysql:
                image: mysql:5.7
                env:
                    MYSQL_DATABASE: api_db
                    MYSQL_ROOT_PASSWORD: testbench
                    MYSQL_USER: sys
                    MYSQL_PASSWORD: password
                options: --health-cmd="mysqladmin ping" --health-interval=10s --health-timeout=5s --health-retries=3
                ports:
                    - "3308:3306"
        steps:
            - name: Checkout repository
              uses: actions/checkout@v2
            - name: Use php 7.3
              uses: shivammathur/setup-php@v2
              with:
                  php-version: 7.3
                  extensions: fileinfo, dom, tokenizer, simplexml, curl
                  coverage: none
            - name: Cache module
              uses: actions/cache@v1.1.2
              with:
                  path: ~/.composer/cache/
                  key: composer-cache
            - name: Install dependencies
              run: |
                  php -v && composer --version
                  composer install --no-suggest --no-interaction --optimize-autoloader
            - name: Run all migrations and rollback
              env:
                  DB_HOST: 127.0.0.1
                  DB_PORT: ${{ job.services.mysql.ports['3306'] }}
                  DB_DATABASE: api_db
                  DB_USERNAME: sys
                  DB_PASSWORD: password
              run: |
                  php artisan migrate --step --database=mysql --verbose --force
                  php artisan migrate:reset  --database=mysql --verbose --force