#!/usr/bin/env python

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

# Copyright 2008 VEB IT

# See COPYING for distribution information.

# $Id$

from constants.VERSION import VERSION

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

__version__ = VERSION

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

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

import constants.ERROR as ERR

import VirtualMailManager as VMM

    """Class to manage e-mail alias domains."""

    def __init__(self, dbh, domainname, targetDomain=None):

        self._dbh = dbh

        self.__name = VMM.VirtualMailManager.chkDomainname(domainname)

        self.__gid = 0

        self._domain = targetDomain

        self._exists()

    def _exists(self):

        dbc = self._dbh.cursor()

        dbc.execute('SELECT gid, is_primary FROM domain_name WHERE domainname\

 = %s', self.__name)

        alias = dbc.fetchone()

        dbc.close()

        if alias is not None:

            self.__gid, primary = alias

            if primary:

                        self.__name, ERR.DOMAIN_ALIAS_ISDOMAIN)

    def save(self):

        if self.__gid > 0:

                ERR.DOMAIN_ALIAS_EXISTS)

        if self._domain is None:

                    ERR.DOMAIN_ALIAS_NO_DOMDEST)

        if self._domain._id < 1:

                    self._domain._name, ERR.NO_SUCH_DOMAIN)

        dbc = self._dbh.cursor()

        dbc.execute('INSERT INTO domain_name (domainname, gid, is_primary)\

 VALUES (%s, %s, FALSE)', self.__name, self._domain._id)

        self._dbh.commit()

        dbc.close()

    def info(self):

        if self.__gid > 0:

            dbc = self._dbh.cursor()

            dbc.execute('SELECT domainname FROM domain_name WHERE gid = %s\

 AND is_primary', self.__gid)

            domain = dbc.fetchone()

            dbc.close()

            if domain is not None:

            else:# an almost unlikely case, isn't it?

                            % self.__name, ERR.NO_SUCH_DOMAIN)

        else:

                  ERR.NO_SUCH_DOMAIN_ALIAS)

    def delete(self):

        if self.__gid > 0:

            dbc = self._dbh.cursor()

            dbc.execute('DELETE FROM domain_name WHERE domainname = %s \

 AND NOT is_primary', self.__name)

            if dbc.rowcount > 0:

                self._dbh.commit()

        else:

                  ERR.NO_SUCH_DOMAIN_ALIAS)