Skip to content

setup database before running tests #4

setup database before running tests

setup database before running tests #4

Workflow file for this run

name: Run tests
on:
push:
branches: [ "main" ]
pull_request:
branches: [ "main" ]
permissions:
contents: read
jobs:
build:
runs-on: ubuntu-latest
services:
mysql:
image: mysql:8.0
env:
# The MySQL docker container requires these environment variables to be set
# so we can create and migrate the test database.
# See: https://hub.docker.com/_/mysql
MYSQL_DATABASE: cafe_test
MYSQL_ROOT_PASSWORD: password
ports:
# Opens port 3306 on service container and host
# https://docs.github.com/en/actions/using-containerized-services/about-service-containers
- 3306:3306
# Before continuing, verify the mysql container is reachable from the ubuntu host
options: --health-cmd="mysqladmin ping" --health-interval=10s --health-timeout=5s --health-retries=3
steps:
- uses: actions/checkout@v3
# - name: Install Ubuntu dependencies
# run: |
# sudo apt-get update
# sudo apt-get install libcurl4-openssl-dev libmysqlclient-dev libgirepository1.0-dev
- name: Import SQL dump to cafe_test database
run: mysql -Dcafe_test -uroot -ppassword -h127.0.0.1 -P3306 < "resources/database/dump/cafe.sql"
- name: Validate composer.json and composer.lock
run: composer validate --strict
- name: Cache Composer packages
id: composer-cache
uses: actions/cache@v3
with:
path: vendor
key: ${{ runner.os }}-php-${{ hashFiles('**/composer.lock') }}
restore-keys: |
${{ runner.os }}-php-
- name: Install Composer dependencies
run: composer install --prefer-dist --no-progress
# - name: Start database service
# run: sudo systemctl start mysql.service
- name: Run test suite
env:
DB_HOST: 127.0.0.1
DB_USERNAME: root
DB_PASSWORD: password
TEST_DB_NAME: cafe_test
run: composer test