extensions-website/reviewers/models.py
Oleg Komarov db67d94507 Use a materialized Extension.latest_version field instead of a dynamic property (#152)
Original reason for this change is #128: we need an efficient way to query tags of a latest_version.

We could potentially avoid converting this property to a field if we had a proper search engine,
but we would still need to define the same explicit triggers for reindexing - i.e. recompute the latest_version change.

This PR also takes a stab at simplifying data flow,
but more work is needed to improve the management of `is_listed` and `status` fields.

Reviewed-on: #152
Reviewed-by: Anna Sirota <railla@noreply.localhost>
2024-05-27 17:58:54 +02:00

56 lines
1.9 KiB
Python

from django.contrib.auth import get_user_model
from django.db import models
from django.utils.translation import gettext_lazy as _
import common.help_texts
from common.model_mixins import CreatedModifiedMixin, RecordDeletionMixin
from constants.base import EXTENSION_TYPE_CHOICES
from constants.reviewers import CANNED_RESPONSE_CATEGORY_CHOICES
User = get_user_model()
class CannedResponse(CreatedModifiedMixin, models.Model):
TYPES = EXTENSION_TYPE_CHOICES
CATEGORIES = CANNED_RESPONSE_CATEGORY_CHOICES
name = models.CharField(max_length=255)
response = models.TextField()
sort_group = models.CharField(max_length=255)
type = models.PositiveIntegerField(choices=TYPES, db_index=True, default=TYPES.BPY)
# Category is used only by code-manager
category = models.PositiveIntegerField(choices=CATEGORIES, default=CATEGORIES.OTHER)
def __str__(self):
return str(self.name)
class ApprovalActivity(CreatedModifiedMixin, RecordDeletionMixin, models.Model):
class ActivityType(models.TextChoices):
COMMENT = "COM", _("Comment")
APPROVED = "APR", _("Approved")
AWAITING_CHANGES = "AWC", _("Awaiting Changes")
AWAITING_REVIEW = "AWR", _("Awaiting Review")
UPLOADED_NEW_VERSION = "UNV", _("Uploaded New Version")
user = models.ForeignKey(User, on_delete=models.CASCADE, blank=True, null=True)
extension = models.ForeignKey(
'extensions.Extension',
on_delete=models.CASCADE,
related_name='review_activity',
)
type = models.CharField(
max_length=3,
choices=ActivityType.choices,
default=ActivityType.COMMENT,
)
message = models.TextField(help_text=common.help_texts.markdown, blank=False, null=False)
class Meta:
verbose_name_plural = "Review activity"
def __str__(self):
return f"{self.extension.name}: {self.get_type_display()}"