Switching databases between development and deployment

tklustig · July 31, 2017, 12:25pm

Hy guys,

how to switch probably databases from development to deployment in yii2-advanced!

I use following config-file:




.

.

.

     'db_developpment' => [

            'class' => 'yii\db\Connection',

            'dsn' => 'mysql:host=localhost;dbname=yii2_widget',

            'username' => 'root',

            'password' => '',

            'charset' => 'utf8',

        ],

        'db_deployment' => [

            'class' => 'yii\db\Connection',

            'dsn' => 'mysql:host="http:/tklustig.ddns.net";dbname=yii2_widget',

            'username' => 'my_name',

            'password' => 'my_password',

            'charset' => 'utf8',

        ],

.

.

.

I suppose, it’s necessary to code an IF-statement in order to difference between developpment and deployment settings.

How to code this IF-statement correctly?

patrickm · July 31, 2017, 1:36pm

That’s what environments are for in the advanced template.

github.com

yiisoft/yii2-app-advanced/blob/master/docs/guide/structure-environments.md

Configuration and environments
==============================

There are multiple problems with a typical approach to configuration:

- Each team member has its own configuration options. Committing such config will affect other team members.
- Production database password and API keys should not end up in the repository.
- There are multiple server environments: development, testing, production. Each should have its own configuration.
- Defining all configuration options for each case is very repetitive and takes too much time to maintain.

In order to solve these issues Yii introduces a simple environments concept. Each environment is represented
by a set of files under the `environments` directory. The `init` command is used to initialize an environment. What it really does is
copy everything from the environment directory over to the root directory where all applications are.

By default there are two environments: `dev` and `prod`. First is for development. It has all the developer tools
and debug turned on. Second is for server deployments. It has debug and developer tools turned off. 

Typically environment contains application bootstrap files such as `index.php` and config files suffixed with
`-local.php`. Local configs in `environments` directory are templates that, after `init` is executed, 
are being copied into corresponding application config directories. After that, they become your local configuration.

This file has been truncated. show original

tklustig · July 31, 2017, 1:58pm

As it seems, I found solution by myself. Is it probably or just functionally?




<?php

if(YII_ENV=='prod'){

return [

    'components' => [

        'db' => [

            'class' => 'yii\db\Connection',

            'dsn' => 'mysql:host=http://tklustig.ddns.net;dbname=yii2_widget',

            'username' => 'my_name',

            'password' => 'my_password',

            'charset' => 'utf8',

        ],

   

    ],

];

}else{

return [

    'components' => [

        'db' => [

            'class' => 'yii\db\Connection',

            'dsn' => 'mysql:host=localhost;dbname=yii2_widget',

            'username' => 'root',

            'password' => '',

            'charset' => 'utf8',

        ],

   

    ],

];

}

?>