[sqlalchemy] Re: something wrong with relationship caching at _trunk_

2010-12-22 Thread sector119
from beaker import cache from sqlalchemy import * from sqlalchemy.orm import mapper, sessionmaker, scoped_session, relationship from sqlalchemy.types import * # from examples/beaker_caching from eps.model import caching_query ### INIT cache_manager = cache.CacheManager() metadata = MetaData()

[sqlalchemy] Re: something wrong with relationship caching at _trunk_

2010-12-22 Thread sector119
% python2.6 sacache.py 1. sector119 groups: G1 2. sector119 groups: G1 1. sector120 groups: G1 2. sector120 groups: G1 -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe

[sqlalchemy] Re: something wrong with relationship caching at _trunk_

2010-12-22 Thread sector119
The same from dpaste.com: http://dpaste.com/289387/ It works with revision 6944: % pwd /home/eps/devel/src/sqlalchemy.6944 % python2.6 setup.py develop running develop ... Finished processing dependencies for SQLAlchemy==0.6.6dev % hg log|head -n1 changeset: 6944:b29164cca942 % python2.6

[sqlalchemy] Adding order_by, offset and limit support to Delete

2010-12-22 Thread Tarek Ziadé
Hello, I need to add order_by, limit and offset support to Delete objects for MySQL. Here's what I've done so far, which works. See the long paste below, I use delete() on my tables. I would like to know if this is the right way to do things, or if I am missing something. I am currently using

[sqlalchemy] Re: versioning when updating a relationship

2010-12-22 Thread Andronikos Nedos
The versioning example appears to be cautious about determining if there was a net change present.    The good news is that we don't actually need the new value of customer_ref when we create the historical entry, we need the current entry, which should be present in the object's dict.  

Re: [sqlalchemy] Adding order_by, offset and limit support to Delete

2010-12-22 Thread Michael Bayer
The general idea is great though you probably want to use the @compiles decorator to link the compile function to the expression element, since that's the API point of extension - that would remove the need for the _compiler() call:

Re: [sqlalchemy] SQLAlchemy-Future

2010-12-22 Thread Michael Bayer
yeah we can go with sqlalchemy.contrib, just need guidance on the correct way to do it based on the somewhat conflicting links I posted. On Dec 21, 2010, at 3:04 PM, Hong Minhee wrote: Thanks for your fine answer. Is there any plan of defining sqlalchemy.contrib namespace package into

Re: [sqlalchemy] Questions about sessions connections

2010-12-22 Thread Michael Bayer
On Dec 21, 2010, at 5:03 AM, Franck Vonbau wrote: Dear all, I'm starting a web project based on Python, and I've decided to rely on web.py and SQLAlchemy. My DB is for the moment a SQLite database, and I'm trying to figure out how the framework deals with sessions / transactions. Your

Re: [sqlalchemy] Re: something wrong with relationship caching at _trunk_

2010-12-22 Thread Michael Bayer
Thank you, please apply the change in r9327b3748997 to your _params_from_query() function. On Dec 22, 2010, at 5:47 AM, sector119 wrote: from beaker import cache from sqlalchemy import * from sqlalchemy.orm import mapper, sessionmaker, scoped_session, relationship from sqlalchemy.types

Re: [sqlalchemy] SQLAlchemy-Future

2010-12-22 Thread Hong Minhee
In the case of Flask and Sphinx, they use the namespace package called flaskext and sphinxcontrib. - http://flask.pocoo.org/docs/extensiondev/ - https://bitbucket.org/birkenfeld/sphinx-contrib See the case of repoze.bfg also. It made repoze and repoze.bfg both namespace packages: -

[sqlalchemy] Re: something wrong with relationship caching at _trunk_

2010-12-22 Thread sector119
Thank you, Michael! On 22 Грд, 18:38, Michael Bayer mike...@zzzcomputing.com wrote: Thank you, please apply the change in r9327b3748997 to your _params_from_query() function. On Dec 22, 2010, at 5:47 AM, sector119 wrote: from beaker import cache from sqlalchemy import * from

RE: [sqlalchemy] Questions about sessions connections

2010-12-22 Thread Franck _
Thank you very much Michael ! It makes perfectly sense. From: mike...@zzzcomputing.com Subject: Re: [sqlalchemy] Questions about sessions connections Date: Wed, 22 Dec 2010 11:07:22 -0500 To: sqlalchemy@googlegroups.com On Dec 21, 2010, at 5:03 AM, Franck Vonbau wrote:Dear all, I'm