Skip to content

Instantly share code, notes, and snippets.

@sergeymakinen
Last active November 25, 2017 13:14
Show Gist options
  • Save sergeymakinen/0696a5952f160ea28d7b64c3adfecf6f to your computer and use it in GitHub Desktop.
Save sergeymakinen/0696a5952f160ea28d7b64c3adfecf6f to your computer and use it in GitHub Desktop.
My Yii 2 DB test environment
YII=/Users/sergeymakinen/Projects/3rd/yii2-dev
docker-compose run --rm php5.6 vendor/bin/phpunit --group=oci --colors=always --verbose

Oracle's tests segfault on PHP 7.x. There's nothing I can do.

<?php
$override = [
'databases' => [
'cubrid' => [
'dsn' => 'cubrid:dbname=docker;host=cubrid;port=33000',
'username' => 'docker',
'password' => 'docker',
],
'mysql' => [
'dsn' => 'mysql:host=mysql;dbname=docker',
'username' => 'docker',
'password' => 'docker',
],
'sqlite' => [
'dsn' => 'sqlite:/tmp/yii.db',
],
'sqlsrv' => [
'dsn' => 'sqlsrv:Server=sqlsrv;Database=docker',
'username' => 'docker',
'password' => 'docker',
],
'pgsql' => [
'dsn' => 'pgsql:host=pgsql;dbname=docker',
'username' => 'docker',
'password' => 'docker',
],
'oci' => [
'dsn' => 'oci:dbname=//oci:1521/xe;charset=AL32UTF8',
'username' => 'docker',
'password' => 'docker',
],
],
];
$config = yii\helpers\ArrayHelper::merge($config, $override);
version: '3'
services:
php5.6:
container_name: yii2-php5.6
image: sergeymakinen/yii2-php:5.6
tmpfs:
- /tmp
- /yii/tests/runtime
volumes:
- $YII:/yii
networks:
- yii2
links:
- mysql
- pgsql
- cubrid
- oci
php7.0:
container_name: yii2-php7.0
image: sergeymakinen/yii2-php:7.0
tmpfs:
- /tmp
- /yii/tests/runtime
volumes:
- $YII:/yii
networks:
- yii2
links:
- mysql
- pgsql
- sqlsrv
- oci
php7.1:
container_name: yii2-php7.1
image: sergeymakinen/yii2-php:7.1
tmpfs:
- /tmp
- /yii/tests/runtime
volumes:
- $YII:/yii
networks:
- yii2
links:
- mysql
- pgsql
- sqlsrv
- oci
mysql:
container_name: yii2-mysql
image: sergeymakinen/test-db:mysql-5.1
tmpfs: /tmp
volumes:
- ./.docker/mysql:/var/lib/mysql
networks:
- yii2
ports:
- 34000:3306
pgsql:
container_name: yii2-pgsql
image: sergeymakinen/test-db:postgresql-9.3
tmpfs: /tmp
volumes:
- ./.docker/pgsql:/var/lib/postgresql/data
ports:
- 34001:5432
networks:
- yii2
sqlsrv:
container_name: yii2-sqlsrv
image: sergeymakinen/test-db:mssql-17.0
tmpfs: /tmp
# volumes:
# - ./.docker/sqlsrv:/var/opt/mssql/data
ports:
- 34002:1433
networks:
- yii2
cubrid:
container_name: yii2-cubrid
image: sergeymakinen/test-db:cubrid-9.3
tmpfs: /tmp
volumes:
- ./.docker/cubrid:/var/lib/cubrid
networks:
- yii2
ports:
- 34003:33000
oci:
container_name: yii2-oci
image: sergeymakinen/test-db:oracle-11.2
tmpfs: /tmp
volumes:
- ./.docker/oci:/u01/app/oracle
ports:
- 34004:1521
networks:
- yii2
networks:
yii2:
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment