kobotoolbox / kpi / 21144604344

81%

master: 76%

push

github

fix(organizations): remove duplicate organizations DEV-1491 (#6610)

### 📣 Summary
A user should only be a member of a single organization. This PR removes
any duplicate organizations associated with a user.


### 📖 Description
Certain accounts were inadvertently associated with multiple
organizations due to historical system behavior. This led to confusion
around ownership, permissions, and subscription management.

This PR introduces a long-running migration that ensures each user
remains part of exactly one organization going forward. When multiple
organizations are found for a user, the system keeps the most
appropriate one based on the following rules:

- Prefer multi-member organizations (MMO)
- If none are MMO, prefer the one with an active subscription
- Otherwise, keep the newest organization (based on creation date)
- Where safe, unused organizations are removed. 

In addition, this migration addresses two consistency issues that were
observed during cleanup:

1. Any projects that were still owned by the user (instead of the
organization) are now transferred to the owner of the kept organization,
aligning with the expected ownership model.

2. Organizations that are effectively multi-member but were not marked
as MMO will now have their `mmo_override` flag updated for consistency
to avoid future ambiguity in membership and billing flows.

After this migration completes, each user will belong to exactly one
organization, shared organizations remain intact, and project ownership
and MMO status are consistent with current system behavior.

7192 of 11272 branches covered (63.8%)

59 of 61 new or added lines in 1 file covered. (96.72%)

27763 of 34129 relevant lines covered (81.35%)

1.6 hits per line