BookStack Code Mirror - bookstack/blob - .github/workflows/test-migrations.yml

   1 name: test-migrations
   2
   3 on:
   4   push:
   5     paths:
   6       - '**.php'
   7       - 'composer.*'
   8   pull_request:
   9     paths:
  10       - '**.php'
  11       - 'composer.*'
  12
  13 jobs:
  14   build:
  15     if: ${{ github.ref != 'refs/heads/l10n_development' }}
  16     runs-on: ubuntu-22.04
  17     strategy:
  18       matrix:
  19         php: ['8.1', '8.2', '8.3']
  20     steps:
  21       - uses: actions/checkout@v1
  22
  23       - name: Setup PHP
  24         uses: shivammathur/setup-php@v2
  25         with:
  26           php-version: ${{ matrix.php }}
  27           extensions: gd, mbstring, json, curl, xml, mysql, ldap
  28
  29       - name: Get Composer Cache Directory
  30         id: composer-cache
  31         run: |
  32           echo "dir=$(composer config cache-files-dir)" >> $GITHUB_OUTPUT
  33
  34       - name: Cache composer packages
  35         uses: actions/cache@v4
  36         with:
  37           path: ${{ steps.composer-cache.outputs.dir }}
  38           key: ${{ runner.os }}-composer-${{ matrix.php }}
  39           restore-keys: ${{ runner.os }}-composer-
  40
  41       - name: Start MySQL
  42         run: |
  43           sudo systemctl start mysql
  44
  45       - name: Create database & user
  46         run: |
  47           mysql -uroot -proot -e 'CREATE DATABASE IF NOT EXISTS `bookstack-test`;'
  48           mysql -uroot -proot -e "CREATE USER 'bookstack-test'@'localhost' IDENTIFIED WITH mysql_native_password BY 'bookstack-test';"
  49           mysql -uroot -proot -e "GRANT ALL ON \`bookstack-test\`.* TO 'bookstack-test'@'localhost';"
  50           mysql -uroot -proot -e 'FLUSH PRIVILEGES;'
  51
  52       - name: Install composer dependencies
  53         run: composer install --prefer-dist --no-interaction --ansi
  54
  55       - name: Start migration test
  56         run: |
  57           php${{ matrix.php }} artisan migrate --force -n --database=mysql_testing
  58
  59       - name: Start migration:rollback test
  60         run: |
  61           php${{ matrix.php }} artisan migrate:rollback --force -n --database=mysql_testing
  62
  63       - name: Start migration rerun test
  64         run: |
  65           php${{ matrix.php }} artisan migrate --force -n --database=mysql_testing