Page MenuHomePhabricator

Remove the user from the participants list into the database
Closed, ResolvedPublic

Description

As a Dev, I want to remove (soft delete) the user from the list of participants of a giving event registration id

Background: Users should be able to leave events, but it would be useful for organizers if it is a soft delete so that: 1) organizers can see total number of people who have left event, 2) organizers can see who left event, so they can maybe see if there are patterns (such as being from certain wikis, communities, etc), and 3) we could potentially have a field/dropdown in the future where participant can optionally share why they are leaving the event that can be shared with organizer. This is not something we need to display in the UI for V0, but it could be useful for MVP and V2.

Acceptance criteria:

The user must be soft deleted on the list of participants in the database

Event Timeline

Change 772845 had a related patch set uploaded (by Daimona Eaytoy; author: Daimona Eaytoy):

[mediawiki/extensions/CampaignEvents@master] Create a REST endpoint for unregistering as a participant

https://gerrit.wikimedia.org/r/772845

The user must be soft deleted

Oh, I didn't notice this. @cmelo do we need soft deletion for V0? The schema we created doesn't seem to support that.

ifried updated the task description. (Show Details)

We do need to change our schema to allow soft deletion. I was thinking that we could have another field in the ce_participants table, e.g. cep_deleted that is 1 if the participant unregistered and 0 otherwise. @vyuen @cmelo @JCarvalho What do you think?

The user must be soft deleted

Oh, I didn't notice this. @cmelo do we need soft deletion for V0? The schema we created doesn't seem to support that.

Hi @Daimona, yes we need to create a new field into the database, I think it should be a deleted_at (timestamp)

The user must be soft deleted

Oh, I didn't notice this. @cmelo do we need soft deletion for V0? The schema we created doesn't seem to support that.

Hi @Daimona, yes we need to create a new field into the database, I think it should be a deleted_at (timestamp)

That's a good point, but is it needed?. @ifried do we need to know when a participant has unregistered from an event?

Change 773624 had a related patch set uploaded (by Daimona Eaytoy; author: Daimona Eaytoy):

[mediawiki/extensions/CampaignEvents@master] Implement soft deletion of participants

https://gerrit.wikimedia.org/r/773624

The user must be soft deleted

Oh, I didn't notice this. @cmelo do we need soft deletion for V0? The schema we created doesn't seem to support that.

Hi @Daimona, yes we need to create a new field into the database, I think it should be a deleted_at (timestamp)

That's a good point, but is it needed?. @ifried do we need to know when a participant has unregistered from an event?

This could help us in case we have scenarios like:

We want to track when participant are unregistering for events.
We could get information like, almost 80% of participants unregister 2 days before the event, with this information we can help organizers informing them to send a reminder or a motivation message 3 days before the event to encourage the participants to attend.

Change 773624 merged by jenkins-bot:

[mediawiki/extensions/CampaignEvents@master] Implement soft deletion of participants

https://gerrit.wikimedia.org/r/773624

Change 772845 merged by jenkins-bot:

[mediawiki/extensions/CampaignEvents@master] Create a REST endpoint for unregistering as a participant

https://gerrit.wikimedia.org/r/772845

Nothing user-facing to test, so I am marking this as done.