FAQs

In an attempt to help answer some questions preemptively. A FAQ page has been create along side the with the docs. Lets hope this helps.

How do I enable debugging?

Currently debugging is very limited, but we do contain a simple debugging capability. You can enable debugging by assigning PySQLQuery.logging_path to a string value of a file to write the debugging output to. This will cause every query executed and any errors to be written to the supplied file.

Example:

import PySQLPool

PySQLPool.PySQLQuery.logging_path = '/path/to/file.txt'

What type of exception are raised?

At this time PySQLPool does not wrap the exceptions that come out of MySQLdb. So any and all errors thrown from any of your queries and/or other actions by MySQLdb will be of its types. Of which the base is MySQLdb.Error. To find out what error you have caused. MySQLdb.Error contains a two-element tuple called args. The 1st value will contain the MySQL error number, and the second will contain the error message.

Example:

try:
    connection = PySQLPool.getNewConnection(username='root', password='123456', host='localhost', db='mydb')
    query = PySQLPool.getNewQuery(connection)
    query.Query('select * from table')
except MySQLdb.Error, e:
    print "Error %d: %s" % (e.args[0], e.args[1])
    sys.exit (1)