X-Git-Url: https://git.openstreetmap.org./osqa.git/blobdiff_plain/3b2f9ebad3131bb86045f3ac1d3b4f43b6d78398..9b6be99a1eed1adddfd062642f6ca23f79d14aea:/forum/models/question.py diff --git a/forum/models/question.py b/forum/models/question.py index 485576d..7902a50 100644 --- a/forum/models/question.py +++ b/forum/models/question.py @@ -4,132 +4,75 @@ from django.utils.translation import ugettext as _ question_view = django.dispatch.Signal(providing_args=['instance', 'user']) -class Question(QandA): - accepted_answer = models.OneToOneField('Answer', null=True, related_name="question_accepting") - closed = models.BooleanField(default=False) - closed_by = models.ForeignKey(User, null=True, blank=True, related_name='closed_questions') - closed_at = models.DateTimeField(null=True, blank=True) - close_reason = models.SmallIntegerField(choices=CLOSE_REASONS, null=True, blank=True) - subscribers = models.ManyToManyField(User, related_name='subscriptions', through='QuestionSubscription') - - # Denormalised data - answer_count = models.PositiveIntegerField(default=0) - view_count = models.IntegerField(default=0) - favourite_count = models.IntegerField(default=0) - last_activity_at = models.DateTimeField(default=datetime.datetime.now) - last_activity_by = models.ForeignKey(User, related_name='last_active_in_questions') - - favorited_by = models.ManyToManyField(User, through='FavoriteQuestion', related_name='favorite_questions') - - class Meta(QandA.Meta): - db_table = u'question' +class QuestionManager(NodeManager): + def search(self, keywords): + return self.filter(models.Q(title__icontains=keywords) | models.Q(body__icontains=keywords)) + +class Question(Node): + class Meta(Node.Meta): + proxy = True + + answer_count = DenormalizedField("children", ~models.Q(state_string__contains="(deleted)"), node_type="answer") + favorite_count = DenormalizedField("actions", action_type="favorite", canceled=False) + + friendly_name = _("question") + objects = QuestionManager() @property - def headline(self): - if self.closed: - return _('[closed] ') + self.title + def closed(self): + return self.nis.closed - if self.deleted: + @property + def view_count(self): + return self.extra_count + + @property + def headline(self): + if self.nis.deleted: return _('[deleted] ') + self.title + if self.nis.closed: + return _('[closed] ') + self.title + return self.title @property def answer_accepted(self): - return self.accepted_answer is not None - - def delete(self): - super(Question, self).delete() - try: - ping_google() - except Exception: - logging.debug('problem pinging google did you register you sitemap with google?') + return self.extra_ref is not None - def update_last_activity(self, user): - self.last_activity_by = user - self.last_activity_at = datetime.datetime.now() - self.save() - - def activate_revision(self, user, revision): - super(Question, self).activate_revision(user, revision) - self.update_last_activity(user) + @property + def accepted_answer(self): + return self.extra_ref @models.permalink def get_absolute_url(self): return ('question', (), {'id': self.id, 'slug': django_urlquote(slugify(self.title))}) - def get_answer_count_by_user(self, user_id): - from answer import Answer - query_set = Answer.objects.filter(author__id=user_id) - return query_set.filter(question=self).count() - - def get_question_title(self): - if self.closed: - attr = CONST['closed'] - elif self.deleted: - attr = CONST['deleted'] - else: - attr = None - if attr is not None: - return u'%s %s' % (self.title, attr) - else: - return self.title - def get_revision_url(self): return reverse('question_revisions', args=[self.id]) - def get_latest_revision(self): - return self.revisions.all()[0] - def get_related_questions(self, count=10): cache_key = '%s.related_questions:%d:%d' % (settings.APP_URL, count, self.id) related_list = cache.get(cache_key) if related_list is None: - related_list = Question.objects.values('id').filter(tags__id__in=[t.id for t in self.tags.all()] - ).exclude(id=self.id).exclude(deleted=True).annotate(frequency=models.Count('id')).order_by('-frequency')[:count] + related_list = Question.objects.filter_state(deleted=False).values('id').filter(tags__id__in=[t.id for t in self.tags.all()] + ).exclude(id=self.id).annotate(frequency=models.Count('id')).order_by('-frequency')[:count] cache.set(cache_key, related_list, 60 * 60) return [Question.objects.get(id=r['id']) for r in related_list] - def __unicode__(self): - return self.title def question_viewed(instance, **kwargs): - instance.view_count += 1 + instance.extra_count += 1 instance.save() question_view.connect(question_viewed) -class FavoriteQuestion(models.Model): - question = models.ForeignKey('Question') - user = models.ForeignKey(User, related_name='user_favorite_questions') - added_at = models.DateTimeField(default=datetime.datetime.now) - - class Meta: - unique_together = ('question', 'user') - app_label = 'forum' - db_table = u'favorite_question' - - def __unicode__(self): - return '[%s] favorited at %s' %(self.user, self.added_at) - - def _update_question_fav_count(self, diff): - self.question.favourite_count = self.question.favourite_count + diff - self.question.save() - - def save(self, *args, **kwargs): - super(FavoriteQuestion, self).save(*args, **kwargs) - if self._is_new: - self._update_question_fav_count(1) - - def delete(self): - self._update_question_fav_count(-1) - super(FavoriteQuestion, self).delete() class QuestionSubscription(models.Model): user = models.ForeignKey(User) - question = models.ForeignKey(Question) + question = models.ForeignKey(Node) auto_subscription = models.BooleanField(default=True) last_view = models.DateTimeField(default=datetime.datetime.now())