[Bug] If I remove the email of a person, all the email participants are linked to that person

[bosiraphael]

Bug Description

If I remove the email of a person, all the email participants are linked to that person.

Expected behavior

Should just unlink the email associated to that person.

Technical inputs

Probably an error inside message-participant-person.listener.ts

[bosiraphael]

In the frontend we can't modify an email to be empty

[bosiraphael]

This only happens when the user primary email is set to null. This can never happen via the frontend since there is validation, but this error appeared when a user set the email of a person to null via the API.
Normally, the text fields are non nullable, but due to a bug on the composite fields, emailPrimaryEmail and other text composite fields are nullable.

We listen to the changes on people emails to reassign the messageParticipants and the calendarEventParticipants to the right person, but inside match-participant.service on line 149, we do this:

const participantsToUpdate = await participantRepository.find({
      where: {
        handle,
      },
    });

But if handle is null, it selects all the participants.
To fix this, we should make all composite fields of type text non nullable and use Equal from typeorm to modify the query like this:

const participantsToUpdate = await participantRepository.find({
      where: {
        handle: Equal(handle)
      },
    });