How to work with multiple bases in Yii?

Question

MySQL

I want to make such piece: at registration for the company the separate database is created. There are pros and cons to this, but this is not about that now.
I have no experience with such an architecture. Please let me know how it can be done properly.
I googled and found yiiframework.ru/doc/cookbook/ru/model.multiple.dat... but it didn't give me a complete idea how to do it.

Answer 1

Hmm, everything is described in detail there, in the configs you specify the database configurations, and in the model using getDbConnection you indicate which database the model belongs to

class Model extends CActiveRecord {
    public function getDbConnection(){
        return Yii::app()->db2; // db2 - имя базы из конфига
    }
}

Please clarify what you don't understand.

Answer 2

In Yii, all work with the database goes through an instance of the CDbConnection class. You need to slip the connection to the base you need wherever you need it. How exactly to do this depends on the specifics of the application you are developing. If, for example, you can definitely determine which company the current user belongs to within one http request, and you are sure that within this http request you will not need any database other than the database of his company, then you can make a "dynamic" configuration of the component db in the application config.

Answer 3

everything is very simple, in the config
'components'=>array(
'dbGlobal'=>array(
)
) you
call it via Yii::app()->dbGlobal->..
when you work with a company, then most likely access to the database is stored in the global database
, you need to create a db component through createComponent with which you will work within the company

Answer 4

Here is an example of a config from a working project that works with two databases:

'components'=>array(
     'oradb'=>array(
         'class' => 'ext.oci8Pdo.OciDbConnection',
         'connectionString' => 'oci:dbname=xxx.xxx.xxx.xxx:xxxx/dbo;charset=AMERICAN_AMERICA.cl8mswin1251',
         'username' => 'login',
         'password' => 'password',
         'enableProfiling' => TRUE,
         'enableParamLogging' => TRUE,
     ),

     'mydb'=>array(
         'class' => 'CDbConnection',
         'connectionString' => 'mysql:host=localhost;dbname=somedb',
         'username' => 'login',
         'password' => 'password',
         'charset' => 'UTF8',
     ),
…
);

Well, in the code, calls to databases go through Yii::app()->mydb or Yii::app()->oradb