'Return a record for a single email address on file for this participant.
:param unicode address: the email address for which to get a record
:param Cursor cursor: a database cursor; if ``None``, we\'ll use ``self.db``
:param and_lock: if True, we will acquire a write-lock on the email record before returning
:returns: a database record (a named tuple)'

def get_email(self, address, cursor=None, and_lock=False):

    sql = u'SELECT    *    FROM    emails    WHERE    participant_id=%s    AND    address=%s'
    if and_lock:
        sql += u'    FOR    UPDATE'
    return (cursor or self.db).one(sql, (self.id, address))
