calebasse/scripts/find_duplicate_acts.py @ 3b25faf6
| 3b25faf6 | Benjamin Dauvergne | #!/usr/bin/env python
|
|
import os
|
|||
import datetime as dt
|
|||
from collections import defaultdict
|
|||
if __name__ == "__main__":
|
|||
os.environ.setdefault("DJANGO_SETTINGS_MODULE", "calebasse.settings")
|
|||
from calebasse.actes.validation import get_days_with_acts_not_locked
|
|||
from calebasse.actes.models import Act
|
|||
doubles = defaultdict(lambda: set())
|
|||
days_with_acts_not_locked = get_days_with_acts_not_locked(dt.date(2010,1,1), dt.date.today())
|
|||
acts = Act.objects.filter(date__in=days_with_acts_not_locked) \
|
|||
.order_by('time') \
|
|||
.prefetch_related('doctors')
|
|||
for act in acts:
|
|||
participants_id = [doctor.id for doctor in act.doctors.all()]
|
|||
key = (act.date, act.patient_id, act.act_type_id, tuple(sorted(participants_id)))
|
|||
doubles[key].add(act)
|
|||
for key in doubles.keys():
|
|||
if len(doubles[key]) < 2:
|
|||
del doubles[key]
|
|||
date = None
|
|||
total = 0
|
|||
for key in sorted(doubles.iterkeys()):
|
|||
for act in doubles[key]:
|
|||
if not act.validation_locked:
|
|||
break
|
|||
else:
|
|||
continue
|
|||
if key[0] != date:
|
|||
if date is not None:
|
|||
print
|
|||
date = key[0]
|
|||
print ' = Acte en double le ', date, '='
|
|||
print '{:>6} {:>6} {:>6} {:>6} {:>6}'.format('act_id', 'ev_id', 'exc_id', 'old_id', 'heure')
|
|||
for act in sorted(doubles[key]):
|
|||
total += 1
|
|||
exception_to = ''
|
|||
if act.parent_event:
|
|||
exception_to = act.parent_event.exception_to_id
|
|||
print '%06d' % act.id, '%6s' % act.parent_event_id, '%6s' % exception_to, '%6s' % act.old_id, '%6s' % act.time.strftime('%H:%M'), act, act.validation_locked, act.actvalidationstate_set.all()
|
|||
print
|
|||
print 'Total', total, 'actes'
|