Calling a database view in Yii using Active Record

问题:

I understand how to query a table with Yii's active record environment. I can't find documentation for calling a mysql view. Also, I know how to model a table in active record with the gii tool, but is there a way to do this for a database view?

回答1:

It should work fine in the same way as with tables. Just use the view name when you generate the model.

Please read Joshua's answer and learn how to add primary Key into the OOP model for views.

回答2:

I am not having the same experience and this comment is for those who are having trouble.

Using a mysql view with some joins and calculations I get the following error..

app\\models\\db\\WarComplete must have a primary key.

I resolved this by adding...

public static function primaryKey()
{
    return ['id'];
}

... to my model override.