Seems like a reasonable way to do this until maybe one day proper support
is added to sqlalchemy.
I'm still missing one thing though, it seems like there is a feature that
allows you to reflect views, but it reflects them as a Table and as such
when you later on try to create_all(), it will
maybe use a separate MetaData collection when reflecting your views, so that
create_all() isn't impacted. The View recipe could also be enhanced to support
reflection, you can use the inspector to get at lists of columns individually:
On 09/08/2013 10:55, temp4...@gmail.com wrote:
It seems that SQLAlchemy has no support for creating views by a View
construct or something like that but you can map them as a Table or
even an ORM class when applicable, and query from them, the problem is
that SQLAlchemy will than try to create