|
|
from django.db import models
|
|
|
from django.db.models import Q
|
|
|
import boards
|
|
|
|
|
|
__author__ = 'neko259'
|
|
|
|
|
|
BAN_REASON_AUTO = 'Auto'
|
|
|
BAN_REASON_MAX_LENGTH = 200
|
|
|
|
|
|
SESSION_KEY_MAX_LENGTH = 100
|
|
|
|
|
|
|
|
|
class Ban(models.Model):
|
|
|
|
|
|
class Meta:
|
|
|
app_label = 'boards'
|
|
|
|
|
|
ip = models.GenericIPAddressField()
|
|
|
reason = models.CharField(default=BAN_REASON_AUTO,
|
|
|
max_length=BAN_REASON_MAX_LENGTH)
|
|
|
can_read = models.BooleanField(default=True)
|
|
|
|
|
|
def __str__(self):
|
|
|
return self.ip
|
|
|
|
|
|
|
|
|
class NotificationManager(models.Manager):
|
|
|
def get_notification_posts(self, usernames: list, last: int = None, user_settings=None):
|
|
|
lower_names = [username.lower() for username in usernames]
|
|
|
posts = boards.models.post.Post.objects.filter(
|
|
|
Q(notification__name__in=lower_names) |
|
|
|
(Q(thread__tags__settings_as_fav=user_settings) & Q(opening=True))).distinct()
|
|
|
if last is not None:
|
|
|
posts = posts.filter(id__gt=last)
|
|
|
posts = posts.order_by('-id')
|
|
|
|
|
|
return posts
|
|
|
|
|
|
|
|
|
class Notification(models.Model):
|
|
|
|
|
|
class Meta:
|
|
|
app_label = 'boards'
|
|
|
|
|
|
objects = NotificationManager()
|
|
|
|
|
|
post = models.ForeignKey('Post', on_delete=models.CASCADE)
|
|
|
name = models.TextField()
|
|
|
|
|
|
|
|
|
class UserSettings(models.Model):
|
|
|
class Meta:
|
|
|
app_label = 'boards'
|
|
|
|
|
|
session_key = models.CharField(max_length=SESSION_KEY_MAX_LENGTH, unique=True)
|
|
|
fav_tags = models.ManyToManyField('Tag', related_name='settings_as_fav')
|
|
|
hidden_tags = models.ManyToManyField('Tag', related_name='settings_as_hidden')
|
|
|
|
