On Sep 4, 2008, at 1:39 AM, gniquil wrote:
> documented. The sqlalchemy expression language can't really do very > well here either (at least too proprietary in some ways...sort of like > working with pylons versus working with a CMS like Plone, which both > can be used to create a blog, but one gives more control, and the > knowledge is more readily out there). well the statement above can pretty easily be represented with a SQLA select()....but im sensing some personal preference stuff here which is OK. > Anyway, to keep this short, can anyone find a way to somehow integrate > such a templating idea into sqlalchemy while leveraging the convention > already established in ansi-sql and some python voodoo? (Of course, > the existing stuff is great for creating transactional type of > backend, like a blog or wiki, which then again, really occupies 10% of > my time, and hopefully (or not) others as well.) it would pretty much be connection.execute(my_sql_template.render()) ..... or perhaps using text() if you'd like some of SQLA's bind param/result typing capabilities. The SQL expression tutorial has info on select(), text(), and execute(). --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---