not that I'm aware of but its something I consider often. the closest right now is if the SP is callable as in func.foo(), you can map to func.foo().
http://www.sqlalchemy.org/trac/wiki/07Migration#Non-Table-derivedconstructscanbemapped but this considers the function to be like a "view", which SPs generally are not. the big question on SPs is what does the usage pattern look like...Query() is a question here. I suppose if you did session.query(MyClass).params(x, y, z) and x, y, z go into func.foo(), there you go. It would probably work. On Jun 7, 2011, at 5:30 AM, Chris Withers wrote: > Hi All, > > Are there any example knocking about of mapping the results of a MySQL stored > procedure to an object? > > cheers, > > Chris > > -- > Simplistix - Content Management, Batch Processing & Python Consulting > - http://www.simplistix.co.uk > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
