Generating models from database views in Yii

Question

Am trying to generate models from database views with the sole purpose of viewing and searching complex records from various tables.

However I get "Table 'XXX' does not exist".Logically views are like tables.

Any creative workarounds?

As far as i know, database views are not supported in yii. Is'n it anymore? ...but maybe this changed at an new yii version!? — The Bndr
– The Bndr, Commented May 10, 2011 at 16:40
@ the bndr: I'm looking at an AR class generated by gii off a database view. They are just treated like tables that you can only select. — k to the z
– k to the z, Commented May 10, 2011 at 18:12

Community · Accepted Answer · 2017-05-23 10:24:28Z

3

I created a AR model of a view using gii a few days ago. I just had to put in the view name and it worked. You must be typing the view name wrong.

Here is the SO question I asked about it a while ago.

edited May 23, 2017 at 10:24

CommunityBot

11 silver badge

answered May 10, 2011 at 14:54

k to the z

3,1952 gold badges29 silver badges41 bronze badges

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

Comments

Wasim Pathan · Accepted Answer · 2013-09-30 09:33:56Z

0

That is a system-specific database access violation, and does not relate to the Yii code at least, have your webhost equip your MySQL username with SHOW VIEW privileges for the database.

answered Sep 30, 2013 at 9:33

Wasim Pathan

4205 silver badges17 bronze badges

Collectives™ on Stack Overflow

Generating models from database views in Yii

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related