Calling a database view in Yii using Active Record

Question

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?

It should work fine in the same way as with tables. Just use the view name when you generate the model. — Pentium10
– Pentium10, Commented Apr 25, 2011 at 20:40
Well that was a silly oversight. Thank you. That worked. Answer the question and I'll give you credit. — k to the z
– k to the z, Commented Apr 25, 2011 at 20:43

Joshua · Accepted Answer · 2015-03-27 16:03:06Z

7

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.

answered Mar 27, 2015 at 16:03

Joshua

6941 gold badge8 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Pentium10 · Accepted Answer · 2017-08-09 14:05:57Z

6

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.

edited Aug 9, 2017 at 14:05

answered Apr 25, 2011 at 20:44

Pentium10

209k124 gold badges435 silver badges513 bronze badges

3 Comments

open-ecommerce.org Over a year ago

Not sure why this answer it is marked as correct and has 7 because the active model needs a primary key to work by design and you won't have it in a db you can try the Joshua tip though

Pentium10 Over a year ago

@open-ecommerce.org just because Joshua completed 4 years later the answer, and Yii versions have been updated.

jagel.id Over a year ago

Not working, model need primary key, the solution by Joshua is working

Collectives™ on Stack Overflow

Calling a database view in Yii using Active Record

2 Answers 2

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related