Cacading View Support

[wolfthom]

I am currently struggling with cascading views.

Let's say I have defined base views A and B. Now C refers to A and B in its sql definition. So C is dependent from A and B and needs to be created after A and B. There is no way (that I was aware of, at least) to ensure order of creation.

As tables do not have dependencies, SQLAlchemy Table object does not detect dependencies nor support for specifying dependencies.

Any ideas?

[jklukas]

You're correct that this library provides no facility for helping with defining order of view creation. It would be up to your controlling code to order these correctly. Although we do support a cascade option for dropping views.