1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
|
<?php
/**
* Xibo - Digital Signage - http://www.xibo.org.uk
* Copyright (C) 2006-2018 Spring Signage Ltd
*
* This file is part of Xibo.
*
* Xibo is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* any later version.
*
* Xibo is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public License
* along with Xibo. If not, see <http://www.gnu.org/licenses/>.
*
*/
// We need to define XIBO as the settings.php file is protected with a !defined check.
if (!defined('XIBO')) {
DEFINE('XIBO', true);
}
// Return the PHINX configuration object
// this should be based on our settings.php file
// in the case of a Docker installation the settings.php file will contain $_SERVER vars which we can use directly
// as they are environment variables in the container (and the phinx phar file will have them)
// in the case of a manual installation, these will be hard-coded in the settings file - in which case we can still
// use them.
require('web/settings.php');
// Our settings file exposes HOST:PORT rather that separate variables
if (strstr($dbhost, ':')) {
$hostParts = explode(':', $dbhost);
$dbhost = $hostParts[0];
$dbport = $hostParts[1];
} else {
$dbport = 3306;
}
// Phinx formatted config array using the settings we've harvested from our settings.php file
return [
'paths' => [
'migrations' => '%%PHINX_CONFIG_DIR%%/db/migrations'
],
'environments' => [
'default_database' => 'production',
'production' => [
'adapter' => 'mysql',
'charset' => 'utf8',
'host' => $dbhost,
'port' => $dbport,
'name' => $dbname,
'user' => $dbuser,
'pass' => $dbpass,
]
]
];
|