From d537d4b69b4547814f2d01bc18ce2c472b978647 Mon Sep 17 00:00:00 2001 From: Matthias Schiffer Date: Sun, 2 May 2010 21:18:09 +0200 Subject: Added log module --- modules/help.py | 2 +- modules/log.py | 10 ++++++++++ modules/mysql.py | 10 ++++++++++ 3 files changed, 21 insertions(+), 1 deletion(-) create mode 100644 modules/log.py create mode 100644 modules/mysql.py (limited to 'modules') diff --git a/modules/help.py b/modules/help.py index d239f84..71d1a56 100644 --- a/modules/help.py +++ b/modules/help.py @@ -12,7 +12,7 @@ class Module(ModuleBase): if not re.match(r'!help(?:\W|\Z)', message_body): return - commands = reduce(lambda l, mod: l + mod.commands(), self.manager.modules, []) + commands = reduce(lambda l, mod: l + mod.commands(), self.manager.modules.itervalues(), []) helpstring = reduce(lambda s, (c, h): s + c + ': ' + h + '\n', commands, '') reply('Befehle:\n\n' + helpstring) diff --git a/modules/log.py b/modules/log.py new file mode 100644 index 0000000..3280d27 --- /dev/null +++ b/modules/log.py @@ -0,0 +1,10 @@ +from base import ModuleBase + +class Module(ModuleBase): + def __init__(self, manager): + ModuleBase.__init__(self, manager) + self.db = manager.get('mysql').db + + def groupchat(self, room, message_from, message_body, reply): + cursor = self.db.cursor() + cursor.execute('INSERT INTO log (time, room, nick, text) VALUES (NOW(), %s, %s, %s)', (room, message_from, message_body)) diff --git a/modules/mysql.py b/modules/mysql.py new file mode 100644 index 0000000..3b6c3b1 --- /dev/null +++ b/modules/mysql.py @@ -0,0 +1,10 @@ +from base import ModuleBase +import MySQLdb + +class Module(ModuleBase): + def __init__(self, manager): + ModuleBase.__init__(self, manager) + + conf = manager.config['mysql'] + + self.db = MySQLdb.connect(host = conf['host'], user = conf['user'], passwd = conf['passwd'], db = conf['db']) -- cgit v1.2.3