[CentOS] mysql-python

Christopher Chan christopher.chan at bradbury.edu.hk
Fri Mar 26 02:03:11 UTC 2010


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...


More information about the CentOS mailing list