[Tutor] dbcp module

[Kent Johnson]

The recipe you cite has the pp() function and an example of its use. It sounds like that is what you 
want.

Kent

Rene Bourgoin wrote:
> Ive been learning to interact with databases using python and i was looking for ways to return a SELECT  query result in a plain format. what i mean by plain format is :
> 
> 
> 
> name         number        address
> 
> Fred Smith   2125553243     1 main st 
> 
> 
> 
> All the pratices ive done return the results in tuples or tuples within tuples.
> 
> (('fred smith','2125553243','1 main st'))
> 
> 
> 
> I saw some examples on activestate that use the dbcp module and import the pp ( pretty print ) function and the results from the examples were in the format i was looking for. just straight strings in a tabular format. no tuples.
> 
> 
> 
> 
> 
> http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/81189
> 
> 
> 
>  --- On Fri 12/17, Danny Yoo < dyoo at hkn.eecs.berkeley.edu > wrote:
> 
> From: Danny Yoo [mailto: dyoo at hkn.eecs.berkeley.edu]
> 
> To: r2b2 at myway.com
> 
>      Cc: kent37 at tds.net, tutor at python.org
> 
> Date: Fri, 17 Dec 2004 16:13:57 -0800 (PST)
> 
> Subject: Re: [Tutor] dbcp module
> 
> 
> 
> <br><br>On Fri, 17 Dec 2004, Rene Bourgoin wrote:<br><br>> Yes i believe im looking for the python version of the Jakarta databse<br>> connection pool!!<br><br>Hi Rene,<br><br><br>I haven't looked at this too closely yet, but there are projects out there<br>for connection pools.  For example:<br><br>    http://sqlrelay.sourceforge.net/<br><br><br>Some prominent Python projects, though, appear to use their own homebrewed<br>connection pools.  Zope appears to do this:<br><br>    http://zdp.zope.org/projects/zfaq/faq/DatabaseIntegration/954522163<br><br>SQLObject maintains its own database pool:<br><br>    http://wiki.sqlobject.org/connections<br><br>but also refers to 'DBPool.py':<br><br>    http://jonpy.sourceforge.net/dbpool.html<br><br>I'm not sure if one database pooling solution has emerged as a dominant<br>one yet, though.<br><br><br>Good luck to you!<br><br>
> 
> _______________________________________________
> No banners. No pop-ups. No kidding.
> Make My Way your home on the Web - http://www.myway.com
>