'Clear personal information such as statements.'

def clear_personal_information(self, cursor):

    r = cursor.one(u'\n\n                                                INSERT    INTO    community_members    (slug,    participant,    ctime,    name,    is_member)    (\n                                                                SELECT    slug,    participant,    ctime,    name,    false\n                                                                        FROM    community_members\n                                                                    WHERE    participant=%(participant_id)s\n                                                                            AND    is_member    IS    true\n                                                );\n\n                                                DELETE    FROM    emails    WHERE    participant_id    =    %(participant_id)s;\n                                                DELETE    FROM    statements    WHERE    participant=%(participant_id)s;\n                                                DELETE    FROM    participant_identities    WHERE    participant_id=%(participant_id)s;\n\n                                                UPDATE    participants\n                                                            SET    anonymous_giving=False\n                                                                    ,    avatar_url=NULL\n                                                                    ,    email_address=NULL\n                                                                    ,    claimed_time=NULL\n                                                                    ,    session_token=NULL\n                                                                    ,    session_expires=now()\n                                                                    ,    giving=0\n                                                                    ,    taking=0\n                                                    WHERE    username=%(username)s\n                                    RETURNING    *;\n\n                                ', dict(username=self.username, participant_id=self.id))
    self.set_attributes(**r._asdict())
