from . import ModuleBase

class Module(ModuleBase):
    def __init__(self, manager):
        ModuleBase.__init__(self, manager)
        self.pgsql = manager.get('pgsql')
    
    def helptexts(self):
        return ['Chatlogs werden auch erstellt.']
    
    def groupchat(self, room, nick, text, handler):
        cursor = self.pgsql.cursor()
        cursor.execute('INSERT INTO log ("type", "time", "room", "nick", "text") VALUES (\'message\', now(), %s, %s, %s)', (room, nick, text))
        cursor.close()
        self.pgsql.commit()

    def join(self, room, nick, show, status, handler):
        cursor = self.pgsql.cursor()
        cursor.execute('INSERT INTO log ("type", "time", "room", "nick", "show", "text") VALUES (\'join\', now(), %s, %s, %s, %s)', (room, nick, show, status))
        cursor.close()
        self.pgsql.commit()

    def leave(self, room, nick, show, status, handler):
        cursor = self.pgsql.cursor()
        cursor.execute('INSERT INTO log ("type", "time", "room", "nick", "show", "text") VALUES (\'leave\', now(), %s, %s, %s, %s)', (room, nick, show, status))
        cursor.close()
        self.pgsql.commit()
    
    def topic(self, room, nick, text, handler):
        cursor = self.pgsql.cursor()
        cursor.execute('INSERT INTO log ("type", "time", "room", "nick", "text") VALUES (\'topic\', now(), %s, %s, %s)', (room, nick, text))
        cursor.close()
        self.pgsql.commit()