> On Apr 16, 2007, at 6:53 PM, George Sakkis wrote:

>> On Apr 16, 12:18 pm, Alberto Valverde <albe...@toscat.net> wrote:
>>> On Apr 16, 2007, at 5:54 PM, George Sakkis wrote:

>>>> Is there any way I can force a COMMIT within an exposed method ?  
>>>> I am
>>>> using SqlAlchemy with PostgreSQL and I am creating a few records  
>>>> that
>>>> I need to use for subsequent SELECTs within the same method.  
>>>> Although
>>>> I do flush() them and get their assigned IDs, subsequent explicit
>>>> SELECTs (using SA's select(), not the data mappers) fail to see the
>>>> changes.
>>> How are you obtaining the engine when you use SA's select? You should
>>> use the same connection the transaction is using so you see its
>>> changes, check out [1]
>> I use:

>> from turbogears import database as db
>> engine=db.get_engine()

>> How can I access the implicit transaction created by TG or its
>> connection object ?

> You'll need access to the transaction instance. Unfortunately it's a  
> local variable inside database.sa_rwt. Perhaps it should be bound to  
> cherrypy.request so you could do:

> connection = engine.connect()
> cherrypy.request.sa_transaction.add(connection)

> then connection.execute(table.select()) # or whatever

> as described in the mentioned link. Can you try this patch see if it  
> works?

> Index: turbogears/database.py
> ===================================================================
> --- turbogears/database.py      (revision 2824)
> +++ turbogears/database.py      (working copy)
> @@ -336,7 +336,8 @@
> [run_with_transaction.when("_use_sa()")]
> def sa_rwt(func, *args, **kw):
>       log.debug("New SA transaction")
> -    transaction = session.create_transaction()
> +    req = cherrypy.request
> +    transaction = req.sa_transaction = session.create_transaction()
>       try:
>           retval = func(*args, **kw)
>           transaction.commit()

> Alberto