##// 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 1 from django.template.loader import render_to_string
2 2 from django.db import models
3 3 from django.db.models import Count
4 4 from django.core.urlresolvers import reverse
5 5
6 6 from boards.models.base import Viewable
7 7 from boards.utils import cached_result
8 8
9 9
10 10 __author__ = 'neko259'
11 11
12 12
13 13 class TagManager(models.Manager):
14 14
15 15 def get_not_empty_tags(self):
16 16 """
17 17 Gets tags that have non-archived threads.
18 18 """
19 19
20 20 return self.filter(thread__archived=False)\
21 21 .annotate(num_threads=Count('thread')).filter(num_threads__gt=0)\
22 22 .order_by('-required', 'name')
23 23
24 24
25 25 class Tag(models.Model, Viewable):
26 26 """
27 27 A tag is a text node assigned to the thread. The tag serves as a board
28 28 section. There can be multiple tags for each thread
29 29 """
30 30
31 31 objects = TagManager()
32 32
33 33 class Meta:
34 34 app_label = 'boards'
35 35 ordering = ('name',)
36 36
37 name = models.CharField(max_length=100, db_index=True)
38 required = models.BooleanField(default=False)
37 name = models.CharField(max_length=100, db_index=True, unique=True)
38 required = models.BooleanField(default=False, db_index=True)
39 39
40 40 def __str__(self):
41 41 return self.name
42 42
43 43 def is_empty(self) -> bool:
44 44 """
45 45 Checks if the tag has some threads.
46 46 """
47 47
48 48 return self.get_thread_count() == 0
49 49
50 50 def get_thread_count(self) -> int:
51 51 return self.get_threads().count()
52 52
53 53 def get_url(self):
54 54 return reverse('tag', kwargs={'tag_name': self.name})
55 55
56 56 def get_threads(self):
57 57 return self.thread_set.order_by('-bump_time')
58 58
59 59 def is_required(self):
60 60 return self.required
61 61
62 62 def get_view(self):
63 63 link = '<a class="tag" href="{}">{}</a>'.format(
64 64 self.get_url(), self.name)
65 65 if self.is_required():
66 66 link = '<b>{}</b>'.format(link)
67 67 return link
68 68
69 69 def get_search_view(self, *args, **kwargs):
70 70 return render_to_string('boards/tag.html', {
71 71 'tag': self,
72 72 })
73 73
74 74 @cached_result
75 75 def get_post_count(self):
76 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