dosen't work with mysqldb1.22 and python 2.5

Bug #303343 reported by yufang
4
Affects Status Importance Assigned to Milestone
PySQLPool
Fix Released
Critical
Nikoleta 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

Tags: v0.3b1
yufang (yf-hello)
description: updated
yufang (yf-hello)
description: updated
Revision history for this message
Nikoleta 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
Revision history for this message
Nikoleta Verbeck (nerdynick) wrote :

Sorry for the late response

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

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.