[CentOS] mysql-python

Fri Mar 26 01:53:41 UTC 2010
Christopher Chan <christopher.chan at bradbury.edu.hk>

On Friday, March 26, 2010 09:39 AM, Ray Van Dolson wrote:
> On Fri, Mar 26, 2010 at 09:32:35AM +0800, Christopher Chan wrote:
>>
>>> Where'd you get your MySQLdb module from?
>>
>> yum install MySQL-python
>
> Well, don't know what to tell you:
>
> $ rpm -qi MySQL-python
> Name        : MySQL-python                 Relocations: (not relocatable)
> Version     : 1.2.1                             Vendor: CentOS
> Release     : 1                             Build Date: Fri 05 Jan 2007 08:40:16 PM PST
> Install Date: Thu 25 Mar 2010 06:35:52 PM PDT      Build Host: builder1.centos.org
> Group       : Development/Libraries         Source RPM: MySQL-python-1.2.1-1.src.rpm
> Size        : 283388                           License: GPL
> Signature   : DSA/SHA1, Tue 03 Apr 2007 05:25:09 PM PDT, Key ID a8a447dce8562897

Hmm, some slight differences...

Name        : MySQL-python                 Relocations: (not relocatable)
Version     : 1.2.1                             Vendor: CentOS
Release     : 1                             Build Date: Sat 06 Jan 2007 
12:38:14 PM HKT
Install Date: Tue 16 Mar 2010 12:24:16 PM HKT      Build Host: 
builder3.centos.org
Group       : Development/Libraries         Source RPM: 
MySQL-python-1.2.1-1.src.rpm
Size        : 294516                           License: GPL
Signature   : DSA/SHA1, Wed 04 Apr 2007 08:25:45 AM HKT, Key ID 
a8a447dce8562897


> URL         : http://sourceforge.net/projects/mysql-python/
> Summary     : An interface to MySQL
> Description :
> Python interface to MySQL
>
> MySQLdb is an interface to the popular MySQL database server for Python.
> The design goals are:
>
> -     Compliance with Python database API version 2.0
> -     Thread-safety
> -     Thread-friendliness (threads will not block each other)
> -     Compatibility with MySQL 3.23 and up
>
> $ python
> Python 2.4.3 (#1, Sep  3 2009, 15:37:12)
> [GCC 4.1.2 20080704 (Red Hat 4.1.2-46)] on linux2
> Type "help", "copyright", "credits" or "license" for more information.
>>>> import MySQLdb
>>>> conn = MySQLdb.connect(user='rayvd', passwd='XXXXXX', db='bludgeon')
>>>> cursor=conn.cursor()
>>>> cursor.execute("SELECT * FROM quotes LIMIT 1")
> 1L
>>>> results = cursor.fetchone()
>

Oh brother, it looks like initialize() don't exist too...

 >>> con=MySQLdb.connection(passwd="XXXXXXXX",user="esf",db="maze_bs")
 >>> curs=con.cursor()
Traceback (most recent call last):
   File "<stdin>", line 1, in ?
AttributeError: cursor
 >>> curs=con.initialize()
Traceback (most recent call last):
   File "<stdin>", line 1, in ?
AttributeError: initialize