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
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
|
import logging
import datetime
from django.conf import settings
from django.utils.datastructures import SortedDict
from django.db import models
from django.contrib.auth.models import User
from django.contrib.sitemaps import ping_google
from django.utils.translation import ugettext as _
import askbot
import askbot.conf
from askbot.models.tag import Tag
from askbot.models.base import AnonymousContent
from askbot.models.post import PostRevision
from askbot.models.base import BaseQuerySetManager
from askbot.models import content
from askbot.models import signals
from askbot import const
from askbot.utils.lists import LazyList
from askbot.utils.slug import slugify
from askbot.utils import mysql
#todo: too bad keys are duplicated see const sort methods
QUESTION_ORDER_BY_MAP = {
'age-desc': '-added_at',
'age-asc': 'added_at',
'activity-desc': '-last_activity_at',
'activity-asc': 'last_activity_at',
'answers-desc': '-answer_count',
'answers-asc': 'answer_count',
'votes-desc': '-score',
'votes-asc': 'score',
'relevance-desc': None#this is a special case for postges only
}
def get_tag_summary_from_questions(questions):
"""returns a humanized string containing up to
five most frequently used
unique tags coming from the ``questions``.
Variable ``questions`` is an iterable of
:class:`~askbot.models.Question` model objects.
This is not implemented yet as a query set method,
because it is used on a list.
"""
#todo: in python 2.6 there is collections.Counter() thing
#which would be very useful here
tag_counts = dict()
for question in questions:
tag_names = question.get_tag_names()
for tag_name in tag_names:
if tag_name in tag_counts:
tag_counts[tag_name] += 1
else:
tag_counts[tag_name] = 1
tag_list = tag_counts.keys()
#sort in descending order
tag_list.sort(lambda x, y: cmp(tag_counts[y], tag_counts[x]))
#note that double quote placement is important here
if len(tag_list) == 1:
last_topic = '"'
elif len(tag_list) <= 5:
last_topic = _('" and "%s"') % tag_list.pop()
else:
tag_list = tag_list[:5]
last_topic = _('" and more')
return '"' + '", "'.join(tag_list) + last_topic
class QuestionQuerySet(models.query.QuerySet):
"""Custom query set subclass for :class:`~askbot.models.Question`
"""
#todo: becomes thread query set
def create_new(
self,
title = None,
author = None,
added_at = None,
wiki = False,
is_anonymous = False,
tagnames = None,
text = None
):
#todo: some work from this method will go to thread
#and some - merged with the Answer.objects.create_new
question = Question(
title = title,
author = author,
added_at = added_at,
last_activity_at = added_at,
last_activity_by = author,
wiki = wiki,
is_anonymous = is_anonymous,
tagnames = tagnames,
#html field is denormalized in .save() call
text = text,
#summary field is denormalized in .save() call
)
if question.wiki:
#DATED COMMENT
#todo: this is confusing - last_edited_at field
#is used as an indicator whether question has been edited
#but in principle, post creation should count as edit as well
question.last_edited_by = question.author
question.last_edited_at = added_at
question.wikified_at = added_at
question.parse_and_save(author = author)
question.update_tags(tagnames = tagnames, user = author, timestamp = added_at)
question.add_revision(
author = author,
is_anonymous = is_anonymous,
text = text,
comment = const.POST_STATUS['default_version'],
revised_at = added_at,
)
return question
def get_by_text_query(self, search_query):
"""returns a query set of questions,
matching the full text query
"""
#todo - goes to thread - we search whole threads
if getattr(settings, 'USE_SPHINX_SEARCH', False):
matching_questions = Question.sphinx_search.query(search_query)
question_ids = [q.id for q in matching_questions]
return Question.objects.filter(deleted = False, id__in = question_ids)
if settings.DATABASE_ENGINE == 'mysql' and mysql.supports_full_text_search():
return self.filter(
models.Q(title__search = search_query) \
| models.Q(text__search = search_query) \
| models.Q(tagnames__search = search_query) \
| models.Q(answers__text__search = search_query)
)
elif 'postgresql_psycopg2' in askbot.get_database_engine_name():
rank_clause = "ts_rank(question.text_search_vector, plainto_tsquery(%s))";
search_query = '&'.join(search_query.split())
extra_params = (search_query,)
extra_kwargs = {
'select': {'relevance': rank_clause},
'where': ['text_search_vector @@ plainto_tsquery(%s)'],
'params': extra_params,
'select_params': extra_params,
}
return self.extra(**extra_kwargs)
else:
#fallback to dumb title match search
return self.extra(
where=['title like %s'],
params=['%' + search_query + '%']
)
def run_advanced_search(
self,
request_user = None,
search_state = None
):
"""all parameters are guaranteed to be clean
however may not relate to database - in that case
a relvant filter will be silently dropped
"""
#todo: same as for get_by_text_query - goes to Tread
scope_selector = getattr(
search_state,
'scope',
const.DEFAULT_POST_SCOPE
)
search_query = search_state.query
tag_selector = search_state.tags
author_selector = search_state.author
sort_method = getattr(
search_state,
'sort',
const.DEFAULT_POST_SORT_METHOD
)
qs = self.filter(deleted=False)#todo - add a possibility to see deleted questions
#return metadata
meta_data = {}
if search_query:
if search_state.stripped_query:
qs = qs.get_by_text_query(search_state.stripped_query)
#a patch for postgres search sort method
if askbot.conf.should_show_sort_by_relevance():
if sort_method == 'relevance-desc':
qs = qs.extra(order_by = ['-relevance',])
if search_state.query_title:
qs = qs.filter(title__icontains = search_state.query_title)
if len(search_state.query_tags) > 0:
qs = qs.filter(tags__name__in = search_state.query_tags)
if len(search_state.query_users) > 0:
query_users = list()
for username in search_state.query_users:
try:
user = User.objects.get(username__iexact = username)
query_users.append(user)
except User.DoesNotExist:
pass
if len(query_users) > 0:
qs = qs.filter(author__in = query_users)
if tag_selector:
for tag in tag_selector:
qs = qs.filter(tags__name = tag)
#have to import this at run time, otherwise there
#a circular import dependency...
from askbot.conf import settings as askbot_settings
if scope_selector:
if scope_selector == 'unanswered':
qs = qs.filter(closed = False)#do not show closed questions in unanswered section
if askbot_settings.UNANSWERED_QUESTION_MEANING == 'NO_ANSWERS':
qs = qs.filter(answer_count=0)#todo: expand for different meanings of this
elif askbot_settings.UNANSWERED_QUESTION_MEANING == 'NO_ACCEPTED_ANSWERS':
qs = qs.filter(answer_accepted=False)
elif askbot_settings.UNANSWERED_QUESTION_MEANING == 'NO_UPVOTED_ANSWERS':
raise NotImplementedError()
else:
raise Exception('UNANSWERED_QUESTION_MEANING setting is wrong')
elif scope_selector == 'favorite':
favorite_filter = models.Q(favorited_by = request_user)
if 'followit' in settings.INSTALLED_APPS:
followed_users = request_user.get_followed_users()
favorite_filter |= models.Q(author__in = followed_users)
favorite_filter |= models.Q(answers__author__in = followed_users)
qs = qs.filter(favorite_filter)
#user contributed questions & answers
if author_selector:
try:
#todo maybe support selection by multiple authors
u = User.objects.get(id=int(author_selector))
qs = qs.filter(
models.Q(author=u, deleted=False) \
| models.Q(answers__author=u, answers__deleted=False)
)
meta_data['author_name'] = u.username
except User.DoesNotExist:
meta_data['author_name'] = None
#get users tag filters
ignored_tag_names = None
if request_user and request_user.is_authenticated():
uid_str = str(request_user.id)
#mark questions tagged with interesting tags
#a kind of fancy annotation, would be nice to avoid it
interesting_tags = Tag.objects.filter(
user_selections__user=request_user,
user_selections__reason='good'
)
ignored_tags = Tag.objects.filter(
user_selections__user=request_user,
user_selections__reason='bad'
)
meta_data['interesting_tag_names'] = [tag.name for tag in interesting_tags]
ignored_tag_names = [tag.name for tag in ignored_tags]
meta_data['ignored_tag_names'] = ignored_tag_names
if interesting_tags or request_user.has_interesting_wildcard_tags():
#expensive query
if request_user.display_tag_filter_strategy == \
const.INCLUDE_INTERESTING:
#filter by interesting tags only
interesting_tag_filter = models.Q(tags__in = interesting_tags)
if request_user.has_interesting_wildcard_tags():
interesting_wildcards = request_user.interesting_tags.split()
extra_interesting_tags = Tag.objects.get_by_wildcards(
interesting_wildcards
)
interesting_tag_filter |= models.Q(tags__in = extra_interesting_tags)
qs = qs.filter(interesting_tag_filter)
else:
#simply annotate interesting questions
qs = qs.extra(
select = SortedDict([
(
'interesting_score',
'SELECT COUNT(1) FROM askbot_markedtag, question_tags '
+ 'WHERE askbot_markedtag.user_id = %s '
+ 'AND askbot_markedtag.tag_id = question_tags.tag_id '
+ 'AND askbot_markedtag.reason = \'good\' '
+ 'AND question_tags.question_id = question.id'
),
]),
select_params = (uid_str,),
)
# get the list of interesting and ignored tags (interesting_tag_names, ignored_tag_names) = (None, None)
if ignored_tags or request_user.has_ignored_wildcard_tags():
if request_user.display_tag_filter_strategy == const.EXCLUDE_IGNORED:
#exclude ignored tags if the user wants to
qs = qs.exclude(tags__in=ignored_tags)
if request_user.has_ignored_wildcard_tags():
ignored_wildcards = request_user.ignored_tags.split()
extra_ignored_tags = Tag.objects.get_by_wildcards(
ignored_wildcards
)
qs = qs.exclude(tags__in = extra_ignored_tags)
else:
#annotate questions tagged with ignored tags
#expensive query
qs = qs.extra(
select = SortedDict([
(
'ignored_score',
'SELECT COUNT(1) '
+ 'FROM askbot_markedtag, question_tags '
+ 'WHERE askbot_markedtag.user_id = %s '
+ 'AND askbot_markedtag.tag_id = question_tags.tag_id '
+ 'AND askbot_markedtag.reason = \'bad\' '
+ 'AND question_tags.question_id = question.id'
)
]),
select_params = (uid_str, )
)
if sort_method != 'relevance-desc':
#relevance sort is set in the extra statement
#only for postgresql
orderby = QUESTION_ORDER_BY_MAP[sort_method]
qs = qs.order_by(orderby)
qs = qs.distinct()
qs = qs.select_related(
'last_activity_by__id',
'last_activity_by__username',
'last_activity_by__reputation',
'last_activity_by__gold',
'last_activity_by__silver',
'last_activity_by__bronze',
'last_activity_by__country',
'last_activity_by__show_country',
)
related_tags = Tag.objects.get_related_to_search(
questions = qs,
search_state = search_state,
ignored_tag_names = ignored_tag_names
)
if askbot_settings.USE_WILDCARD_TAGS == True \
and request_user.is_authenticated() == True:
tagnames = request_user.interesting_tags
meta_data['interesting_tag_names'].extend(tagnames.split())
tagnames = request_user.ignored_tags
meta_data['ignored_tag_names'].extend(tagnames.split())
return qs, meta_data, related_tags
def added_between(self, start, end):
"""questions added between ``start`` and ``end`` timestamps"""
#todo: goes to thread
return self.filter(
added_at__gt = start
).exclude(
added_at__gt = end
)
def get_questions_needing_reminder(self,
user = None,
activity_type = None,
recurrence_delay = None):
"""returns list of questions that need a reminder,
corresponding the given ``activity_type``
``user`` - is the user receiving the reminder
``recurrence_delay`` - interval between sending the
reminders about the same question
"""
#todo: goes to thread
from askbot.models import Activity#avoid circular import
question_list = list()
for question in self:
try:
activity = Activity.objects.get(
user = user,
question = question,
activity_type = activity_type
)
now = datetime.datetime.now()
if now < activity.active_at + recurrence_delay:
continue
except Activity.DoesNotExist:
activity = Activity(
user = user,
question = question,
activity_type = activity_type,
content_object = question,
)
activity.active_at = datetime.datetime.now()
activity.save()
question_list.append(question)
return question_list
#todo: this function is similar to get_response_receivers
#profile this function against the other one
#todo: maybe this must be a query set method, not manager method
def get_question_and_answer_contributors(self, question_list):
"""returns query set of Thread contributors
"""
#todo: goes to thread - queries will be simplified too
answer_list = []
#question_list = list(question_list)#important for MySQL, b/c it does not support
from askbot.models.answer import Answer
q_id = [question.id for question in question_list]
a_id = list(Answer.objects.filter(question__in=q_id).values_list('id', flat=True))
u_id = set(self.filter(id__in=q_id).values_list('author', flat=True))
u_id = u_id.union(
set(Answer.objects.filter(id__in=a_id).values_list('author', flat=True))
)
#todo: this does not belong gere - here we select users with real faces
#first and limit the number of users in the result for display
#on the main page, we might also want to completely hide fake gravatars
#and show only real images and the visitors - even if he does not have
#a real image and try to prompt him/her to upload a picture
from askbot.conf import settings as askbot_settings
avatar_limit = askbot_settings.SIDEBAR_MAIN_AVATAR_LIMIT
contributors = User.objects.filter(id__in=u_id).order_by('avatar_type', '?')[:avatar_limit]
#print contributors
#could not optimize this query with indices so it was split into what's now above
#contributors = User.objects.filter(
# models.Q(questions__in=question_list) \
# | models.Q(answers__in=answer_list)
# ).distinct()
#contributors = list(contributors)
return contributors
def get_author_list(self, **kwargs):
#todo: - this is duplication - answer manager also has this method
#will be gone when models are consolidated
#note that method get_question_and_answer_contributors is similar in function
#todo: goes to thread
authors = set()
for question in self:
authors.update(question.get_author_list(**kwargs))
return list(authors)
def update_view_count(self, question):
"""
update counter+1 when user browse question page
"""
#todo: moves to thread
self.filter(id=question.id).update(view_count = question.view_count + 1)
class QuestionManager(BaseQuerySetManager):
"""chainable custom query set manager for
questions
"""
#todo: becomes thread manager
def get_query_set(self):
return QuestionQuerySet(self.model)
class Question(content.Content):
#todo: this really becomes thread,
#except property post_type goes to Post
post_type = 'question'
title = models.CharField(max_length=300)
tags = models.ManyToManyField('Tag', related_name='questions')
#todo: answer accepted will be replaced with
#accepted_answer foreign key (nullable)
answer_accepted = models.BooleanField(default=False)
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=const.CLOSE_REASONS,
null=True,
blank=True
)
followed_by = models.ManyToManyField(User, related_name='followed_questions')
# Denormalised data
answer_count = models.PositiveIntegerField(default=0)
view_count = models.PositiveIntegerField(default=0)
favourite_count = models.PositiveIntegerField(default=0)
last_activity_at = models.DateTimeField(default=datetime.datetime.now)
last_activity_by = models.ForeignKey(User, related_name='last_active_in_questions')
tagnames = models.CharField(max_length=125)
summary = models.CharField(max_length=180)
favorited_by = models.ManyToManyField(User, through='FavoriteQuestion', related_name='favorite_questions')
#note: anonymity here applies to question only, but
#the field will still go to thread
#maybe we should rename it to is_question_anonymous
#we might have to duplicate the is_anonymous on the Post,
#if we are to allow anonymous answers
#the reason is that the title and tags belong to thread,
#but the question body to Post
is_anonymous = models.BooleanField(default=False)
objects = QuestionManager()
class Meta(content.Content.Meta):
db_table = u'question'
def remove_author_anonymity(self):
"""removes anonymous flag from the question
and all its revisions
the function calls update method to make sure that
signals are not called
"""
#note: see note for the is_anonymous field
#it is important that update method is called - not save,
#because we do not want the signals to fire here
Question.objects.filter(id = self.id).update(is_anonymous = False)
self.revisions.all().update(is_anonymous = False)
def update_answer_count(self, save = True):
"""updates the denormalized field 'answer_count'
on the question
"""
#todo: goes to thread
self.answer_count = self.get_answers().count()
if save:
self.save()
def update_favorite_count(self):
"""update favourite_count for given question
"""
#todo: goes to thread
self.favourite_count = FavoriteQuestion.objects.filter(
question=self
).count()
self.save()
def get_similar_questions(self):
"""
Get 10 similar questions for given one.
Questions with the individual tags will be added to list if above questions are not full.
This function has a limitation that it will
retrieve only 100 records then select 10 most similar
from that list as querying entire database may
be very expensive - this function will benefit from
some sort of optimization
"""
#todo: goes to thread
#print datetime.datetime.now()
def get_data():
tags_list = self.tags.all()
similar_questions = self.__class__.objects.filter(
tags__in = self.tags.all()
).exclude(
id = self.id,
).exclude(
deleted = True
).distinct()[:100]
similar_questions = list(similar_questions)
output = list()
for question in similar_questions:
question.similarity = self.get_similarity(
other_question = question
)
#sort in reverse order - x and y are interchanged in cmp() call
similar_questions.sort(lambda x,y: cmp(y.similarity, x.similarity))
if len(similar_questions) > 10:
return similar_questions[:10]
else:
return similar_questions
return LazyList(get_data)
def get_similarity(self, other_question = None):
"""return number of tags in the other question
that overlap with the current question (self)
"""
my_tags = set(self.get_tag_names())
others_tags = set(other_question.get_tag_names())
return len(my_tags & others_tags)
def update_tags(self, tagnames = None, user = None, timestamp = None):
"""
Updates Tag associations for a question to match the given
tagname string.
When tags are removed and their use count hits 0 - the tag is
automatically deleted.
When an added tag does not exist - it is created
Tag use counts are recalculated
A signal tags updated is sent
"""
previous_tags = list(self.tags.all())
previous_tagnames = set([tag.name for tag in previous_tags])
updated_tagnames = set(t for t in tagnames.split(' '))
removed_tagnames = previous_tagnames - updated_tagnames
added_tagnames = updated_tagnames - previous_tagnames
modified_tags = list()
#remove tags from the question's tags many2many relation
if removed_tagnames:
removed_tags = [tag for tag in previous_tags if tag.name in removed_tagnames]
self.tags.remove(*removed_tags)
#if any of the removed tags reached use count == 1 that means they must be deleted
for tag in removed_tags:
if tag.used_count == 1:
#we won't modify used count b/c it's done below anyway
removed_tags.remove(tag)
#todo - do we need to use fields deleted_by and deleted_at?
tag.delete()#auto-delete tags whose use count dwindled
#remember modified tags, we'll need to update use counts on them
modified_tags = removed_tags
#add new tags to the relation
if added_tagnames:
#find reused tags
reused_tags = Tag.objects.filter(name__in = added_tagnames)
#undelete them, because we are using them
reused_count = reused_tags.update(
deleted = False,
deleted_by = None,
deleted_at = None
)
#if there are brand new tags, create them and finalize the added tag list
if reused_count < len(added_tagnames):
added_tags = list(reused_tags)
reused_tagnames = set([tag.name for tag in reused_tags])
new_tagnames = added_tagnames - reused_tagnames
for name in new_tagnames:
new_tag = Tag.objects.create(
name = name,
created_by = user,
used_count = 1
)
added_tags.append(new_tag)
else:
added_tags = reused_tags
#finally add tags to the relation and extend the modified list
self.tags.add(*added_tags)
modified_tags.extend(added_tags)
#if there are any modified tags, update their use counts
if modified_tags:
Tag.objects.update_use_counts(modified_tags)
signals.tags_updated.send(None,
question = self,
tags = modified_tags,
user = user,
timestamp = timestamp
)
return True
return False
def repost_as_answer(self, question = None):
"""posts question as answer to another question,
but does not delete the question,
but moves all the comments to the new answer"""
#todo: goes to Thread.
revisions = self.revisions.all().order_by('revised_at')
rev0 = revisions[0]
new_answer = rev0.author.post_answer(
question = question,
body_text = rev0.text,
wiki = self.wiki,
timestamp = rev0.revised_at
)
if len(revisions) > 1:
for rev in revisions:
rev.author.edit_answer(
answer = new_answer,
body_text = rev.text,
revision_comment = rev.summary,
timestamp = rev.revised_at
)
for comment in self.comments.all():
comment.content_object = new_answer
comment.save()
return new_answer
def delete(self):
super(Question, self).delete()
try:
from askbot.conf import settings as askbot_settings
if askbot_settings.GOOGLE_SITEMAP_CODE != '':
ping_google()
except Exception:
logging.debug('problem pinging google did you register you sitemap with google?')
def get_answers(self, user = None):
"""returns query set for answers to this question
that may be shown to the given user
"""
if user is None or user.is_anonymous():
return self.answers.filter(deleted=False)
else:
if user.is_administrator() or user.is_moderator():
return self.answers.all()
else:
return self.answers.filter(
models.Q(deleted = False) | models.Q(author = user) \
| models.Q(deleted_by = user)
)
def retag(self, retagged_by=None, retagged_at=None, tagnames=None, silent=False):
if None in (retagged_by, retagged_at, tagnames):
raise Exception('arguments retagged_at, retagged_by and tagnames are required')
# Update the Question itself
self.tagnames = tagnames
if silent == False:
self.last_edited_at = retagged_at
#self.last_activity_at = retagged_at
self.last_edited_by = retagged_by
#self.last_activity_by = retagged_by
self.save()
# Update the Question's tag associations
self.update_tags(tagnames = tagnames, user = retagged_by, timestamp = retagged_at)
# Create a new revision
latest_revision = self.get_latest_revision()
PostRevision.objects.create_question_revision(
question = self,
title = latest_revision.title,
author = retagged_by,
revised_at = retagged_at,
tagnames = tagnames,
summary = const.POST_STATUS['retagged'],
text = latest_revision.text
)
def set_tag_names(self, tag_names):
"""expects some iterable of unicode string tag names
joins the names with a space and assigns to self.tagnames
does not save the object
"""
self.tagnames = u' '.join(tag_names)
def _get_slug(self):
return slugify(self.title)
slug = property(_get_slug)
def has_favorite_by_user(self, user):
if not user.is_authenticated():
return False
return FavoriteQuestion.objects.filter(question=self, user=user).count() > 0
def get_last_update_info(self):
when, who = self.post_get_last_update_info()
answers = self.answers.all()
if len(answers) > 0:
for a in answers:
a_when, a_who = a.post_get_last_update_info()
if a_when > when:
when = a_when
who = a_who
return when, who
def get_update_summary(self,last_reported_at=None,recipient_email=''):
edited = False
if self.last_edited_at and self.last_edited_at > last_reported_at:
if self.last_edited_by.email != recipient_email:
edited = True
comments = []
for comment in self.comments.all():
if comment.added_at > last_reported_at and comment.user.email != recipient_email:
comments.append(comment)
new_answers = []
answer_comments = []
modified_answers = []
commented_answers = []
import sets
commented_answers = sets.Set([])
for answer in self.answers.all():
if (answer.added_at > last_reported_at and answer.author.email != recipient_email):
new_answers.append(answer)
if (answer.last_edited_at
and answer.last_edited_at > last_reported_at
and answer.last_edited_by.email != recipient_email):
modified_answers.append(answer)
for comment in answer.comments.all():
if comment.added_at > last_reported_at and comment.user.email != recipient_email:
commented_answers.add(answer)
answer_comments.append(comment)
#create the report
from askbot.conf import settings as askbot_settings
if edited or new_answers or modified_answers or answer_comments:
out = []
if edited:
out.append(_('%(author)s modified the question') % {'author':self.last_edited_by.username})
if new_answers:
names = sets.Set(map(lambda x: x.author.username,new_answers))
people = ', '.join(names)
out.append(_('%(people)s posted %(new_answer_count)s new answers') \
% {'new_answer_count':len(new_answers),'people':people})
if comments:
names = sets.Set(map(lambda x: x.user.username,comments))
people = ', '.join(names)
out.append(_('%(people)s commented the question') % {'people':people})
if answer_comments:
names = sets.Set(map(lambda x: x.user.username,answer_comments))
people = ', '.join(names)
if len(commented_answers) > 1:
out.append(_('%(people)s commented answers') % {'people':people})
else:
out.append(_('%(people)s commented an answer') % {'people':people})
url = askbot_settings.APP_URL + self.get_absolute_url()
retval = '<a href="%s">%s</a>:<br>\n' % (url,self.title)
out = map(lambda x: '<li>' + x + '</li>',out)
retval += '<ul>' + '\n'.join(out) + '</ul><br>\n'
return retval
else:
return None
if getattr(settings, 'USE_SPHINX_SEARCH', False):
from djangosphinx.models import SphinxSearch
Question.add_to_class(
'sphinx_search',
SphinxSearch(
index = settings.ASKBOT_SPHINX_SEARCH_INDEX,
mode = 'SPH_MATCH_ALL'
)
)
class QuestionView(models.Model):
question = models.ForeignKey(Question, related_name='viewed')
who = models.ForeignKey(User, related_name='question_views')
when = models.DateTimeField()
class Meta:
app_label = 'askbot'
class FavoriteQuestion(models.Model):
"""A favorite Question of a User."""
question = models.ForeignKey(Question)
user = models.ForeignKey(User, related_name='user_favorite_questions')
added_at = models.DateTimeField(default=datetime.datetime.now)
class Meta:
app_label = 'askbot'
db_table = u'favorite_question'
def __unicode__(self):
return '[%s] favorited at %s' %(self.user, self.added_at)
class AnonymousQuestion(AnonymousContent):
"""question that was asked before logging in
maybe the name is a little misleading, the user still
may or may not want to stay anonymous after the question
is published
"""
title = models.CharField(max_length=300)
tagnames = models.CharField(max_length=125)
is_anonymous = models.BooleanField(default=False)
def publish(self,user):
added_at = datetime.datetime.now()
Question.objects.create_new(
title = self.title,
added_at = added_at,
author = user,
wiki = self.wiki,
is_anonymous = self.is_anonymous,
tagnames = self.tagnames,
text = self.text,
)
self.delete()
|