count_positions_occurrences.py 3.05 KB
#-*- coding:utf-8 -*-
# author: B.Niton

#Copyright (c) 2014, Bartłomiej Nitoń
#All rights reserved.

#Redistribution and use in source and binary forms, with or without modification, are permitted provided 
#that the following conditions are met:

#    Redistributions of source code must retain the above copyright notice, this list of conditions and 
#    the following disclaimer.
#    Redistributions in binary form must reproduce the above copyright notice, this list of conditions 
#    and the following disclaimer in the documentation and/or other materials provided with the distribution.

# THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED 
# WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A 
# PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE FOR 
# ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED 
# TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) 
# HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING 
# NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE 
# POSSIBILITY OF SUCH DAMAGE.

from django.core.management.base import BaseCommand
from django.db import transaction
from django.db.models import Q

from dictionary.models import Lemma, Position

class Command(BaseCommand):
    help = 'Count positions occurrences in SloVal.'

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

@transaction.commit_on_success
def count_positions_occurrences():
    positions_ls = []
    lemmas = Lemma.objects.filter(Q(status__type__sym_name=u'ready') |
                                  Q(status__type__sym_name=u'checked') |
                                  Q(status__type__sym_name=u'edit_f') |
                                  Q(status__type__sym_name=u'ready_f') |
                                  Q(status__type__sym_name=u'checked_f')|
                                  Q(status__type__sym_name=u'edit_s') |
                                  Q(status__type__sym_name=u'ready_s') |
                                  Q(status__type__sym_name=u'checked_s')).filter(old=False).order_by('entry')
    print 'Finding positions.'
    for position in Position.objects.all():
        positions_ls.append({'pos_obj': position,
                             'occurrences': 0})
    print 'Counting occurrences.'
    for lemma in lemmas.all():
        print lemma
        for frame in lemma.frames.all():
            for position in frame.positions.all():
                for pos in positions_ls:
                    if pos['pos_obj'].text_rep == position.text_rep:
                        pos['occurrences'] += 1              
    print 'Updating positions.'
    for position in positions_ls:
        Position.objects.filter(text_rep=position['pos_obj'].text_rep).update(occurrences=position['occurrences'])