##// END OF EJS Templates
Made tag name field unique. Added index to "required" field for tag
neko259 -
r983:c3e4aa3e default
parent child Browse files
Show More
@@ -0,0 +1,44 b''
1 # -*- coding: utf-8 -*-
2 from __future__ import unicode_literals
3
4 from django.db import models, migrations
5
6
7 class Migration(migrations.Migration):
8
9 def clean_duplicate_tags(apps, schema_editor):
10 Tag = apps.get_model('boards', 'Tag')
11 for tag in Tag.objects.all():
12 tags_with_same_name = Tag.objects.filter(name=tag.name).all()
13 if len(tags_with_same_name) > 1:
14 for tag_duplicate in tags_with_same_name[1:]:
15 threads = tag_duplicate.thread_set.all()
16 for thread in threads:
17 thread.tags.add(tag)
18 tag_duplicate.delete()
19
20 dependencies = [
21 ('boards', '0009_post_thread'),
22 ]
23
24 operations = [
25 migrations.AlterField(
26 model_name='post',
27 name='thread',
28 field=models.ForeignKey(to='boards.Thread', related_name='pt+'),
29 preserve_default=True,
30 ),
31 migrations.RunPython(clean_duplicate_tags),
32 migrations.AlterField(
33 model_name='tag',
34 name='name',
35 field=models.CharField(db_index=True, unique=True, max_length=100),
36 preserve_default=True,
37 ),
38 migrations.AlterField(
39 model_name='tag',
40 name='required',
41 field=models.BooleanField(db_index=True, default=False),
42 preserve_default=True,
43 ),
44 ]
@@ -1,76 +1,76 b''
1 from django.template.loader import render_to_string
1 from django.template.loader import render_to_string
2 from django.db import models
2 from django.db import models
3 from django.db.models import Count
3 from django.db.models import Count
4 from django.core.urlresolvers import reverse
4 from django.core.urlresolvers import reverse
5
5
6 from boards.models.base import Viewable
6 from boards.models.base import Viewable
7 from boards.utils import cached_result
7 from boards.utils import cached_result
8
8
9
9
10 __author__ = 'neko259'
10 __author__ = 'neko259'
11
11
12
12
13 class TagManager(models.Manager):
13 class TagManager(models.Manager):
14
14
15 def get_not_empty_tags(self):
15 def get_not_empty_tags(self):
16 """
16 """
17 Gets tags that have non-archived threads.
17 Gets tags that have non-archived threads.
18 """
18 """
19
19
20 return self.filter(thread__archived=False)\
20 return self.filter(thread__archived=False)\
21 .annotate(num_threads=Count('thread')).filter(num_threads__gt=0)\
21 .annotate(num_threads=Count('thread')).filter(num_threads__gt=0)\
22 .order_by('-required', 'name')
22 .order_by('-required', 'name')
23
23
24
24
25 class Tag(models.Model, Viewable):
25 class Tag(models.Model, Viewable):
26 """
26 """
27 A tag is a text node assigned to the thread. The tag serves as a board
27 A tag is a text node assigned to the thread. The tag serves as a board
28 section. There can be multiple tags for each thread
28 section. There can be multiple tags for each thread
29 """
29 """
30
30
31 objects = TagManager()
31 objects = TagManager()
32
32
33 class Meta:
33 class Meta:
34 app_label = 'boards'
34 app_label = 'boards'
35 ordering = ('name',)
35 ordering = ('name',)
36
36
37 name = models.CharField(max_length=100, db_index=True)
37 name = models.CharField(max_length=100, db_index=True, unique=True)
38 required = models.BooleanField(default=False)
38 required = models.BooleanField(default=False, db_index=True)
39
39
40 def __str__(self):
40 def __str__(self):
41 return self.name
41 return self.name
42
42
43 def is_empty(self) -> bool:
43 def is_empty(self) -> bool:
44 """
44 """
45 Checks if the tag has some threads.
45 Checks if the tag has some threads.
46 """
46 """
47
47
48 return self.get_thread_count() == 0
48 return self.get_thread_count() == 0
49
49
50 def get_thread_count(self) -> int:
50 def get_thread_count(self) -> int:
51 return self.get_threads().count()
51 return self.get_threads().count()
52
52
53 def get_url(self):
53 def get_url(self):
54 return reverse('tag', kwargs={'tag_name': self.name})
54 return reverse('tag', kwargs={'tag_name': self.name})
55
55
56 def get_threads(self):
56 def get_threads(self):
57 return self.thread_set.order_by('-bump_time')
57 return self.thread_set.order_by('-bump_time')
58
58
59 def is_required(self):
59 def is_required(self):
60 return self.required
60 return self.required
61
61
62 def get_view(self):
62 def get_view(self):
63 link = '<a class="tag" href="{}">{}</a>'.format(
63 link = '<a class="tag" href="{}">{}</a>'.format(
64 self.get_url(), self.name)
64 self.get_url(), self.name)
65 if self.is_required():
65 if self.is_required():
66 link = '<b>{}</b>'.format(link)
66 link = '<b>{}</b>'.format(link)
67 return link
67 return link
68
68
69 def get_search_view(self, *args, **kwargs):
69 def get_search_view(self, *args, **kwargs):
70 return render_to_string('boards/tag.html', {
70 return render_to_string('boards/tag.html', {
71 'tag': self,
71 'tag': self,
72 })
72 })
73
73
74 @cached_result
74 @cached_result
75 def get_post_count(self):
75 def get_post_count(self):
76 return self.get_threads().aggregate(num_posts=Count('post'))['num_posts']
76 return self.get_threads().aggregate(num_posts=Count('post'))['num_posts']
General Comments 0
You need to be logged in to leave comments. Login now