Re: [sqlalchemy] Mapping views as Table/ORM

2013-08-13 Thread temp4746
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

Re: [sqlalchemy] Mapping views as Table/ORM

2013-08-13 Thread Michael Bayer
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:

Re: [sqlalchemy] Mapping views as Table/ORM

2013-08-09 Thread Werner
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