# -*- coding: utf-8 -*-

from module.database import style
from module.plugins.internal.Addon import Addon


class DeleteFinished(Addon):
    __name__    = "DeleteFinished"
    __type__    = "hook"
    __version__ = "1.17"
    __status__  = "testing"

    __config__ = [("activated" , "bool", "Activated"                        , False),
                  ("interval"  , "int" , "Check interval in hours"          , 72   ),
                  ("deloffline", "bool", "Delete package with offline links", False)]

    __description__ = """Automatically delete all finished packages from queue"""
    __license__     = "GPLv3"
    __authors__     = [("Walter Purcaro", "vuolter@gmail.com")]


    PERIODICAL_INTERVAL = 1 * 60 * 60  #: 1 hour


    def periodical(self):
        if not self.info['sleep']:
            deloffline = self.get_config('deloffline')
            mode = "0,1,4" if deloffline else "0,4"
            msg = _('delete all finished packages in queue list (%s packages with offline links)')
            self.log_info(msg % (_('including') if deloffline else _('excluding')))
            self.delete_finished(mode)
            self.info['sleep'] = True
            self.add_event('package_finished', self.wakeup)


    def deactivate(self):
        self.manager.removeEvent('package_finished', self.wakeup)


    def activate(self):
        self.info['sleep'] = True
        self.set_interval(self.get_config('interval') * 60 * 60)
        self.add_event('package_finished', self.wakeup)


    ## own methods ##
    @style.queue
    def delete_finished(self, mode):
        self.c.execute('DELETE FROM packages WHERE NOT EXISTS(SELECT 1 FROM links WHERE package=packages.id AND status NOT IN (%s))' % mode)
        self.c.execute('DELETE FROM links WHERE NOT EXISTS(SELECT 1 FROM packages WHERE id=links.package)')


    def wakeup(self, pypack):
        self.manager.removeEvent('package_finished', self.wakeup)
        self.info['sleep'] = False


    ## event managing ##
    def add_event(self, event, func):
        """
        Adds an event listener for event name
        """
        if event in self.manager.events:
            if func in self.manager.events[event]:
                self.log_debug("Function already registered", func)
            else:
                self.manager.events[event].append(func)
        else:
            self.manager.events[event] = [func]