u/bodqhrohro/swineboard Files · boards/management/commands/cleantags.py

Limit only first posting by this session. Assume messages created by spam bots...

Limit only first posting by this session. Assume messages created by spam bots can be removed afterwards

neko259 - - Load All Authors

File last commit:

r1404:fabf89e8 default


                r1494:89a50a1d

default

Download file

             cleantags.py
        
                    19 lines
            
             | 540 B
            
                | text/x-python
            
             |
                PythonLexer
            
             / boards / management / commands / cleantags.py
          
                    History
                
                 |
                  Annotation
                 | Raw
                 |Copy content
                 |Copy permalink

      from django.core.management import BaseCommand

      from django.db import transaction

      from django.db.models import Count

      from boards.models import Tag

      __author__ = 'neko259'

      class Command(BaseCommand):

          help = 'Removed tags that have no threads'

          @transaction.atomic

          def handle(self, *args, **options):

              empty = Tag.objects.annotate(num_threads=Count('thread_tags'))\

                      .filter(num_threads=0).order_by('-required', 'name')

              print('Removing {} empty tags'.format(empty.count()))

              empty.delete()

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages

				from django.core.management import BaseCommand
				from django.db import transaction
				from django.db.models import Count

				from boards.models import Tag


				__author__ = 'neko259'


				class Command(BaseCommand):
				help = 'Removed tags that have no threads'

				@transaction.atomic
				def handle(self, args, *options):
				empty = Tag.objects.annotate(num_threads=Count('thread_tags'))\
				.filter(num_threads=0).order_by('-required', 'name')
				print('Removing {} empty tags'.format(empty.count()))
				empty.delete()