[CentOS] mysql-python

Fri Mar 26 00:52:12 UTC 2010
Ray Van Dolson <rayvd at bludgeon.org>

On Fri, Mar 26, 2010 at 08:23:26AM +0800, Christopher Chan wrote:
> On Thursday, March 25, 2010 09:11 PM, JohnS wrote:
> >
> > On Thu, 2010-03-25 at 14:14 +0800, Christopher Chan wrote:
> >> Is it me or does the MySQLdb module in Centos not support python's DBAPI
> >> 2.0
> >
> > ---
> > Well you give no clue to the code your using.  Post what type your
> > using,
> >
> > It uses cursors so it it is compliant as far as I see.
> >
> > I get you installed it and it is dbapi 2.
> >
> > What does your python code look like?
> 
> The same as everything below except for the initialize() call.
> 
> 
> >
> > db = MySQLdb.connect (dsn='192.168.0.1:your_db',
> >                        user='root', password='password')
> > ##########################
> > def addEntry(names):
> >
> >      cursor.initialize()
> >      cursor = db.cursor ()
> > ###########################
> >
> > I think a good idea would be to drop it and go to postgres, and import
> > pgdb.
> 
> 
> I would love to were it not for the fact that one of the target clients 
> runs OpenSolaris and does not package a postgresql module for python. Grr...
> 
> Thanks, I will give this another shot before I give up on learning 
> python and go back to perl or php land.

db = MySQLdb.connect(....)
cursor = db.cursor()

cursor.execute("SELECT....")
results = cursor.fetchall()

Ray