Two Database Connections In Yii Mongodbsuite

pulsar · October 24, 2012, 2:21pm

How to make two and more database connections in Yii mongodbsuite?

I write 2 DB in main.php

‘components’ => array(

'mongodb' =&gt; array(


    'class'             =&gt; 'common&#092;extentions&#092;MongoDB',


    'connectionString'  =&gt; 'mongodb://localhost:27017/table1',


    'dbName'            =&gt; 'table1',


    'fsyncFlag'         =&gt; false,


    'persistentConnection' =&gt; 'x',


    'replicaSet'        =&gt; false,


    'safeFlag'          =&gt; true,


    'useCursor'         =&gt; false,


),





'mongodb2' =&gt; array(


    'class'             =&gt; 'common&#092;extentions&#092;MongoDB',


    'connectionString'  =&gt; 'mongodb://localhost:27017/table2',


    'dbName'            =&gt; 'table2',


    'fsyncFlag'         =&gt; false,


    'persistentConnection' =&gt; 'x',


    'replicaSet'        =&gt; false,


    'safeFlag'          =&gt; true,


    'useCursor'         =&gt; false,


),

) But how use mongodb2 in query (ex: ->findByAttributes()) i don’t know. Please type some example query to mongodb2.

In my project all models extends \web\extensions\MongoDocument (NOT CActiveRecord). So article Multiple db support in Yii not work for me.

pulsar · October 25, 2012, 6:37am

I just add ‘mongodb2’ => array to ‘components’ => array and add to models ( ex: User) who extends EMongoDocument just one method:

public function getMongoDBComponent()

{

return Yii::app()-&gt;mongodb2;

}

And it is work!