MySQL — MySQL service

Module providing a mysql type service

Class Reference

class pyircbot.modules.MySQL.Connection(master)

Bases: object

ensureConnected()

escape(s)

Escape a string using the mysql server

Parameters:s (str) – the string to escape Returns:str – the escaped string

getCursor()

ondisable()

query(queryText, args=())

Execute a MySQL query and return the cursor

Parameters:

• queryText (str) – the mysql query as a string, using ‘%s’ for token replacement
• args (tuple) – arguments to be escaped into the query

Returns:

cursor – the sql cursor

tableExists(tablename)

class pyircbot.modules.MySQL.MySQL(bot, moduleName)

Bases: pyircbot.modulebase.ModuleBase

getConnection()