I have some interest in working out ways to integrate stored procedures with SQLAlchemy though at the moment the points of integration are very rudimental. You can invoke a stored procedure, get results, and also create a "selectable" that would define the columns that come back from one (that's at http://www.sqlalchemy.org/docs/core/tutorial.html#functions). Postgresql functions are also handy for various ad-hoc queries and I've used them for things like computing statistical values as columns.
As far as a full blown persistence layer with SPs, there's no established patterns for any of that so you'd be working that out yourself - I might skip usage of ORM mapped classes and build out something based on SQL expressions. On Sep 1, 2011, at 8:27 AM, Krishnakant Mane wrote: > hello all, > I am thinking of programming a lot of stored procedures for my postgresql > based application. > I would like to know if using the expression API is a way that can give me > the power of sqlalchemy's eas and comfort, at the same time make use of the > performance bennifits I will get from postgresql's stored procedure? In > short I would like to know if the approach is worthwile and how? > Happy hacking. > Krishnakant. > > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to sqlalchemy@googlegroups.com. > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com. > 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 sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
