CreateView migration command

[gingermusketeer]

It would be great if we could create and drop views in migrations.

[samdark]

Could you elaborate?

[gingermusketeer]

Something along the lines of

$this->createView('viewName', ' SELECT * FROM sometable WHERE something=1');

and

$this->dropView('someView');

Not sure if we can avoid the select statement but it is probably a good idea to have it anyways.

Hope that helps.

[samdark]

Makes sense. I've verified that syntax for basics of view creation is the same for all DBs we currently support.

[romdim]

Hello! Is there any update on the matter? Thank you very much in advance!

[samdark]

@romdim no. We aren't allocating resources on 1.1 new features and enhancements focusing mainly on 2.0 and 1.1 bugs. If you want you can help us implementing it and sending a pull request.

[yuracher]

Hi! It is planned to implement in Yii2?

[cebe]

@yuracher create an issue on https://github.com/yiisoft/yii2/issues