[Twisted-Python] Again about query mapped
Dave Peticolas
dave at krondo.com
Tue Jun 15 15:42:36 MDT 2004
I don't know enough about db_row to know whether that code is right,
but the adbapi code looks correct.
dave
---- Original Message ----
From: Mauro Colorio
Date: Tue 6/15/04 1:35
To: Twisted discussion stuff
Subject: Re: [Twisted-Python] Again about query mapped
Il mar, 2004-06-15 alle 01:14, Dave Peticolas ha scritto:
> You can use runInteraction to get at the cursor directly
> (see the example I just posted for another message). The
> cursor is wrapped by the transaction object passed as the
> first argument to the interaction callback.
this is what I produced, subclassing connectionpool,
I hope it's right (well it works :) but I'm new at twisted so I don't
know if it just works or it does it in the right way), the
db_row module is linked in my past mail, comments?:
----
from twisted.enterprise import adbapi
from db_row import *
class my_ConnectionPool(adbapi.ConnectionPool):
"Modified connectionPool"
def mappedInteraction(self, transaction, sql_string):
"Returns the result of a query in a more useful way"
transaction.execute(sql_string)
# Make a class to store the resulting rows
R = IMetaRow(transaction.description)
# Build the rows from the row class and each tuple returned from
the cursor
results = [ R(row) for row in transaction.fetchall() ]
return results
def runMappedQuery(self, sql_string):
"Runs the query"
return self.runInteraction(self.mappedInteraction,sql_string)
_______________________________________________
Twisted-Python mailing list
Twisted-Python at twistedmatrix.com
http://twistedmatrix.com/cgi-bin/mailman/listinfo/twisted-python
More information about the Twisted-Python
mailing list