get_cesar_done.py 3.22 KB
#-*- 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
from django.utils.encoding import smart_str

from dictionary.models import Lemma
from accounts.models import RealizedLemma

class Command(BaseCommand):
    args = 'none'
    help = """Adds to lemma status history, change to ready and checked status  
    based on actual lemma form. Also adds to lemma owner lemma realizations 
    information about that the money for this lemma was already paid."""

    def handle(self, **options):
        get_cesar_done()
        
CESAR_VOCABS = ['czas_czasu', 'czas_emotywne', 'czas_komunikacji',
                'czas_mentalne', 'czas_misc1', 'czas_misc2',
                'czas_misc3', 'czas_mowienia', 'czas_operacji',
                'czas_percepcji', 'czas_percepcji2', 'czas_przemieszczenia',
                'frek1', 'frek2']

def get_cesar_done():
    q_status_list = []
    q_status_list.append(Q(status__status=u'sprawdzone'))
    q_vocabs_list = []
    for vocab in CESAR_VOCABS:
        q_vocabs_list.append(Q(vocabulary__name=vocab))
    lemmas = Lemma.objects.filter(old=False).filter(reduce(operator.or_, 
                                                           q_status_list)).filter(reduce(operator.or_, 
                                                           q_vocabs_list))
    for lemma in lemmas.all():
        checked_stat_changes = lemma.status_history.filter(status__status=u'sprawdzone')
        ready_stat_changes = lemma.status_history.filter(status__status=u'gotowe')
        if (checked_stat_changes.count() > 0 and ready_stat_changes.count() > 0 
            and RealizedLemma.objects.filter(lemma__entry=lemma.entry,
                                             lemma__vocabulary=lemma.vocabulary,
                                             paid=True).count() == 0):
            print smart_str(lemma.vocabulary.name) + ': ' + smart_str(lemma.entry)