how to use PySQLPool

Sorry for the delayed response but the basics are as follows.

import PySQLPool

connection = PySQLPool.getNewConnection(host = 'localhost', username='user', password='pass', schema='mysql')
query = PySQLPool.getNewQuery(connection = connection)
query.Query("YOUR SQL")
for row in query.record:
   row['COLUMN NAME']

You can reuse the connection Object all you wish or you can recreated it every time. It is used as a container for all your connection settings. Also once you have a query object created you can call query.Query() all you want and it will allocate the connection resource from the connection pool for you.

You also have access to the properties query.rowcount and query.affectedRows for the last executed query.

I'm also hoping to get a PyDoc/Wiki or something else up with more examples of how to use the whole thing. As well as how everything works.