Have the ability to delete messages but without affecting the other users

[fokion]

Create a service and a new entity that holds the relationship between the user and the message. If we delete the message we basically delete this association and not the actual message.

• needs to be done tests for the associations without mocking as it is fragile.
• create a script that creates these associations for existing data.

[marcinadd]

I have a suggestion to check if the message doesn't have any association, then it should be deleted from db. While you are deleting association you can check this imho.

[fokion]

I will have a look. I saw that there is a field that cascades delete on the messages if a user is deleted. In my opinion, it has to be preserved as that affects the receiver. I do have to cascade the deletion if both associations are missing. I will work on it during the weekend

[fokion]

@marcinadd I have updated the code to remove the messages when both recipient and sender are unlinked.

[fokion]

For the service, it would be great to have test containers integrated first as mocking is not ideal.

[marcinadd]

For the service, it would be great to have test containers integrated first as mocking is not ideal.

Thanks for the suggestion. But I don't know is there important reason to edit all already created test classes at the moment but a contribution is welcome. If you want to help, you can create a pull request.

[marcinadd]

35