[sqlalchemy] Re: Advice on integrating Alchemy with a caching mechanism such as Shove

2009-04-24 Thread phrrn...@googlemail.com
I wasn't able to achieve what I wanted without mucking around with private methods but the code below does work very nicely with reference tables. The code generator pokes in the log10 rowcount as of the time the schema was sampled (I use log10 so that we don't get a bunch of spurious diffs if a

[sqlalchemy] Re: Advice on integrating Alchemy with a caching mechanism such as Shove

2009-04-15 Thread Michael Bayer
for SQLA integration you'd probably build this into the Session/Query, which is most easily accomplished by subclassing Query. some examples are in the distribution in examples/query_caching. I use a variant of the with_cache_key version for my own purposes. phrrn...@googlemail.com wrote:

[sqlalchemy] Re: Advice on integrating Alchemy with a caching mechanism such as Shove

2009-04-15 Thread phrrn...@googlemail.com
Beautiful. I am impressed at the elegance of this sample and the others also. pjjH On Apr 15, 3:26 pm, Michael Bayer mike...@zzzcomputing.com wrote: for SQLA integration you'd probably build this into the Session/Query, which is most easily accomplished by subclassing Query.   some examples