##// END OF EJS Templates
Optimized checking if the user can moderate threads. Linked tags to their threads to optimize getting threads.
Optimized checking if the user can moderate threads. Linked tags to their threads to optimize getting threads.

File last commit:

r182:dfd1566d default
r182:dfd1566d default
Show More
models.py
323 lines | 9.2 KiB | text/x-python | PythonLexer
import os
from random import random
import re
import time
import math
from django.db import models
from django.db.models import Count
from django.http import Http404
from django.utils import timezone
from markupfield.fields import MarkupField
from neboard import settings
import thumbs
IMAGE_THUMB_SIZE = (200, 150)
TITLE_MAX_LENGTH = 50
DEFAULT_MARKUP_TYPE = 'markdown'
NO_PARENT = -1
NO_IP = '0.0.0.0'
UNKNOWN_UA = ''
ALL_PAGES = -1
OPENING_POST_POPULARITY_WEIGHT = 2
IMAGES_DIRECTORY = 'images/'
FILE_EXTENSION_DELIMITER = '.'
RANK_ADMIN = 0
RANK_MODERATOR = 10
RANK_USER = 100
class PostManager(models.Manager):
def create_post(self, title, text, image=None, thread=None,
ip=NO_IP, tags=None, user=None):
post = self.create(title=title,
text=text,
pub_time=timezone.now(),
thread=thread,
image=image,
poster_ip=ip,
poster_user_agent=UNKNOWN_UA,
last_edit_time=timezone.now(),
user=user)
if tags:
map(post.tags.add, tags)
if thread:
thread.replies.add(post)
thread.bump()
else:
self._delete_old_threads()
return post
def delete_post(self, post):
if post.replies.count() > 0:
map(self.delete_post, post.replies.all())
post.delete()
def delete_posts_by_ip(self, ip):
posts = self.filter(poster_ip=ip)
map(self.delete_post, posts)
def get_threads(self, tag=None, page=ALL_PAGES,
order_by='-last_edit_time'):
if tag:
threads = self.filter(thread=None, tags=tag)
# TODO This needs to be uncommented when 'all tags' view won't
# use this method to get threads for tag
# if threads.count() == 0:
# raise Http404
else:
threads = self.filter(thread=None)
threads = threads.order_by(order_by)
if page != ALL_PAGES:
thread_count = threads.count()
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]
return threads
def get_thread(self, opening_post_id):
try:
opening_post = self.get(id=opening_post_id, thread=None)
except Post.DoesNotExist:
raise Http404
if opening_post.replies:
thread = [opening_post]
thread.extend(opening_post.replies.all())
return thread
def exists(self, post_id):
posts = self.filter(id=post_id)
return posts.count() > 0
def get_thread_page_count(self, tag=None):
if tag:
threads = self.filter(thread=None, tags=tag)
else:
threads = self.filter(thread=None)
return int(math.ceil(threads.count() / float(
settings.THREADS_PER_PAGE)))
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
old_threads = threads[thread_count - num_threads_to_delete:]
map(self.delete_post, old_threads)
class TagManager(models.Manager):
def get_not_empty_tags(self):
tags = self.annotate(Count('threads')) \
.filter(threads__count__gt=0).order_by('name')
return tags
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
"""
objects = TagManager()
name = models.CharField(max_length=100)
threads = models.ManyToManyField('Post', null=True,
blank=True, related_name='tag+')
def __unicode__(self):
return self.name
def is_empty(self):
return self.get_post_count() == 0
def get_post_count(self):
return self.threads.count()
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()
reply_count += OPENING_POST_POPULARITY_WEIGHT
return reply_count
class Post(models.Model):
"""A post is a message."""
objects = PostManager()
def _update_image_filename(self, filename):
"""Get unique image filename"""
path = IMAGES_DIRECTORY
new_name = str(int(time.mktime(time.gmtime())))
new_name += str(int(random() * 1000))
new_name += FILE_EXTENSION_DELIMITER
new_name += filename.split(FILE_EXTENSION_DELIMITER)[-1:][0]
return os.path.join(path, new_name)
title = models.CharField(max_length=TITLE_MAX_LENGTH)
pub_time = models.DateTimeField()
text = MarkupField(default_markup_type=DEFAULT_MARKUP_TYPE,
escape_html=False)
image_width = models.IntegerField(default=0)
image_height = models.IntegerField(default=0)
image = thumbs.ImageWithThumbsField(upload_to=_update_image_filename,
blank=True, sizes=(IMAGE_THUMB_SIZE,),
width_field='image_width',
height_field='image_height')
poster_ip = models.GenericIPAddressField()
poster_user_agent = models.TextField()
# TODO Remove this field after everything has been updated to 'thread'
parent = models.BigIntegerField(default=NO_PARENT)
thread = models.ForeignKey('Post', null=True, default=None)
tags = models.ManyToManyField(Tag)
last_edit_time = models.DateTimeField()
user = models.ForeignKey('User', null=True, default=None)
replies = models.ManyToManyField('Post', symmetrical=False, null=True,
blank=True, related_name='re+')
def __unicode__(self):
return '#' + str(self.id) + ' ' + self.title + ' (' + \
self.text.raw[:50] + ')'
def get_title(self):
title = self.title
if len(title) == 0:
title = self.text.raw[:20]
return title
def get_reply_count(self):
return self.replies.count()
def get_images_count(self):
images_count = 1 if self.image else 0
images_count += self.replies.filter(image_width__gt=0).count()
return images_count
def can_bump(self):
"""Check if the thread can be bumped by replying"""
post_count = self.get_reply_count() + 1
return post_count <= settings.MAX_POSTS_PER_THREAD
def bump(self):
"""Bump (move to up) thread"""
if self.can_bump():
self.last_edit_time = timezone.now()
self.save()
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.replies.all()[reply_count -
reply_count_to_show:]
return last_replies
class User(models.Model):
user_id = models.CharField(max_length=50)
rank = models.IntegerField()
registration_time = models.DateTimeField()
last_access_time = models.DateTimeField()
fav_tags = models.ManyToManyField(Tag, null=True, blank=True)
fav_threads = models.ManyToManyField(Post, related_name='+', null=True,
blank=True)
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):
if Setting.objects.filter(name=name, user=self).exists():
setting = Setting.objects.get(name=name, user=self)
setting_value = setting.value
else:
setting_value = None
return setting_value
def is_moderator(self):
return RANK_MODERATOR >= self.rank
def get_sorted_fav_tags(self):
tags = self.fav_tags.annotate(Count('threads'))\
.filter(threads__count__gt=0).order_by('name')
return tags
def __unicode__(self):
return self.user_id + '(' + str(self.rank) + ')'
class Setting(models.Model):
name = models.CharField(max_length=50)
value = models.CharField(max_length=50)
user = models.ForeignKey(User)
class Ban(models.Model):
ip = models.GenericIPAddressField()
def __unicode__(self):
return self.ip