[CentOS] mysql-python

Fri Mar 26 01:22:20 UTC 2010
Ray Van Dolson <rayvd at bludgeon.org>

On Fri, Mar 26, 2010 at 09:03:11AM +0800, Christopher Chan wrote:
> On Friday, March 26, 2010 08:52 AM, Ray Van Dolson wrote:
> > 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()
> 
>  >>> con=MySQLdb.connection(...)
>  >>> con.ping()
>  >>> curs = con.cursor()
> Traceback (most recent call last):
>    File "<stdin>", line 1, in ?
> AttributeError: cursor
> 
> 
> >
> > cursor.execute("SELECT....")
> > results = cursor.fetchall()
> 
> However:
> 
>  >>> con.query("SELECT SF.MOBILE FROM SF")
>  >>> res=con.store_result()
>  >>> res.fetch_row()
> 
> Will work.
> 
> Unless you want to tell me that things are slightly different when 
> running the script and doing things interactively...

Strange.  I've always done it exactly the way I shared in my code
snippet.  Have many scripts coded that way...

Where'd you get your MySQLdb module from?

Ray