"""

    VirtualMailManager.Account

    Virtual Mail Manager's Account class to manage e-mail accounts.

"""

from VirtualMailManager.Transport import Transport

from VirtualMailManager.constants.ERROR import \

     ACCOUNT_EXISTS, ACCOUNT_MISSING_PASSWORD, ALIAS_EXISTS, ALIAS_PRESENT, \

     INVALID_AGUMENT, NO_SUCH_ACCOUNT, NO_SUCH_DOMAIN, RELOCATED_EXISTS, \

     UNKNOWN_MAILLOCATION_NAME, UNKNOWN_SERVICE

from VirtualMailManager.errors import AccountError as AErr

from VirtualMailManager.pycompat import all

    __slots__ = ('_addr', '_domain', '_mid', '_new', '_passwd', '_tid', '_uid',

    def __init__(self, dbh, address):

        """Creates a new Account instance.

        When an account with the given *address* could be found in the

        database all relevant data will be loaded.

        Arguments:

        `dbh` : pyPgSQL.PgSQL.Connection

          A database connection for the database access.

        `address` : basestring

          The e-mail address of the (new) Account.

        """

        if not isinstance(address, EmailAddress):

            raise TypeError("Argument 'address' is not an EmailAddress")

        self._addr = address

        self._domain = Domain(self._dbh, self._addr.domainname)

        if not self._domain.gid:

            raise AErr(_(u"The domain '%s' doesn't exist.") %

                       self._addr.domainname, NO_SUCH_DOMAIN)

        self._passwd = None

        self._new = True

        self._load()

    def _load(self):

        """Load 'uid', 'mid' and 'tid' from the database and set _new to

        `False` - if the user could be found. """

                    self._domain.gid, self._addr.localpart)

        if result:

            self._new = False

    def _set_uid(self):

        """Set the unique ID for the new Account."""

        assert self._uid == 0

        """Check and set different attributes - before we store the

        information in the database."""

        if not known_format(maillocation):

            raise AErr(_(u'Unknown mail_location mailbox format: %r') %

                       maillocation, UNKNOWN_MAILLOCATION_NAME)

        if not self._tid:

            self._tid = self._domain.tid

        self._set_uid()

    def _switch_state(self, state, dcvers, service):

        """Switch the state of the Account's services on or off. See

        Account.enable()/Account.disable() for more information."""

        self._chk_state()

        if service not in (None, 'all', 'imap', 'pop3', 'sieve', 'smtp'):

            raise AErr(_(u"Unknown service: '%s'.") % service, UNKNOWN_SERVICE)

                                                               self._uid)

                                                               state,

                                                               self._uid)

 %(col)s = %(s)s WHERE uid = %(uid)d' % \

                {'s': state, 'col': sieve_col, 'uid': self._uid}

    def _count_aliases(self):

        """Count all alias addresses where the destination address is the

        address of the Account."""

        sql = "SELECT COUNT(destination) FROM alias WHERE destination = '%s'"\

                % self._addr

        dbc.execute(sql)

    def _chk_state(self):

        """Raise an AccountError if the Account is new - not yet saved in the

        database."""

        if self._new:

            raise AErr(_(u"The account '%s' doesn't exist.") % self._addr,

                       NO_SUCH_ACCOUNT)

    @property

    def domain_directory(self):

        """The directory of the domain the Account belongs to."""

        return self._domain.directory

    @property

    def gid(self):

        """The Account's group ID."""

        return self._domain.gid

    @property

    def home(self):

        """The Account's home directory."""

        return '%s/%s' % (self._domain.directory, self._uid)

    @property

    def uid(self):

        """The Account's unique ID."""

    def set_password(self, password):

        """Set a password for the new Account.

        If you want to update the password of an existing Account use

        Account.modify().

        Argument:

        `password` : basestring

          The hashed password for the new Account."""

        self._passwd = password

    def set_transport(self, transport):

        """Set the transport for the new Account.

        If you want to update the transport of an existing Account use

        Account.modify().

        Argument:

        `transport` : basestring

          The string representation of the transport, e.g.: 'dovecot:'

        """

        self._tid = Transport(self._dbh, transport=transport).tid

        """Enable a/all service/s for the Account.

        Possible values for the *service* are: 'imap', 'pop3', 'sieve' and

        'smtp'. When all services should be enabled, use 'all' or the

        default value `None`.

        Arguments:

        `dcvers` : int

          The concatenated major and minor version number from

          `dovecot --version`.

        `service` : basestring

          The name of a service ('imap', 'pop3', 'smtp', 'sieve'), 'all'

          or `None`.

        """

        self._switch_state(True, dcvers, service)

        """Disable a/all service/s for the Account.

        For more information see: Account.enable()."""

        self._switch_state(False, dcvers, service)

        """Save the new Account in the database.

        Arguments:

        `maillocation` : basestring

          The mailbox format of the mail_location: 'maildir', 'mbox',

          'dbox' or 'mdbox'.

        `dcvers` : int

          The concatenated major and minor version number from

          `dovecot --version`.

        `smtp, pop3, imap, sieve` : bool

          Indicates if the user of the Account should be able to use this

          services.

        """

        if not self._new:

            raise AErr(_(u"The account '%s' already exists.") % self._addr,

                       ACCOUNT_EXISTS)

        if not self._passwd:

            raise AErr(_(u"No password set for '%s'.") % self._addr,

                       ACCOUNT_MISSING_PASSWORD)

        assert all(isinstance(service, bool) for service in (smtp, pop3, imap,

                                                             sieve))

        if dcvers > 11:

            sieve_col = 'sieve'

            sieve_col = 'managesieve'

        self._prepare(maillocation)

        sql = "INSERT INTO users (local_part, passwd, uid, gid, mid, tid,\

 smtp, pop3, imap, %s) VALUES ('%s', '%s', %d, %d, %d, %d, %s, %s, %s, %s)" % (

            sieve_col, self._addr.localpart, self._passwd, self._uid,

            self._domain.gid, self._mid, self._tid, smtp, pop3, imap, sieve)

        dbc = self._dbh.cursor()

        dbc.execute(sql)

        self._dbh.commit()

        dbc.close()

        self._new = False

    def modify(self, field, value):

        """Update the Account's *field* to the new *value*.

        Possible values for *filed* are: 'name', 'password' and

        'transport'.  *value* is the *field*'s new value.

        Arguments:

        `field` : basestring

          The attribute name: 'name', 'password' or 'transport'

        `value` : basestring

          The new value of the attribute. The password is expected as a

          hashed password string.

        """

        if field not in ('name', 'password', 'transport'):

            raise AErr(_(u"Unknown field: '%s'") % field, INVALID_AGUMENT)

        self._chk_state()

        if field == 'password':

                        value, self._uid)

        elif field == 'transport':

                        self._tid, self._uid)

                        value, self._uid)

    def get_info(self, dcvers):

        """Returns a dict with some information about the Account.

        The keys of the dict are: 'address', 'gid', 'home', 'imap'

        'mail_location', 'name', 'pop3', 'sieve', 'smtp', transport' and

        'uid'.

        Argument:

        `dcvers` : int

          The concatenated major and minor version number from

          `dovecot --version`.

        """

        self._chk_state()

        if info:

            keys = ('name', 'uid', 'gid', 'mid', 'transport', 'smtp',

                    'pop3', 'imap', sieve_col)

                if info[service]:

                    # TP: A service (pop3/imap) is enabled/usable for a user

            info['home'] = '%s/%s' % (self._domain.directory, info['uid'])

            del info['mid']

        # nearly impossible‽

        raise AErr(_(u"Couldn't fetch information for account: '%s'") \

                   % self._addr, NO_SUCH_ACCOUNT)

    def get_aliases(self):

        """Return a list with all alias e-mail addresses, whose destination

        is the address of the Account."""

        self._chk_state()

        if addresses:

        """Delete the Account from the database.

        Argument:

        `delalias` : basestring

          if the values of delalias is 'delalias', all aliases, which

          points to the Account, will be also deleted."""

        self._chk_state()

                        str(self._addr))

            self._dbh.commit()

        else:  # check first for aliases

            a_count = self._count_aliases()

                self._dbh.commit()

                raise AErr(_(u"There are %(count)d aliases with the \

destination address '%(address)s'.") % \

                           {'count': a_count, 'address': self._addr},

                           ALIAS_PRESENT)

    """Search an Account by its UID.

    Argument:

    `uid` : long

      The Account unique ID.

    `dbh` : pyPgSQL.PgSQL.Connection

      a database connection for the database access.

    """

        raise AErr(_(u'UID must be an int/long.'), INVALID_AGUMENT)

        raise AErr(_(u'UID must be greater than 0.'), INVALID_AGUMENT)