Setting up testing database

Introduction

This page will guide you to setup your testing database to be able to run PHPUnit, for development.

Prerequisites

Make sure you have already installed timegrid and updated composer packages with --dev parameter.

Steps

From your command-line, access to the mysql prompt.

mysql -u root -p

Once into the MySQL console

-- Create a database called `testing_timegrid`:

CREATE DATABASE testing_timegrid;

-- Create a user with the same name:

CREATE USER 'testing_timegrid'@'localhost' IDENTIFIED BY 'testing_timegrid';

-- Grant all permissions:

GRANT ALL PRIVILEGES ON `testing_timegrid`.* TO 'testing_timegrid'@'localhost';

Logout from mysql prompt

Ctrl + D

From your command-line, run the migrations:

php artisan migrate --database=testing

You should be ready to run unit tests with phpunit:

vendor/bin/phpunit

Test Coverage

You will find the current test coverage status on CodeClimate

Generating your own local Test Coverage report

You may run:

php -d xdebug.profiler_enable=on vendor/bin/phpunit --coverage-html build/coverage --testdox-html build/testdox.html

Or enable xdebug and the logging directive on phpunit.xml

The reports will be generated on the build/ directory.