Transforming a normal account into a team

[Changaco]

The need for this arose in #1098.

[Changaco]

This is what I used:

    def transform_into_team(self, first_member):
        old_kind = self.kind
        assert old_kind in ('individual', 'organization')
        assert self.balance == 0
        assert self.status == 'active'
        assert first_member.kind in ('individual', 'organization')
        assert first_member.status == 'active'
        mp_account = self.get_mangopay_account()
        with self.db.get_cursor() as cursor:
            r = cursor.one("""
                UPDATE participants
                   SET kind = 'group'
                     , mangopay_user_id = NULL
                 WHERE id = %s
                   AND kind = %s
             RETURNING kind, mangopay_user_id
            """, (self.id, self.kind))
            if not r:
                raise response.error(409, "race condition")
            self.set_attributes(**r._asdict())
            if mp_account:
                self.add_event(cursor, 'mangopay-account-change', {
                    'old_user_id': mp_account.Id,
                    'old_user_type': mp_account.PersonType,
                })
            self.add_event(cursor, 'account-kind-change', {
                'old_kind': old_kind,
                'new_kind': 'group',
            })
            self.add_member(first_member, cursor=cursor)
        # Drop sessions and passwords
        self.db.run("DELETE FROM user_secrets WHERE participant = %s", (self.id,))
        # Invalidate exchange routes
        routes = self.db.all("""
            SELECT r
              FROM exchange_routes r
             WHERE participant = %s
               AND error <> 'invalidated'
        """, (self.id,))
        for route in routes:
            route.invalidate()