I have a main database that contain information like user, country and cities. I have another database contain business listing. I wrote a relation between the table but it failed. Just want to confirm can relation work across database?
class User extends CActiveRecord
{…
public function getDbConnection()
{
return A;
}
class UserBusiness extends CActiveRecord
{…
public function getDbConnection()
{
return A
}
…
public function relations()
{
return array(
'user' => array(self::HAS_ONE, 'User', 'user_id'),
'business' => array(self::HAS_ONE, 'Business', 'business_id'),
);
}
class Business extends CActiveRecord
{…
public function getDbConnection()
{
return B;
}