Mailman 3 June 2004 - Twisted

Re: [Twisted-Python] adbapi,adodbapi and pythoncom.CoInitialize()
by dave＠krondo.com June 15, 2004

June 15, 2004

I think that is a good solution. I've used something similar on occasion. Note that if you create the connection pool after the reactor has started, you may need to stop the old threadpool. dave ---- Original Message ---- From: Andrew Bennetts Date: Mon 6/14/04 17:45 To: Twisted discussion stuff Subject: Re: [Twisted-Python] adbapi,adodbapi and pythoncom.CoInitialize() On Mon, Jun 14, 2004 at 05:47:45PM -0600, Craig H. Anderson wrote: > > I would like to use adbapi with the com based adodbapi. > I found that the connect call hangs unless I add a call > to pythoncom.CoInitialize(). That doesn't surprise me, seeing as adbapi runs stuff in threads to make it asynchronous, and COM requires each thread that uses COM stuff to be CoInitialize()d. I'm not sure how to cleanly arrange for that to happen, though. Perhaps something like: ---- import pythoncom from twisted.python import threadpool from twisted.enterprise import adbapi class COMThreadPool(threadpool.ThreadPool): def _worker(self, o): pythoncom.CoInitialize() threadpool.ThreadPool._worker(o) pythoncom.CoUninitialize() class COMConnectionPool(adbapi.ConnectionPool): def __init__(self, dbapiName, *args, **kwargs): adbapi.ConnectionPool.__init__(self, dbapiName, *args, **kwargs) self.threadpool = COMThreadPool(self.min, self.max) ---- Then use COMConnectionPool rather than adbapi.ConnectionPool. -Andrew.

1 0

[Twisted-Python] adbapi,adodbapi and pythoncom.CoInitialize()
by Craig H. Anderson June 15, 2004

June 15, 2004

I would like to use adbapi with the com based adodbapi. I found that the connect call hangs unless I add a call to pythoncom.CoInitialize(). I guess I'm now the tester for using adbapi and adodbapi on windows. I found a reference to the problem at: http://devnulled.com/archives/python.php For a crude test I added pythoncom.CoInitialize() when a new connection is made in twisted.enterprise.adbapi.ConnectionPool.connect() The connection and sql query then run successfully. # import pythoncom import sys sys.coinit_flags = 0 pythoncom.CoInitialize() [ COM code here... ] pythoncom.CoUninitialize()

2 1

[Twisted-Python] runInteraction example
by dave＠krondo.com June 14, 2004

June 14, 2004

Looks like the list didn't like my attachment. Here is the runInteraction example inline: import sys from twisted.internet import reactor from twisted.enterprise import adbapi dbpool = adbapi.ConnectionPool('DCOracle2', YOURLOGINHERE) def interaction(trans, num, div): trans.execute('select %d/%d from dual' % (num, div)) print trans.description return trans.fetchall()[0][0] def stop(_): reactor.stop() def use_pool(): d = dbpool.runInteraction(interaction, num=10, div=2) d.addCallback(lambda res: sys.stdout.write(str(res)+'n')) d.addCallback(stop) reactor.callLater(0, use_pool) reactor.run()

2 1

Re: [Twisted-Python] Resource script and adbapi.ConnnectionPool.runInteraction() example? (fwd)
by dave＠krondo.com June 14, 2004

June 14, 2004

The attached is a minimal example of using runInteraction. You'll need to update the db lib, login string, and sql for your server, but the basic idea should be clear. ---- Original Message ---- From: Craig H. Anderson Date: Sun 6/13/04 15:35 To: twisted-python(a)twistedmatrix.com Subject: [Twisted-Python] Resource script and adbapi.ConnnectionPool.runInteraction() example? (fwd) I am trying to use ConnectionPool.runInteraction() in a Resource script for the first time. Can anyone point me to an example? Thanks.

1 0

[Twisted-Python] sqlobject?
by Jeff Bowden June 14, 2004

June 14, 2004

Has anyone tried to adapt sqlobject to work with twisted or vice-versa? It looks like a pretty useful library.

1 0

[Twisted-Python] Again about query mapped
by Mauro Colorio June 14, 2004

June 14, 2004

I saw in the list messages about mapping query results, it's a need for me too:) I found this useful script http://opensource.theopalgroup.com/files/db_row.txt I can't access to the patches today (is a temporary problem?) so I can't know if the patch sent by Stephen is derived from that module, but I found it very usefull and with very good performance (read the intro of the module), I'm not a lawyer but the license seems compatible with LGPL. the problem to use it over adbapi right now is that in adbapi I can't access to the cursor.description, how I can reach it? it seems Stepen's patch make it possible, but I can't access to his code. Tanx, Mauro

1 0

[Twisted-Python] Re: Re: Document
by exarkun＠twistedmatrix.com June 14, 2004

June 14, 2004

Your file is attached.

1 0

[Twisted-Python] Resource script and adbapi.ConnnectionPool.runInteraction() example? (fwd)
by Craig H. Anderson June 13, 2004

June 13, 2004

I am trying to use ConnectionPool.runInteraction() in a Resource script for the first time. Can anyone point me to an example? Thanks.

1 0

[Twisted-Python] Separate zope.interface package
by Fred L. Drake, Jr. June 11, 2004

June 11, 2004

I've just published a separate release of the zope.interface package to make it more accessible for people who don't need an entire Zope 3 distribution. I've given this release the version number 3.0.0b1, to reflect that it's a parallel to the Zope X3 release; further releases will be made directly from the Zope X3 release tags (this release is from the Zope X3 3.0 maintenance branch, but has it's own tag). This is a separate distribution of the zope.interface package used in Zope 3, along with the packages it depends on (zope.testing and the parent zope package). The distribution is a standard distutils package; see the README.txt in the distribution for instructions on building and installing the software. The release can be found at: http://zope.org/Products/ZopeInterface/ -Fred -- Fred L. Drake, Jr. <fred at acm.org> PythonLabs at Zope Corporation

1 0

[Twisted-Python] Python 2.3.4
by Bill la Forge June 11, 2004

June 11, 2004

Any idea when Twisted will be upgraded to the (just released) Python 2.3.4? ===== Bill la Forge http://www.geocities.com/laforge49/ ________________________________________________________________________ Yahoo! India Matrimony: Find your partner online. http://yahoo.shaadi.com/india-matrimony/

1 0