models.py
329 lines
| 9.2 KiB
| text/x-python
|
PythonLexer
/ boards / models.py
neko259
|
r29 | import os | ||
neko259
|
r50 | from random import random | ||
neko259
|
r31 | import re | ||
neko259
|
r29 | import time | ||
neko259
|
r46 | import math | ||
neko259
|
r71 | |||
from django.db import models | ||||
from django.http import Http404 | ||||
from django.utils import timezone | ||||
from markupfield.fields import MarkupField | ||||
wnc_21
|
r95 | from threading import Thread | ||
neko259
|
r4 | |||
neko259
|
r22 | from neboard import settings | ||
neko259
|
r71 | import thumbs | ||
neko259
|
r22 | |||
neko259
|
r79 | IMAGE_THUMB_SIZE = (200, 150) | ||
TITLE_MAX_LENGTH = 50 | ||||
DEFAULT_MARKUP_TYPE = 'markdown' | ||||
neko259
|
r22 | |||
neko259
|
r4 | NO_PARENT = -1 | ||
NO_IP = '0.0.0.0' | ||||
UNKNOWN_UA = '' | ||||
neko259
|
r71 | ALL_PAGES = -1 | ||
neko259
|
r85 | OPENING_POST_POPULARITY_WEIGHT = 2 | ||
neko259
|
r71 | IMAGES_DIRECTORY = 'images/' | ||
FILE_EXTENSION_DELIMITER = '.' | ||||
neko259
|
r112 | RANK_ADMIN = 0 | ||
RANK_MODERATOR = 10 | ||||
RANK_USER = 100 | ||||
neko259
|
r0 | |||
neko259
|
r143 | |||
neko259
|
r2 | class PostManager(models.Manager): | ||
neko259
|
r22 | def create_post(self, title, text, image=None, parent_id=NO_PARENT, | ||
neko259
|
r113 | ip=NO_IP, tags=None, user=None): | ||
neko259
|
r22 | post = self.create(title=title, | ||
text=text, | ||||
pub_time=timezone.now(), | ||||
parent=parent_id, | ||||
image=image, | ||||
poster_ip=ip, | ||||
neko259
|
r25 | poster_user_agent=UNKNOWN_UA, | ||
neko259
|
r113 | last_edit_time=timezone.now(), | ||
user=user) | ||||
neko259
|
r0 | |||
neko259
|
r24 | if tags: | ||
neko259
|
r79 | map(post.tags.add, tags) | ||
neko259
|
r24 | |||
neko259
|
r25 | if parent_id != NO_PARENT: | ||
neko259
|
r38 | self._bump_thread(parent_id) | ||
neko259
|
r28 | else: | ||
self._delete_old_threads() | ||||
neko259
|
r25 | |||
neko259
|
r1 | return post | ||
neko259
|
r0 | |||
def delete_post(self, post): | ||||
neko259
|
r22 | children = self.filter(parent=post.id) | ||
neko259
|
r147 | |||
map(self.delete_post, children) | ||||
neko259
|
r2 | post.delete() | ||
neko259
|
r0 | def delete_posts_by_ip(self, ip): | ||
neko259
|
r22 | posts = self.filter(poster_ip=ip) | ||
neko259
|
r147 | map(self.delete_post, posts) | ||
neko259
|
r0 | |||
neko259
|
r87 | def get_threads(self, tag=None, page=ALL_PAGES, | ||
order_by='-last_edit_time'): | ||||
neko259
|
r27 | if tag: | ||
threads = self.filter(parent=NO_PARENT, tags=tag) | ||||
neko259
|
r87 | |||
# TODO Throw error 404 if no threads for tag found? | ||||
neko259
|
r27 | else: | ||
neko259
|
r22 | threads = self.filter(parent=NO_PARENT) | ||
neko259
|
r79 | |||
neko259
|
r87 | threads = threads.order_by(order_by) | ||
neko259
|
r5 | |||
neko259
|
r71 | if page != ALL_PAGES: | ||
neko259
|
r46 | thread_count = len(threads) | ||
if page < self.get_thread_page_count(tag=tag): | ||||
start_thread = page * settings.THREADS_PER_PAGE | ||||
end_thread = min(start_thread + settings.THREADS_PER_PAGE, | ||||
thread_count) | ||||
threads = threads[start_thread:end_thread] | ||||
neko259
|
r5 | return threads | ||
def get_thread(self, opening_post_id): | ||||
neko259
|
r79 | try: | ||
neko259
|
r86 | opening_post = self.get(id=opening_post_id, parent=NO_PARENT) | ||
neko259
|
r79 | except Post.DoesNotExist: | ||
neko259
|
r71 | raise Http404 | ||
neko259
|
r33 | if opening_post.parent == NO_PARENT: | ||
replies = self.filter(parent=opening_post_id) | ||||
neko259
|
r5 | |||
neko259
|
r33 | thread = [opening_post] | ||
thread.extend(replies) | ||||
neko259
|
r17 | |||
neko259
|
r33 | return thread | ||
neko259
|
r5 | |||
neko259
|
r8 | def exists(self, post_id): | ||
neko259
|
r22 | posts = self.filter(id=post_id) | ||
neko259
|
r8 | |||
neko259
|
r58 | return posts.count() > 0 | ||
neko259
|
r8 | |||
neko259
|
r46 | def get_thread_page_count(self, tag=None): | ||
if tag: | ||||
threads = self.filter(parent=NO_PARENT, tags=tag) | ||||
else: | ||||
threads = self.filter(parent=NO_PARENT) | ||||
neko259
|
r58 | return int(math.ceil(threads.count() / float( | ||
settings.THREADS_PER_PAGE))) | ||||
neko259
|
r46 | |||
neko259
|
r28 | def _delete_old_threads(self): | ||
""" | ||||
Preserves maximum thread count. If there are too many threads, | ||||
delete the old ones. | ||||
""" | ||||
# TODO Move old threads to the archive instead of deleting them. | ||||
# Maybe make some 'old' field in the model to indicate the thread | ||||
# must not be shown and be able for replying. | ||||
threads = self.get_threads() | ||||
thread_count = len(threads) | ||||
if thread_count > settings.MAX_THREAD_COUNT: | ||||
num_threads_to_delete = thread_count - settings.MAX_THREAD_COUNT | ||||
neko259
|
r58 | old_threads = threads[thread_count - num_threads_to_delete:] | ||
neko259
|
r28 | |||
neko259
|
r147 | map(self.delete_post, old_threads) | ||
neko259
|
r28 | |||
neko259
|
r38 | def _bump_thread(self, thread_id): | ||
thread = self.get(id=thread_id) | ||||
neko259
|
r46 | if thread.can_bump(): | ||
neko259
|
r38 | thread.last_edit_time = timezone.now() | ||
thread.save() | ||||
neko259
|
r5 | |||
neko259
|
r33 | class TagManager(models.Manager): | ||
def get_not_empty_tags(self): | ||||
neko259
|
r34 | all_tags = self.all().order_by('name') | ||
neko259
|
r33 | tags = [] | ||
for tag in all_tags: | ||||
if not tag.is_empty(): | ||||
tags.append(tag) | ||||
return tags | ||||
neko259
|
r57 | def get_popular_tags(self): | ||
all_tags = self.get_not_empty_tags() | ||||
sorted_tags = sorted(all_tags, key=lambda tag: tag.get_popularity(), | ||||
reverse=True) | ||||
return sorted_tags[:settings.POPULAR_TAGS] | ||||
neko259
|
r33 | |||
neko259
|
r4 | class Tag(models.Model): | ||
""" | ||||
A tag is a text node assigned to the post. The tag serves as a board | ||||
section. There can be multiple tags for each message | ||||
""" | ||||
neko259
|
r33 | objects = TagManager() | ||
neko259
|
r22 | name = models.CharField(max_length=100) | ||
neko259
|
r4 | |||
neko259
|
r31 | def __unicode__(self): | ||
return self.name | ||||
neko259
|
r32 | def is_empty(self): | ||
neko259
|
r33 | return self.get_post_count() == 0 | ||
def get_post_count(self): | ||||
neko259
|
r32 | posts_with_tag = Post.objects.get_threads(tag=self) | ||
neko259
|
r58 | return posts_with_tag.count() | ||
neko259
|
r32 | |||
neko259
|
r57 | def get_popularity(self): | ||
posts_with_tag = Post.objects.get_threads(tag=self) | ||||
reply_count = 0 | ||||
for post in posts_with_tag: | ||||
reply_count += post.get_reply_count() | ||||
neko259
|
r85 | reply_count += OPENING_POST_POPULARITY_WEIGHT | ||
neko259
|
r57 | |||
return reply_count | ||||
neko259
|
r8 | |||
neko259
|
r2 | class Post(models.Model): | ||
neko259
|
r4 | """A post is a message.""" | ||
neko259
|
r0 | |||
neko259
|
r2 | objects = PostManager() | ||
neko259
|
r0 | |||
neko259
|
r50 | def _update_image_filename(self, filename): | ||
"""Get unique image filename""" | ||||
neko259
|
r71 | path = IMAGES_DIRECTORY | ||
neko259
|
r50 | new_name = str(int(time.mktime(time.gmtime()))) | ||
new_name += str(int(random() * 1000)) | ||||
neko259
|
r71 | new_name += FILE_EXTENSION_DELIMITER | ||
new_name += filename.split(FILE_EXTENSION_DELIMITER)[-1:][0] | ||||
neko259
|
r50 | |||
return os.path.join(path, new_name) | ||||
neko259
|
r79 | title = models.CharField(max_length=TITLE_MAX_LENGTH) | ||
neko259
|
r2 | pub_time = models.DateTimeField() | ||
neko259
|
r79 | text = MarkupField(default_markup_type=DEFAULT_MARKUP_TYPE, | ||
neko259
|
r90 | escape_html=False) | ||
neko259
|
r127 | |||
neko259
|
r129 | image_width = models.IntegerField(default=0) | ||
image_height = models.IntegerField(default=0) | ||||
neko259
|
r127 | |||
neko259
|
r50 | image = thumbs.ImageWithThumbsField(upload_to=_update_image_filename, | ||
neko259
|
r127 | blank=True, sizes=(IMAGE_THUMB_SIZE,), | ||
width_field='image_width', | ||||
height_field='image_height') | ||||
neko259
|
r116 | poster_ip = models.GenericIPAddressField() | ||
neko259
|
r2 | poster_user_agent = models.TextField() | ||
parent = models.BigIntegerField() | ||||
neko259
|
r7 | tags = models.ManyToManyField(Tag) | ||
neko259
|
r25 | last_edit_time = models.DateTimeField() | ||
neko259
|
r140 | user = models.ForeignKey('User', null=True, default=None) | ||
neko259
|
r0 | |||
def __unicode__(self): | ||||
Pavel Ryapolov
|
r105 | return '#' + str(self.id) + ' ' + self.title + ' (' + \ | ||
neko259
|
r127 | self.text.raw[:50] + ')' | ||
Ilyas
|
r9 | |||
neko259
|
r147 | def get_title(self): | ||
title = self.title | ||||
if len(title) == 0: | ||||
title = self.text.raw[:20] | ||||
return title | ||||
neko259
|
r30 | def _get_replies(self): | ||
return Post.objects.filter(parent=self.id) | ||||
def get_reply_count(self): | ||||
neko259
|
r58 | return self._get_replies().count() | ||
neko259
|
r30 | |||
def get_images_count(self): | ||||
images_count = 1 if self.image else 0 | ||||
for reply in self._get_replies(): | ||||
if reply.image: | ||||
images_count += 1 | ||||
return images_count | ||||
neko259
|
r46 | def can_bump(self): | ||
"""Check if the thread can be bumped by replying""" | ||||
replies_count = len(Post.objects.get_thread(self.id)) | ||||
return replies_count <= settings.MAX_POSTS_PER_THREAD | ||||
neko259
|
r31 | |||
neko259
|
r59 | def get_last_replies(self): | ||
if settings.LAST_REPLIES_COUNT > 0: | ||||
reply_count = self.get_reply_count() | ||||
if reply_count > 0: | ||||
reply_count_to_show = min(settings.LAST_REPLIES_COUNT, | ||||
reply_count) | ||||
last_replies = self._get_replies()[reply_count | ||||
- reply_count_to_show:] | ||||
return last_replies | ||||
Ilyas
|
r9 | |||
neko259
|
r121 | class User(models.Model): | ||
user_id = models.CharField(max_length=50) | ||||
rank = models.IntegerField() | ||||
registration_time = models.DateTimeField() | ||||
last_access_time = models.DateTimeField() | ||||
neko259
|
r144 | fav_tags = models.ManyToManyField(Tag, null=True, blank=True) | ||
fav_threads = models.ManyToManyField(Post, related_name='+', null=True, | ||||
blank=True) | ||||
neko259
|
r121 | |||
def save_setting(self, name, value): | ||||
setting, created = Setting.objects.get_or_create(name=name, user=self) | ||||
setting.value = value | ||||
setting.save() | ||||
return setting | ||||
def get_setting(self, name): | ||||
settings = Setting.objects.filter(name=name, user=self) | ||||
if len(settings) > 0: | ||||
setting = settings[0] | ||||
else: | ||||
setting = None | ||||
if setting: | ||||
setting_value = setting.value | ||||
else: | ||||
setting_value = None | ||||
return setting_value | ||||
def is_moderator(self): | ||||
return RANK_MODERATOR >= self.rank | ||||
Ilyas
|
r9 | |||
neko259
|
r149 | def get_sorted_fav_tags(self): | ||
return self.fav_tags.order_by('name') | ||||
Ilyas
|
r9 | def __unicode__(self): | ||
neko259
|
r147 | return self.user_id + '(' + self.rank + ')' | ||
neko259
|
r110 | |||
neko259
|
r140 | |||
neko259
|
r112 | class Setting(models.Model): | ||
neko259
|
r116 | |||
neko259
|
r112 | name = models.CharField(max_length=50) | ||
value = models.CharField(max_length=50) | ||||
user = models.ForeignKey(User) | ||||
neko259
|
r116 | |||
neko259
|
r144 | |||
neko259
|
r116 | class Ban(models.Model): | ||
ip = models.GenericIPAddressField() | ||||
def __unicode__(self): | ||||
return self.ip | ||||