View/Trigger in database by migration

[markstory]

From @AndreLZGava on January 15, 2018 18:58

This is a (multiple allowed):

• [ ] bug

• [ ] enhancement

• [X] feature-discussion (RFC)

• CakePHP Version: CakePHP3.4

• Platform and Target: Linux, Postgres

What you did

I tried to create a migration that creates a view function in my database

What happened

I couldn't create

What you expected to happen

I expected to create a view function in my database, I'd like to create that functions as anot

P.S. Remember, an issue is not the place to ask questions. You can use Stack Overflow I tried to ask in stack, just a man answered my question, but the answer didn't help

Before you open an issue, please check if a similar issue already exists or has been closed before.

Copied from original issue: cakephp/cakephp#11632

[markstory]

This might require changes in phinx as well. To my knowledge it does not support creating views outside of executing SQL either.

[sagittaracc]

I really need this. What's the work around so far?

[dereuromark]

This could be revisited with https://github.com/cakephp/migrations/issues/647 done