[Backend] Automate Label Creation and Assignment for Snippet Categorization

[linear[bot]]

As a developer, I want to enhance the backend to support the "Upvotes" feature by implementing label assignment functionality, so that snippets can be accurately categorized based on disinformation categories identified by Gemini Pro.

Acceptance Criteria:

1. After receiving disinformation_categories for a snippet from Gemini Pro:
   • Each category should be checked against the existing entries in the labels table.
   • If the category label does not exist, create a new entry in the labels table.
   • If the category label already exists, skip the creation step.
2. For each label associated with the snippet:
   • Create a new record in the snippet_labels table to establish the relationship between the snippet and its labels.

Tasks:

• [ ] Implement logic to check for existing labels in the labels table.
• [ ] Add functionality to create new labels if they do not exist.
• [ ] Develop logic to associate labels with snippets by creating entries in the snippet_labels table.
• [ ] Write unit tests to ensure labels are correctly created and associated with snippets.
• [ ] Update documentation to reflect changes in the backend regarding label handling.

Notes:

• Ensure that the label creation and association process is efficient to handle a large number of snippets and categories.
• Consider edge cases where the same snippet might receive repeated category labels.

This story should guide the development process and ensure that all necessary components for the "Upvotes" feature are implemented correctly in the backend.

[linear[bot]]

VER-64 [Backend] Automate Label Creation and Assignment for Snippet Categorization