1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
from base import *
from tag import Tag
from django.utils.translation import ugettext as _
class QuestionManager(NodeManager):
def search(self, keywords, **kwargs):
return False, 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")
accepted_count = DenormalizedField("children", ~models.Q(state_string__contains="(deleted)"), node_type="answer", marked=True)
favorite_count = DenormalizedField("actions", action_type="favorite", canceled=False)
friendly_name = _("question")
objects = QuestionManager()
@property
def closed(self):
return self.nis.closed
@property
def view_count(self):
return self.extra_count
@property
def headline(self):
return self._headline()
def _headline(self):
if self.nis.deleted:
return _('[deleted] ') + self.title
if self.nis.closed:
return _('[closed] ') + self.title
return self.title
@property
def accepted_answers(self):
return self.answers.filter(~models.Q(state_string__contains="(deleted)"), marked=True)
@models.permalink
def get_absolute_url(self):
return ('question', (), {'id': self.id, 'slug': django_urlquote(slugify(self.title))})
def meta_description(self):
return self.summary
def get_revision_url(self):
return reverse('question_revisions', args=[self.id])
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.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]
class QuestionSubscription(models.Model):
user = models.ForeignKey(User)
question = models.ForeignKey(Node)
auto_subscription = models.BooleanField(default=True)
last_view = models.DateTimeField(default=datetime.datetime.now())
class Meta:
app_label = 'forum'
class QuestionRevision(NodeRevision):
class Meta:
proxy = True