Created
December 22, 2016 20:41
-
-
Save lightbyte/957958f4b22fe5ff605daf6db6b4d8fb to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 'Datasources' => [ | |
| 'default' => [ | |
| 'className' => 'Cake\Database\Connection', | |
| 'driver' => 'Cake\Database\Driver\Mysql', | |
| 'persistent' => false, | |
| 'host' => 'localhost', | |
| /** | |
| * 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' => 'xxx', | |
| 'password' => 'xxx', | |
| 'database' => 'xxx', | |
| '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), | |
| ], | |
| /** | |
| * The test connection is used during the test suite. | |
| */ | |
| 'test' => [ | |
| 'className' => 'Cake\Database\Connection', | |
| 'driver' => 'Cake\Database\Driver\Mysql', | |
| 'persistent' => false, | |
| 'host' => 'localhost', | |
| //'port' => 'non_standard_port_number', | |
| 'username' => 'my_app', | |
| 'password' => 'secret', | |
| 'database' => 'test_myapp', | |
| 'encoding' => 'utf8', | |
| 'timezone' => 'UTC', | |
| 'cacheMetadata' => true, | |
| 'quoteIdentifiers' => false, | |
| 'log' => false, | |
| //'init' => ['SET GLOBAL innodb_stats_on_metadata = 0'], | |
| 'url' => env('DATABASE_TEST_URL', null), | |
| ], | |
| ], |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment