[sqlalchemy] Re: Accessing Views with SqlAlchemy

2008-09-04 Thread az
put a class ABC(object): pass and see what it gets filled with? On Thursday 04 September 2008 00:10:44 Mike wrote: On Sep 3, 3:45 pm, Michael Bayer [EMAIL PROTECTED] wrote: On Sep 3, 2008, at 4:14 PM, Mike wrote: Replying to my own message seems kind of schizo, but I found one solution.

[sqlalchemy] Re: Accessing Views with SqlAlchemy

2008-09-03 Thread Mike
On Sep 3, 11:29 am, Mike [EMAIL PROTECTED] wrote: Hi, I need to interface with a couple of Views in Microsoft SQL Server 2000. How do I go about doing this with SqlAlchemy? Since a View doesn't have columns per se, how do I go about creating a class and a table object to map them? I

[sqlalchemy] Re: Accessing Views with SqlAlchemy

2008-09-03 Thread Michael Bayer
On Sep 3, 2008, at 4:14 PM, Mike wrote: Replying to my own message seems kind of schizo, but I found one solution. I reflected the view into a Table() object and then used the select method along with and_ and not_. I would prefer to use the session object, but this works. I'm currently

[sqlalchemy] Re: Accessing Views with SqlAlchemy

2008-09-03 Thread Mike
On Sep 3, 3:45 pm, Michael Bayer [EMAIL PROTECTED] wrote: On Sep 3, 2008, at 4:14 PM, Mike wrote: Replying to my own message seems kind of schizo, but I found one solution. I reflected the view into a Table() object and then used the select method along with and_ and not_. I would