[sqlalchemy] Re: Asynchronous SQLAlchemy--Anybody using Twisted, sAsync?

2007-02-24 Thread Manlio Perillo
Allen Bierbaum ha scritto: On 2/21/07, Manlio Perillo [EMAIL PROTECTED] wrote: Matt Culbreth ha scritto: Howdy Group, I'm playing out with a few things now and I wanted to see if anyone else has used SQLAlchemy in an asynchronous manner? For example, you could create a service which

[sqlalchemy] Re: Tool to autogenerate code from db schema

2007-02-24 Thread Paul Johnston
Hi, Well, I had a little go at this, see http://www.sqlalchemy.org/trac/wiki/UsageRecipes/AutoCode Paul --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to

[sqlalchemy] Re: how to force a clean refresh of a lazy loaded attribute

2007-02-24 Thread Michael Bayer
On Feb 23, 2007, at 1:56 PM, Manlio Perillo wrote: Hi again. I have an object attribute loaded via lazy loader. This object is loaded in a transaction. Then, in another transaction, I ussue an update statement (via the sql module, not using the orm), that updates the table of the main

[sqlalchemy] how to get column names in result

2007-02-24 Thread vkuznet
Hi, a very simple question which I cannot find in documentation. How to get column names together with result. This is useful for web presentation of results using templates. I used use_labels=True, indeed it construct query with names, but my final result contains only column values. What I

[sqlalchemy] Re: select ... having problems

2007-02-24 Thread Jonathan Ellis
Something like this should work: select(['count(distinct flow.node_id) as nodes', ip], from_obj=[flow.join(id)], group_by=[flow.c.src_id], having=['nodes 5'], order_by=[desc('nodes')]) If you wanted to do it w/o text blocks I think you'd have to create a subselect first to pull the nodes