branchonline/yii2-pgsqltester

Extends Yii2 framework with a powerful console controller for tests requiring a postgres database.

Yii2 PostgreSQL automated testing setup

Automated setup of empty database and powerful console control of available tests., _(*1)

Example usage

First set up the environment using the instructions in example setup below., _(*2)

Run all tests:, _(*3)

./yii_test test/run or ./yii_test test (action run is default), _(*4)

Run all unit tests using (only when you are not using modules, otherwise you have to specify the module):, _(*5)

./yii_test test -s=unit, _(*6)

Run all unit tests in module admin using:, _(*7)

./yii_test test -m=admin, _(*8)

Run all unit tests in module admin from suite acceptance:, _(*9)

./yii_test test -s=acceptance -m=admin, _(*10)

Run specific test by name:, _(*11)

./yii_test test TestName, _(*12)

Force to remigrate the test database:, _(*13)

./yii_test test/prepare-db true, _(*14)

Example setup

Read carefully and make sure you understand what you're doing before setting anything up!, _(*15)

Databases

This package provides a clean separation of databases so your tests can always run on an empty database that is in the correct state. To see how it works we identify 4 databases: - The dev database. This database is not touched by the testing mechanism, but should remain accessible for developing. - The template database. This is the database that is migrated to the correct version by the testing system, and may contain all kinds of data that your migrations add by default. - The test databse. This is the database that the actual tests run on. It is prepared by the testing mechanism to be a completely empty copy of the template database. - The postgres databse. This is the default database provided by postgres, that is used by the tester to automatically setup both template and test database., _(*16)

Yii setup

You need 2 config files for this setup to work: - test.php should contain credentials for the postgres and test database. - test-setup.php should overwrite the credentials of test with that of template and make the test controller available through the controller map., _(*17)

An example for test.php:, _(*18)

<?php
return [
    'id' => 'basic-tests',
    'basePath' => dirname(__DIR__),
    'language' => 'en-US',
    'components' => [
        'config_db' => [
            'class' => 'yii\db\Connection',
            'dsn' => 'pgsql:host=localhost;port=5432;dbname=postgres',
        ],
        'db' => [
            'class' => 'yii\db\Connection',
            'dsn' => 'pgsql:host=localhost;port=5432;dbname=testing',
        ],
    ],
];

An example for test-setup.php", _(*19)

<?php
return [
    'components' => [
        'db' => [
            'dsn' => 'pgsql:host=localhost;port=5432;dbname=testing_template'
        ],
    ],
    'controllerMap' => [
        'test' => [
            'class' => 'branchonline\pgsqltester\TestController',
        ]
    ],
];

Make sure you have a access point for running the tests, for instance ./yii_test., _(*20)

yii_test example (adjust to your liking):, _(*21)

<?php

defined('YII_DEBUG') or define('YII_DEBUG', true);
defined('YII_ENV') or define('YII_ENV', 'test');

require(__DIR__ . '/vendor/autoload.php');
require(__DIR__ . '/vendor/yiisoft/yii2/Yii.php');

$config = yii\helpers\ArrayHelper::merge(
    require(__DIR__ . '/path/to/test.php'),
    require(__DIR__ . '/path/to/test-setup.php')
);

$application = new yii\console\Application($config);
$exitCode = $application->run();
exit($exitCode);

Make sure the YII_ENV is initialized to 'test'. Also make sure you include test-setup.php and test.php in that order., _(*22)

Codeception setup

Codeception is run using the codeception.yml file as configuration, make sure to configure the Yii module and include test.php as the access point., _(*23)

modules:
    config:
        Yii2:
            configFile: 'path/to/test.php'