#NEWLINE# def clear_personal_information( self , cursor ) : #NEWLINE# #INDENT# 'Clear personal information such as statements.\n        ' #NEWLINE# r = cursor . one ( '\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\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 ) ) #NEWLINE# self . set_attributes ( ** r . _asdict ( ) )