1 files changed, 86 insertions, 0 deletions
diff --git a/mailman/database/address.py b/mailman/database/address.py
new file mode 100644
index 000000000..af3535a65
--- /dev/null
+++ b/mailman/database/address.py
@@ -0,0 +1,86 @@
+# Copyright (C) 2006-2008 by the Free Software Foundation, Inc.
+#
+# This program is free software; you can redistribute it and/or
+# modify it under the terms of the GNU General Public License
+# as published by the Free Software Foundation; either version 2
+# of the License, or (at your option) any later version.
+#
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+# GNU General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with this program; if not, write to the Free Software
+# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301,
+# USA.
+
+from email.utils import formataddr
+from storm.locals import *
+from zope.interface import implements
+
+from mailman import Errors
+from mailman.configuration import config
+from mailman.database.member import Member
+from mailman.database.model import Model
+from mailman.database.preferences import Preferences
+from mailman.interfaces import IAddress
+
+
+
+class Address(Model):
+    implements(IAddress)
+
+    id = Int(primary=True)
+    address = Unicode()
+    _original = Unicode()
+    real_name = Unicode()
+    verified_on = DateTime()
+    registered_on = DateTime()
+
+    user_id = Int()
+    user = Reference(user_id, 'User.id')
+    preferences_id = Int()
+    preferences = Reference(preferences_id, 'Preferences.id')
+
+    def __init__(self, address, real_name):
+        super(Address, self).__init__()
+        lower_case = address.lower()
+        self.address = lower_case
+        self.real_name = real_name
+        self._original = (None if lower_case == address else address)
+
+    def __str__(self):
+        addr = (self.address if self._original is None else self._original)
+        return formataddr((self.real_name, addr))
+
+    def __repr__(self):
+        verified = ('verified' if self.verified_on else 'not verified')
+        address_str = str(self)
+        if self._original is None:
+            return '<Address: %s [%s] at %#x>' % (
+                address_str, verified, id(self))
+        else:
+            return '<Address: %s [%s] key: %s at %#x>' % (
+                address_str, verified, self.address, id(self))
+
+    def subscribe(self, mailing_list, role):
+        # This member has no preferences by default.
+        member = config.db.store.find(
+            Member,
+            Member.role == role,
+            Member.mailing_list == mailing_list.fqdn_listname,
+            Member.address == self).one()
+        if member:
+            raise Errors.AlreadySubscribedError(
+                mailing_list.fqdn_listname, self.address, role)
+        member = Member(role=role,
+                        mailing_list=mailing_list.fqdn_listname,
+                        address=self)
+        member.preferences = Preferences()
+        config.db.store.add(member)
+        return member
+
+    @property
+    def original_address(self):
+        return (self.address if self._original is None else self._original)