1 files changed, 9 insertions, 1 deletions

diff --git a/src/mailman_pgp/model/address.py b/src/mailman_pgp/model/address.py
index 1d07486..6fc3050 100644
--- a/src/mailman_pgp/model/address.py
+++ b/src/mailman_pgp/model/address.py
@@ -22,7 +22,7 @@ from os.path import exists, isfile, join
 from mailman.database.types import SAUnicode
 from mailman.interfaces.usermanager import IUserManager
 from pgpy import PGPKey
-from sqlalchemy import Column, Integer
+from sqlalchemy import Column, Integer, Boolean
 from sqlalchemy.orm import reconstructor
 from zope.component import getUtility
 
@@ -38,6 +38,7 @@ class PGPAddress(Base):
     id = Column(Integer, primary_key=True)
     email = Column(SAUnicode, index=True)
     key_fingerprint = Column(SAUnicode)
+    key_confirmed = Column(Boolean)
 
     def __init__(self, address):
         super().__init__()
@@ -49,6 +50,7 @@ class PGPAddress(Base):
     def _init(self):
         self._address = None
         self._key = None
+        self.key_confirmed = False
 
     @property
     def key(self):
@@ -119,3 +121,9 @@ class PGPAddress(Base):
         if address is None:
             return None
         return PGPAddress.query().filter_by(email=address.email).first()
+
+    @staticmethod
+    def for_email(email):
+        if email is None:
+            return None
+        return PGPAddress.query().filter_by(email=email).first()