cross-database join

[andrtechno]

Proposed new feature or change

ActiveQuery -> joinWith не поддерживает join разных баз (на одном сервере)

class A extends ActiveRecord
{
    public static function getDb()
    {
        return Yii::$app->get('main');
    }

    public function getB(): \yii\db\ActiveQuery
    {
        return $this->hasOne(B::class, ['id' => 'b_id']);
    }
}


class B extends ActiveRecord
{
    public static function getDb()
    {
        return Yii::$app->get('second');
    }
}

Example

$q = A::find()->joinWith(['b'])->one();

было бы не плохо сделать чтобы поддерживало

[samdark]

That is quite a rare use case, but sometimes it is worth having. We don't have any projects with that configuration, and that's the first time, as far as I remember, we've gotten such a feature request, so for us that's not a big priority.

[samdark]

If you want it bad, consider creating a pull request adding the feature.