[sqlalchemy] Re: sqlalchemy introspection How?

2007-04-28 Thread Andreas Jung
--On 27. April 2007 12:57:06 -0700 johnny [EMAIL PROTECTED] wrote: Does this create a Object Mappers for those tables, so I can do the following: Lets say I have a table called user with columns user_name and password. ed = User() ed.user_name = 'Ed' ed.password = 'edspassword' You might

[sqlalchemy] 'MapperExtension' object has no attribute 'translate_row'

2007-04-28 Thread Sanjay
Hi, While updated from version 0.3.3 to 0.3.6, I am getting this error: 'MapperExtension' object has no attribute 'translate_row' A bug? Any clues would help. thanks Sanjay --~--~-~--~~~---~--~~ You received this message because you are subscribed to the

[sqlalchemy] Re: sqlalchemy introspection How?

2007-04-28 Thread Andreas Jung
--On 28. April 2007 09:00:36 -0700 johnny [EMAIL PROTECTED] wrote: What I was trying to get was, there isn't a python command line option, that will create Object Mapper Classes for the tables, What should that be? so I can import them within my applications. I guess, I have to code

[sqlalchemy] Re: Using MAX in a relation() without an inner SELECT

2007-04-28 Thread Michael Bayer
On Apr 27, 2007, at 9:32 PM, Brian Beck wrote: Hi, We've got a CMS model with a revisioned page tree. Our pages have a revision number and a parent page (it's a self-referential mapper). One property we'd like to have in our assign_mapper call is a latest_parent relation -- a property

[sqlalchemy] Re: distinct doesn't work with join

2007-04-28 Thread Michael Bayer
On Apr 28, 2007, at 2:58 AM, ml wrote: Hi! I have tables recipes and recipes_ctgs (M:N relation). Mappers: mapper(Recipe, recipes, order_by = desc(recipes.c.date)) mapper(RecipesCtg, recipes_ctgs, order_by=recipes_ctgs.c.title, properties={ recipes: relation(Recipe,

[sqlalchemy] Bug with order_by and certain versions of mysql

2007-04-28 Thread Ram Yalamanchili
Hey, I had this issue where doing something like: My hosting server uses: MySQL 4.1.13a (MacOS), and they wont be upgrading till Mac OS panther is out unfortunately :( I use a later version on my dev box, and things work fine with a query like: In my User table mapper object: def