Description

This task involves updating the quiz and cooperations collections in the database. Specifically:

1. Remove the resourceType field from the quiz collection and migrate it to the corresponding cooperations documents.
2. Remove the availability field from the quiz collection and migrate it to the corresponding cooperations documents.
3. If no corresponding cooperations document is found for a quiz, the fields will be removed without adding them to cooperations.

Tasks

1. Analyze Data:

   • Verify that all documents in the cooperations collection contain a resourceId field referencing a valid _id in the quiz collection.
   • Ensure that removing the availability and resourceType fields from the quiz collection does not affect dependent functionality.

2. Update cooperations:

   • For each document in the quiz collection:
     • Check if a corresponding document exists in the cooperations collection (match by resourceId).
     • If a match is found:
       • Add the resourceType field to the cooperations document with the appropriate value ("quiz" or other relevant value).
     • If no match is found:
       • Skip updating cooperations.

3. Remove Fields from lessons:

   • Remove the resourceType field from all documents in the quiz collection.
   • Remove the availability field from all documents in the quiz collection.

4. Testing:

   • Validate that:
     • The resourceType field is correctly added to the cooperations collection where applicable.
     • The resourceType and availability fields are removed from all documents in the quiz collection.
     • Documents in the quiz collection without a matching cooperations document only have the fields removed.

5. Code Implementation:

   • Write a migration script that:
     • Checks for a corresponding cooperations document for each quiz.
     • Adds resourceType to cooperations if a match is found.
     • Removes resourceType and availability from quiz regardless of whether a match is found.

6. Testing Automation:

   • Write automated tests to verify:
     • Correct updates to cooperations where matches exist.
     • Correct removal of resourceType and availability from quiz.
     • Handling of quiz without a matching cooperations document.