postmodel.py 8.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237
  1. import copy
  2. from django.db import models
  3. from django.db.models import F
  4. from django.db.models.signals import pre_save, pre_delete
  5. from django.utils import timezone
  6. from django.utils.translation import ugettext_lazy as _
  7. from misago.markdown import clear_markdown
  8. from misago.signals import (delete_user_content, merge_post, merge_thread,
  9. move_forum_content, move_post, move_thread,
  10. rename_user, sync_user_profile)
  11. from misago.utils.translation import ugettext_lazy
  12. import base64
  13. try:
  14. import cPickle as pickle
  15. except ImportError:
  16. import pickle
  17. class PostManager(models.Manager):
  18. def filter_stats(self, start, end):
  19. return self.filter(date__gte=start).filter(date__lte=end)
  20. class Post(models.Model):
  21. forum = models.ForeignKey('Forum')
  22. thread = models.ForeignKey('Thread')
  23. user = models.ForeignKey('User', null=True, blank=True, on_delete=models.SET_NULL)
  24. user_name = models.CharField(max_length=255)
  25. ip = models.GenericIPAddressField()
  26. agent = models.CharField(max_length=255)
  27. post = models.TextField()
  28. post_preparsed = models.TextField()
  29. upvotes = models.PositiveIntegerField(default=0)
  30. downvotes = models.PositiveIntegerField(default=0)
  31. mentions = models.ManyToManyField('User', related_name="mention_set")
  32. date = models.DateTimeField()
  33. current_date = models.DateTimeField(db_index=True)
  34. edits = models.PositiveIntegerField(default=0)
  35. edit_reason = models.CharField(max_length=255, null=True, blank=True)
  36. edit_user = models.ForeignKey('User', related_name='+', null=True, blank=True, on_delete=models.SET_NULL)
  37. edit_user_name = models.CharField(max_length=255, null=True, blank=True)
  38. edit_user_slug = models.SlugField(max_length=255, null=True, blank=True)
  39. delete_date = models.DateTimeField(null=True, blank=True)
  40. reported = models.BooleanField(default=False, db_index=True)
  41. reports = models.CharField(max_length=255, null=True, blank=True)
  42. moderated = models.BooleanField(default=False)
  43. deleted = models.BooleanField(default=False)
  44. protected = models.BooleanField(default=False)
  45. has_attachments = models.BooleanField(default=False)
  46. _attachments = models.TextField(db_column='attachments', null=True, blank=True)
  47. objects = PostManager()
  48. statistics_name = _('New Posts')
  49. class Meta:
  50. app_label = 'misago'
  51. @property
  52. def attachments(self):
  53. if not self.has_attachments:
  54. return []
  55. try:
  56. return self._attachments_cache
  57. except AttributeError:
  58. pass
  59. try:
  60. self._attachments_cache = pickle.loads(base64.decodestring(self._attachments))
  61. except Exception:
  62. self._attachments_cache = []
  63. return self._attachments_cache
  64. @attachments.setter
  65. def attachments(self, new_attachments):
  66. if new_attachments:
  67. self._update_attachments_store(new_attachments)
  68. else:
  69. self._empty_attachments_store()
  70. def _empty_attachments_store(self):
  71. self.has_attachments = False
  72. self._attachments = None
  73. def _update_attachments_store(self, new_attachments):
  74. self.has_attachments = True
  75. clean_attachments = []
  76. for attachment in new_attachments:
  77. attachment = copy.copy(attachment)
  78. attachment_user_pk = attachment.user_id
  79. attachment.user = None
  80. attachment.user_id = attachment_user_pk
  81. attachment.forum = None
  82. attachment.thread = None
  83. attachment.post = None
  84. clean_attachments.append(attachment)
  85. self._attachments = base64.encodestring(pickle.dumps(clean_attachments, pickle.HIGHEST_PROTOCOL))
  86. @property
  87. def timeline_date(self):
  88. return self.date
  89. def save(self, *args, **kwargs):
  90. self.current_date = timezone.now()
  91. return super(Post, self).save(*args, **kwargs)
  92. def delete(self, *args, **kwargs):
  93. """
  94. FUGLY HAX for weird stuff that happens with
  95. relations on model deletion in MySQL
  96. """
  97. if self.reported:
  98. self.report_set.update(report_for=None)
  99. return super(Post, self).delete(*args, **kwargs)
  100. def get_date(self):
  101. return self.date
  102. def quote(self):
  103. quote = []
  104. quote.append('@%s' % self.user_name)
  105. for line in self.post.splitlines():
  106. quote.append('> %s' % line)
  107. quote.append('\r\n')
  108. return '\r\n'.join(quote)
  109. @property
  110. def post_clean(self):
  111. return clear_markdown(self.post_preparsed)
  112. def move_to(self, thread):
  113. move_post.send(sender=self, move_to=thread)
  114. self.thread = thread
  115. self.forum = thread.forum
  116. def merge_with(self, post):
  117. post.post = '%s\n- - -\n%s' % (post.post, self.post)
  118. merge_post.send(sender=self, new_post=post)
  119. def notify_mentioned(self, request, thread_type, users):
  120. from misago.acl.builder import acl as build_acl
  121. from misago.acl.exceptions import ACLError403, ACLError404
  122. mentioned = self.mentions.all()
  123. for slug, user in users.items():
  124. if user.pk != request.user.pk and user not in mentioned:
  125. self.mentions.add(user)
  126. try:
  127. user_acl = build_acl(request, user)
  128. user_acl.forums.allow_forum_view(self.forum)
  129. user_acl.threads.allow_thread_view(user, self.thread)
  130. user_acl.threads.allow_post_view(user, self.thread, self)
  131. if not user.is_ignoring(request.user):
  132. alert = user.alert(ugettext_lazy("%(username)s has mentioned you in his reply in thread %(thread)s").message)
  133. alert.profile('username', request.user)
  134. alert.post('thread', thread_type, self.thread, self)
  135. alert.save_all()
  136. except (ACLError403, ACLError404):
  137. pass
  138. def is_reported(self):
  139. self.reported = self.report_set.filter(weight=2).count() > 0
  140. def live_report(self):
  141. try:
  142. return self.report_set.filter(weight=2)[0]
  143. except IndexError:
  144. return None
  145. def add_reporter(self, user):
  146. if not self.reports:
  147. self.reports = ','
  148. self.reports += '%s,' % user.pk
  149. def reported_by(self, user):
  150. if not self.reports:
  151. return False
  152. try:
  153. return ',%s,' % user.pk in self.reports
  154. except AttributeError:
  155. return ',%s,' % user in self.reports
  156. def rename_user_handler(sender, **kwargs):
  157. Post.objects.filter(user=sender).update(
  158. user_name=sender.username,
  159. current_date=timezone.now(),
  160. )
  161. Post.objects.filter(edit_user=sender).update(
  162. edit_user_name=sender.username,
  163. edit_user_slug=sender.username_slug,
  164. )
  165. rename_user.connect(rename_user_handler, dispatch_uid="rename_user_posts")
  166. def delete_user_content_handler(sender, **kwargs):
  167. from misago.models import Thread
  168. threads = []
  169. for post in sender.post_set.distinct().values('thread_id').iterator():
  170. if not post['thread_id'] in threads:
  171. threads.append(post['thread_id'])
  172. sender.post_set.all().delete()
  173. for thread in Thread.objects.filter(id__in=threads):
  174. thread.sync()
  175. thread.save(force_update=True)
  176. delete_user_content.connect(delete_user_content_handler, dispatch_uid="delete_user_posts")
  177. def move_forum_content_handler(sender, **kwargs):
  178. Post.objects.filter(forum=sender).update(forum=kwargs['move_to'])
  179. move_forum_content.connect(move_forum_content_handler, dispatch_uid="move_forum_posts")
  180. def move_thread_handler(sender, **kwargs):
  181. Post.objects.filter(thread=sender).update(forum=kwargs['move_to'])
  182. move_thread.connect(move_thread_handler, dispatch_uid="move_thread_posts")
  183. def merge_thread_handler(sender, **kwargs):
  184. Post.objects.filter(thread=sender).update(thread=kwargs['new_thread'])
  185. merge_thread.connect(merge_thread_handler, dispatch_uid="merge_threads_posts")
  186. def sync_user_handler(sender, **kwargs):
  187. sender.posts = sender.post_set.count()
  188. sync_user_profile.connect(sync_user_handler, dispatch_uid="sync_user_posts")