Difference between #2 and #4 of
Multiple-database support in Yii

Changes

Title unchanged

Multiple-database support in Yii

Category unchanged

How-tos

Yii version unchanged

Tags unchanged

Database

Content changed

[...]
Once this is defined, the second database is referred to as `Yii::app()->dbadvert` rather than `Yii::app()->db` (of course, the first is still available).

But we can do much better integration than this, starting with Gii and ending with AR support.
Using Gii
---------
Gii can use multiple database connections in Yii > 1.1.11.
 
 
If you are using a previous version, Gii only knows how to use the primary database connection, so for a brief time while creating models/controllers/crud, you'll have to edit your `protected/config/main.php` file to temporarily make the advertising database the primary `db` connection:

```php
[...]
else
throw new CDbException(Yii::t('yii','Active Record requires a "db" CDbConnection application component.'));
     }
}
...
```
This method is **purposely** static: the underlying cached `$dbadvert` value is, so the function may as well be be too. Now, with this helper prepared, we can edit the model itself:
[...]
20 0
39 followers
Viewed: 144 316 times
Version: 1.1
Category: How-tos
Tags: database
Written by: Steve Friedl
Last updated by: phazei
Created on: Dec 21, 2010
Last updated: 11 years ago
Update Article
Revert to #2 | Revert to #4

Revisions

View all history