(SP:) Migration Task: Remove Fields from Attachments

[Mike-Popovych]

Description

This task involves updating the attachments collection in the database. Specifically:

1. Add the resourceType field to documents in the attachments collection if it does not already exist.
2. Remove the availability field from the attachments collection.

Tasks

1. Analyze Data:

   • Ensure that adding the resourceType field and removing the availability field from the attachments collection does not affect dependent functionality.

2. Update attachments:

   • For each document in the attachments collection:
     • Check if the resourceType field exists.
     • If the resourceType field does not exist:
       • Add the field with the appropriate default value (e.g., "attachments" or other relevant value).
     • Remove the availability field from the document.

3. Testing:

   • Validate that:
     • The resourceType field is added to documents in the attachments collection where it was missing.
     • The availability field is removed from all documents in the attachments collection.

4. Code Implementation:

   • Write a migration script that:
     • Adds the resourceType field to documents in the attachments collection if it is missing.
     • Removes the availability field from all documents in the attachments collection.