[sqlalchemy] Problems with CachingQuery, query is performed but data is returned from cache

2010-05-07 Thread Ergo
Hello, I'm having a strange problem with CachingQuery. I have a model that looks like this: User(object): . @classmethod def by_id(cls, id, cache=FromCache(default, by_id), invalidate=False): q = meta.Session.query(User).filter(User.id == id) if cache: q

Re: [sqlalchemy] Problems with CachingQuery, query is performed but data is returned from cache

2010-05-07 Thread Michael Bayer
On May 7, 2010, at 10:44 AM, Ergo wrote: now unless i call User.by_id(id, invalidate=True), All my queries contain wrong cached data. even if i do directly in controller of my app something like: c.users = meta.Session.query(User).order_by(User.username).limit(30) the returned rows will