# -*- coding: UTF-8 -*-

# Copyright 2007-2008 VEB IT

# See COPYING for distribution information.

# $Id$

"""Virtual Mail Manager's Alias class to manage e-mail aliases."""

from constants.VERSION import VERSION

__author__ = 'Pascal Volk <p.volk@veb-it.de>'

__version__ = VERSION

__revision__ = 'rev '+'$Rev$'.split()[1]

__date__ = '$Date$'.split()[1]

from Exceptions import VMMAliasException as VMMAE

from Domain import Domain

import constants.ERROR as ERR

import VirtualMailManager as VMM

class Alias:

    def __init__(self, dbh, address, destination=None):

        if address == destination:

            raise VMMAE(_(u"Address and destination are identical."),

                ERR.ALIAS_ADDR_DEST_IDENTICAL)

        self._dbh = dbh

        self._gid = 0

        self._isNew = False

        self._setAddr()

        if not self._dest is None:

            self._exists()

                    self._addr, ERR.ACCOUNT_EXISTS)

    def _exists(self):

        dbc = self._dbh.cursor()

        dbc.execute("SELECT gid FROM alias WHERE gid=%s AND address=%s\

        gid = dbc.fetchone()

        dbc.close()

        if gid is None:

            self._isNew = True

    def _setAddr(self):

        self._gid = dom.getID()

        if self._gid == 0:

    def save(self):

        if self._dest is None:

           raise VMMAE(_(u"No destination address for alias denoted."),

               ERR.ALIAS_MISSING_DEST)

        if self._isNew:

            dbc = self._dbh.cursor()

            dbc.execute("INSERT INTO alias (gid, address, destination) VALUES\

            self._dbh.commit()

            dbc.close()

        else:

    def getInfo(self):

        dbc = self._dbh.cursor()

        dbc.execute('SELECT destination FROM alias WHERE gid=%s AND address=%s',

        destinations = dbc.fetchall()

        dbc.close()

        if len(destinations) > 0:

            targets = []

            for destination in destinations:

                targets.append(destination[0])

            return targets

        else:

            raise VMMAE(_(u"The alias »%s« doesn't exists.") % self._addr,

                    ERR.NO_SUCH_ALIAS)

    def delete(self):

        dbc = self._dbh.cursor()

        if self._dest is None:

            dbc.execute("DELETE FROM alias WHERE gid=%s AND address=%s",

        else:

            dbc.execute("DELETE FROM alias WHERE gid=%s AND address=%s AND \

        rowcount = dbc.rowcount

        dbc.close()

        if rowcount > 0:

            self._dbh.commit()

        else: