postmodel.py 8.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240
  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. def sync_attachments(self):
  87. self.attachments = self.attachment_set
  88. @property
  89. def timeline_date(self):
  90. return self.date
  91. def save(self, *args, **kwargs):
  92. self.current_date = timezone.now()
  93. return super(Post, self).save(*args, **kwargs)
  94. def delete(self, *args, **kwargs):
  95. """
  96. FUGLY HAX for weird stuff that happens with
  97. relations on model deletion in MySQL
  98. """
  99. if self.reported:
  100. self.report_set.update(report_for=None)
  101. return super(Post, self).delete(*args, **kwargs)
  102. def get_date(self):
  103. return self.date
  104. def quote(self):
  105. quote = []
  106. quote.append('@%s' % self.user_name)
  107. for line in self.post.splitlines():
  108. quote.append('> %s' % line)
  109. quote.append('\r\n')
  110. return '\r\n'.join(quote)
  111. @property
  112. def post_clean(self):
  113. return clear_markdown(self.post_preparsed)
  114. def move_to(self, thread):
  115. move_post.send(sender=self, move_to=thread)
  116. self.thread = thread
  117. self.forum = thread.forum
  118. def merge_with(self, post):
  119. post.post = '%s\n- - -\n%s' % (post.post, self.post)
  120. merge_post.send(sender=self, new_post=post)
  121. def notify_mentioned(self, request, thread_type, users):
  122. from misago.acl.builder import acl as build_acl
  123. from misago.acl.exceptions import ACLError403, ACLError404
  124. mentioned = self.mentions.all()
  125. for slug, user in users.items():
  126. if user.pk != request.user.pk and user not in mentioned:
  127. self.mentions.add(user)
  128. try:
  129. user_acl = build_acl(request, user)
  130. user_acl.forums.allow_forum_view(self.forum)
  131. user_acl.threads.allow_thread_view(user, self.thread)
  132. user_acl.threads.allow_post_view(user, self.thread, self)
  133. if not user.is_ignoring(request.user):
  134. alert = user.alert(ugettext_lazy("%(username)s has mentioned you in his reply in thread %(thread)s").message)
  135. alert.profile('username', request.user)
  136. alert.post('thread', thread_type, self.thread, self)
  137. alert.save_all()
  138. except (ACLError403, ACLError404):
  139. pass
  140. def is_reported(self):
  141. self.reported = self.report_set.filter(weight=2).count() > 0
  142. def live_report(self):
  143. try:
  144. return self.report_set.filter(weight=2)[0]
  145. except IndexError:
  146. return None
  147. def add_reporter(self, user):
  148. if not self.reports:
  149. self.reports = ','
  150. self.reports += '%s,' % user.pk
  151. def reported_by(self, user):
  152. if not self.reports:
  153. return False
  154. try:
  155. return ',%s,' % user.pk in self.reports
  156. except AttributeError:
  157. return ',%s,' % user in self.reports
  158. def rename_user_handler(sender, **kwargs):
  159. Post.objects.filter(user=sender).update(
  160. user_name=sender.username,
  161. current_date=timezone.now(),
  162. )
  163. Post.objects.filter(edit_user=sender).update(
  164. edit_user_name=sender.username,
  165. edit_user_slug=sender.username_slug,
  166. )
  167. rename_user.connect(rename_user_handler, dispatch_uid="rename_user_posts")
  168. def delete_user_content_handler(sender, **kwargs):
  169. from misago.models import Thread
  170. threads = []
  171. for post in sender.post_set.distinct().values('thread_id').iterator():
  172. if not post['thread_id'] in threads:
  173. threads.append(post['thread_id'])
  174. sender.post_set.all().delete()
  175. for thread in Thread.objects.filter(id__in=threads).iterator():
  176. thread.sync()
  177. thread.save(force_update=True)
  178. delete_user_content.connect(delete_user_content_handler, dispatch_uid="delete_user_posts")
  179. def move_forum_content_handler(sender, **kwargs):
  180. Post.objects.filter(forum=sender).update(forum=kwargs['move_to'])
  181. move_forum_content.connect(move_forum_content_handler, dispatch_uid="move_forum_posts")
  182. def move_thread_handler(sender, **kwargs):
  183. Post.objects.filter(thread=sender).update(forum=kwargs['move_to'])
  184. move_thread.connect(move_thread_handler, dispatch_uid="move_thread_posts")
  185. def merge_thread_handler(sender, **kwargs):
  186. Post.objects.filter(thread=sender).update(thread=kwargs['new_thread'])
  187. merge_thread.connect(merge_thread_handler, dispatch_uid="merge_threads_posts")
  188. def sync_user_handler(sender, **kwargs):
  189. sender.posts = sender.post_set.count()
  190. sync_user_profile.connect(sync_user_handler, dispatch_uid="sync_user_posts")