#-*- coding:utf-8 -*- #Copyright (c) 2012, 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. import operator from django.core.management.base import BaseCommand from django.db.models import Q, Max, Count from django.utils.encoding import smart_str from dictionary.models import Lemma class Command(BaseCommand): args = 'none' help = 'Get flat and big frames count from ready and checked frames.' def handle(self, **options): frames_count() def frames_count(): q_status_list = [] q_status_list.append(Q(status__status=u'gotowe')) q_status_list.append(Q(status__status=u'sprawdzone')) lemmas = Lemma.objects.filter(old=False).filter(reduce(operator.or_, q_status_list)) big_frames = 0 flat_frames = 0 for lemma in lemmas.all(): print smart_str(lemma.entry) big_frames += lemma.frames.count() print lemma.frames.count() for frame in lemma.frames.all(): max_args = frame.positions.annotate(num_args=Count('arguments')).aggregate(Max('num_args'))['num_args__max'] flat_frames += max_args big_frames = float(big_frames) flat_frames = float(flat_frames) print 'big_frames: ' + str(big_frames) print 'flat_frames: ' + str(flat_frames) print str(flat_frames/big_frames)