app_local

<?php
use Cake\Datasource\ConnectionManager;

$datasource_json = ROOT . DS . "plugins" . DS . "Settings" . DS . "config" . DS . "datasource.json";
$content = json_decode(file_get_contents($datasource_json), true);
debug($content);
if(empty($content['password'])){
    $dsn = "mysql://".$content['username']."@".$content['host']."/".$content['database'];
} else{
    $dsn = "mysql://".$content['username'].":".$content['password']."@".$content['host']."/".$content['database'];
}
debug($dsn);
$con = ConnectionManager::config('default', ['url' => $dsn]);
debug($con);
$connection = ConnectionManager::get('default');
debug($connection);
if(!isset($connection)){
    echo "Not a Database";
}

return [
    'Datasources' => [
        'default' => [
            'className' => 'Cake\Database\Connection',
            'driver' => 'Cake\Database\Driver\Mysql',
            'persistent' => false,
            'host' => $content['host'],
            /**
             * CakePHP will use the default DB port based on the driver selected
             * MySQL on MAMP uses port 8889, MAMP users will want to uncomment
             * the following line and set the port accordingly
             */
            //'port' => 'non_standard_port_number',
            'username' =>  $content['username'],
            'password' => $content['password'],
            'database' => $content['database'],
            'encoding' => 'utf8',
            'timezone' => 'UTC',
            'flags' => [],
            'cacheMetadata' => true,
            'log' => false,

            /**
             * Set identifier quoting to true if you are using reserved words or
             * special characters in your table or column names. Enabling this
             * setting will result in queries built using the Query Builder having
             * identifiers quoted when creating SQL. It should be noted that this
             * decreases performance because each query needs to be traversed and
             * manipulated before being executed.
             */
            'quoteIdentifiers' => false,

            /**
             * During development, if using MySQL < 5.6, uncommenting the
             * following line could boost the speed at which schema metadata is
             * fetched from the database. It can also be set directly with the
             * mysql configuration directive 'innodb_stats_on_metadata = 0'
             * which is the recommended value in production environments
             */
            //'init' => ['SET GLOBAL innodb_stats_on_metadata = 0'],

            'url' => env('DATABASE_URL', null),
        ]
    ]
];