<?php

/**

* Test harness bootstrap that sets up initial defines and builds up the initial database schema

*/

// Bring in our standard bootstrap

include_once __DIR__ . '/../bootstrap/autoload.php';

require_once __DIR__ . '/../bootstrap/app.php';

use Illuminate\Contracts\Console\Kernel;

use Illuminate\Support\Facades\Artisan;

use ProcessMaker\Models\ScriptExecutor;

// Bootstrap laravel

app()->make(Kernel::class)->bootstrap();

// Cache with new config so we don't overwrite our local development database

Artisan::call('config:cache', ['--env' => 'testing']);

//Ensure storage directory is linked

Artisan::call('storage:link', []);

if (env('RUN_MSSQL_TESTS')) {

// Setup our testexternal database

config(['database.connections.testexternal' => [

'driver' => 'mysql',

'host' => env('DB_HOST', '127.0.0.1'),

'port' => env('DB_PORT', '3306'),

// We set database to null to ensure we can create the testexternal database

'database' => null,

'username' => env('DB_USERNAME', 'root'),

'password' => env('DB_PASSWORD', ''),

'unix_socket' => env('DB_SOCKET', ''),

'prefix' => '',

'strict' => true,

'engine' => null,

]]);

// First create the test external mysql database as well as our test database

DB::connection('testexternal')->unprepared('CREATE DATABASE IF NOT EXISTS testexternal');

// First create the test external mysql database as well as our test database

DB::connection('testexternal')->unprepared('CREATE DATABASE IF NOT EXISTS userexternal');

// Now set the database name properly

config(['database.connections.testexternal.database' => env('DB_TESTEXTERNAL_DB', 'testexternal')]);

DB::connection('testexternal')->reconnect();

// Now, drop all test tables and repopulate with schema

Schema::connection('testexternal')->dropIfExists('test');

Schema::connection('testexternal')->create('test', function ($table) {

$table->increments('id');

$table->string('value');

});

DB::connection('testexternal')->table('test')->insert([

'value' => 'testvalue',

]);

// Only do if we are supporting MSSql tests

config(['database.connections.mssql' => [

'driver' => 'sqlsrv',

'host' => env('MSSQL_HOST', '127.0.0.1'),

'database' => null,

'username' => env('MSSQL_USERNAME', 'root'),

'password' => env('MSSQL_PASSWORD', ''),

]]);

$mssqlDBName = env('MSSQL_DATABASE', 'testexternal');

// First create the test external mysql database as well as our test database

DB::connection('mssql')->unprepared("if db_id('" . $mssqlDBName . "') is null\nCREATE DATABASE " . $mssqlDBName);

// Now set the database name properly

config(['database.connections.mssql.database' => $mssqlDBName]);

DB::connection('mssql')->reconnect();

Schema::connection('mssql')->dropIfExists('test');

Schema::connection('mssql')->create('test', function ($table) {

$table->increments('id');

$table->string('value');

});

DB::connection('mssql')->table('test')->insert([

'value' => 'testvalue',

]);

}

// setup parallel test databases

if (env('TEST_TOKEN')) {

$database = 'test_' . env('TEST_TOKEN');

$_ENV['DB_DATABASE'] = $database;

$_ENV['DATA_DB_DATABASE'] = $database;

} elseif (env('POPULATE_DATABASE')) {

Artisan::call('db:wipe', ['--database' => \DB::connection()->getName()]);

Artisan::call('migrate:fresh', []);

Artisan::call('db:seed', ['--class' => 'AnonymousUserSeeder']);

\Illuminate\Foundation\Testing\RefreshDatabaseState::$migrated = true;

ScriptExecutor::firstOrCreate(

['language' => 'php'],

['title' => 'Test Executor']

);

ScriptExecutor::firstOrCreate(

['language' => 'lua'],

['title' => 'Test Executor']

);

if (env('PARALLEL_TEST_PROCESSES')) {

Artisan::call('processmaker:create-test-dbs');

}

}