dosen't work with mysqldb1.22 and python 2.5

Bug #303343 reported by yufang on 2008-11-29
4
Affects Status Importance Assigned to Milestone
PySQLPool
Fix Released
Critical
Nick Verbeck

Bug Description

I got PySQLPool_V0.3B1.tar.gz and fount it dosen't work with mysqldb1.22 which doesn't support username and password keyword params any more.So I change getNewConnection with:
def getNewConnection(commitOnEnd = False, **kargs):
    return PySQLConnection.PySQLConnection(commitOnEnd = commitOnEnd, **kargs)
PySQLConnection.py line 31:
        if not self.info.has_key('passwd'):
            self.info['passwd'] = ''

And in python2.5, PySQLConnection.py line 52: 'hashStr += self.info[key]' need to replace with 'hashStr += str(self.info[key])' to get it worked.
Also I have a question, PySQLPool.py line 116: 'self.__Pool['conn'][key][i].count = 0'. It seems all ok with or without this line?

my script:

import PySQLPool

for i in range(1,10):
 connection = PySQLPool.getNewConnection(host = 'localhost', user='root', passwd='', client_flag=2)
 query = PySQLPool.getNewQuery(connection = connection)
 print query.Query("SQL")
 for row in query.record:
    print row

yufang (yf-hello) on 2008-11-29
description: updated
yufang (yf-hello) on 2008-11-29
description: updated
Nick Verbeck (nerdynick) wrote :

This has been fixed and is released with 0.3

Changed in pysqlpool:
assignee: nobody → nerdynick
importance: Undecided → Critical
milestone: none → 0.3
status: New → Fix Released
Nick Verbeck (nerdynick) wrote :

Sorry for the late response

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers