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
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
|
import datetime
from django.db import models
from django.utils.http import urlquote as django_urlquote
from django.template.defaultfilters import slugify
from django.core.urlresolvers import reverse
from forum.models.base import AnonymousContent, DeletableContent
from forum.models.base import ContentRevision
from forum.models.base import save_post, parse_post_text
from forum.models import content
from forum.models.question import Question
from forum import const
class AnswerManager(models.Manager):
def create_new(self, question=None, author=None, added_at=None, wiki=False, text='', email_notify=False):
answer = Answer(
question = question,
author = author,
added_at = added_at,
wiki = wiki,
text = text,
#.html field is denormalized by the save() call
)
if answer.wiki:
answer.last_edited_by = answer.author
answer.last_edited_at = added_at
answer.wikified_at = added_at
answer.save()
answer.add_revision(
revised_by = author,
revised_at = added_at,
text = text,
comment = const.POST_STATUS['default_version'],
)
#update question data
question.last_activity_at = added_at
question.last_activity_by = author
question.save()
Question.objects.update_answer_count(question)
#set notification/delete
if email_notify:
if author not in question.followed_by.all():
question.followed_by.add(author)
else:
#not sure if this is necessary. ajax should take care of this...
try:
question.followed_by.remove(author)
except:
pass
return answer
def get_author_list(self, **kwargs):
authors = set()
for answer in self:
authors.update(answer.get_author_list(**kwargs))
return list(authors)
#GET_ANSWERS_FROM_USER_QUESTIONS = u'SELECT answer.* FROM answer INNER JOIN question ON answer.question_id = question.id WHERE question.author_id =%s AND answer.author_id <> %s'
def get_answers_from_question(self, question, user=None):
"""
Retrieves visibile answers for the given question. Delete answers
are only visibile to the person who deleted them.
"""
if user is None or not user.is_authenticated():
return self.filter(question=question, deleted=False)
else:
return self.filter(models.Q(question=question),
models.Q(deleted=False) | models.Q(deleted_by=user))
#todo: I think this method is not being used anymore, I'll just comment it for now
#def get_answers_from_questions(self, user_id):
# """
# Retrieves visibile answers for the given question. Which are not included own answers
# """
# cursor = connection.cursor()
# cursor.execute(self.GET_ANSWERS_FROM_USER_QUESTIONS, [user_id, user_id])
# return cursor.fetchall()
class Answer(content.Content, DeletableContent):
question = models.ForeignKey('Question', related_name='answers')
accepted = models.BooleanField(default=False)
accepted_at = models.DateTimeField(null=True, blank=True)
objects = AnswerManager()
class Meta(content.Content.Meta):
db_table = u'answer'
save = save_post
parse = parse_post_text
def apply_edit(self, edited_at=None, edited_by=None, text=None, comment=None, wiki=False):
if text is None:
text = self.get_latest_revision().text
if edited_at is None:
edited_at = datetime.datetime.now()
if edited_by is None:
raise Exception('edited_by is required')
self.last_edited_at = edited_at
self.last_edited_by = edited_by
#self.html is denormalized in save()
self.text = text
#todo: bug wiki has no effect here
self.save()
self.add_revision(
revised_by=edited_by,
revised_at=edited_at,
text=text,
comment=comment
)
self.question.last_activity_at = edited_at
self.question.last_activity_by = edited_by
self.question.save()
def add_revision(self, revised_by=None, revised_at=None, text=None, comment=None):
if None in (revised_by, revised_at, text):
raise Exception('arguments revised_by, revised_at and text are required')
rev_no = self.revisions.all().count() + 1
if comment in (None, ''):
if rev_no == 1:
comment = const.POST_STATUS['default_version']
else:
comment = 'No.%s Revision' % rev_no
return AnswerRevision.objects.create(
answer=self,
author=revised_by,
revised_at=revised_at,
text=text,
summary=comment,
revision=rev_no
)
def get_origin_post(self):
return self.question
def get_user_vote(self, user):
if user.__class__.__name__ == "AnonymousUser":
return None
votes = self.votes.filter(user=user)
if votes and votes.count() > 0:
return votes[0]
else:
return None
def get_question_title(self):
return self.question.title
def get_absolute_url(self):
return '%s%s#%s' % (reverse('question', args=[self.question.id]), django_urlquote(slugify(self.question.title)), self.id)
def __unicode__(self):
return self.html
class AnswerRevision(ContentRevision):
"""A revision of an Answer."""
answer = models.ForeignKey('Answer', related_name='revisions')
def get_absolute_url(self):
return reverse('answer_revisions', kwargs={'id':self.answer.id})
def get_question_title(self):
return self.answer.question.title
class Meta(ContentRevision.Meta):
db_table = u'answer_revision'
ordering = ('-revision',)
def save(self, **kwargs):
"""Looks up the next available revision number if not set."""
if not self.revision:
self.revision = AnswerRevision.objects.filter(
answer=self.answer).values_list('revision',
flat=True)[0] + 1
super(AnswerRevision, self).save(**kwargs)
class AnonymousAnswer(AnonymousContent):
question = models.ForeignKey('Question', related_name='anonymous_answers')
def publish(self,user):
added_at = datetime.datetime.now()
Answer.objects.create_new(question=self.question,wiki=self.wiki,
added_at=added_at,text=self.text,
author=user)
self.delete()
|