Код проверки: verify.py
"""Python 3.9+, standard library. Run in the directory containing requests.csv."""
import csv
from pathlib import Path
from datetime import date, datetime
from collections import Counter
def summarize(rows):
latest = {}
seen_versions = {}
for row in rows:
if not row.get('id') or not row.get('updated'):
raise ValueError('Missing identifier or update time')
moment = datetime.fromisoformat(row['updated'])
version_key = (row['id'], moment)
if version_key in seen_versions and row != seen_versions[version_key]:
raise ValueError('Conflicting historical or latest versions')
seen_versions[version_key] = row.copy()
prior = latest.get(row['id'])
if prior and moment == datetime.fromisoformat(prior['updated']) and row != prior:
raise ValueError('Conflicting versions at the same time')
if prior is None or moment > datetime.fromisoformat(prior['updated']):
latest[row['id']] = row.copy()
counts = Counter(r['status'] for r in latest.values())
durations, missing = [], []
for row in latest.values():
if row['status'] != 'closed':
continue
if not row.get('opened') or not row.get('closed'):
missing.append(row['id'])
continue
days = (date.fromisoformat(row['closed']) - date.fromisoformat(row['opened'])).days
if days < 0:
raise ValueError('Closing date before opening date')
durations.append(days)
return {'unique':len(latest),'statuses':dict(counts),'valid_closed':len(durations),
'missing_dates':sorted(missing),'mean_days':sum(durations)/len(durations) if durations else None}
if __name__ == '__main__':
with Path(__file__).with_name('requests.csv').open(newline='') as f:
rows = list(csv.DictReader(f))
result = summarize(rows)
assert result == {'unique':6,'statuses':{'closed':3,'open':2,'waiting':1},'valid_closed':2,'missing_dates':['5'],'mean_days':2.0}
assert summarize([])['mean_days'] is None
assert summarize(rows + [rows[0]]) == result
assert summarize(list(reversed(rows))) == result
def rejects(data):
try:summarize(data)
except ValueError:return
raise AssertionError('Invalid input accepted')
rejects([dict(rows[0],id='')])
rejects([dict(rows[0],closed='2026-09-01')])
rejects([rows[0],dict(rows[0],status='open')])
later = dict(rows[0], updated='2026-10-07T15:00')
old_open = dict(rows[0], status='open')
old_waiting = dict(rows[0], status='waiting')
from itertools import permutations
for ordering in permutations([later, old_open, old_waiting]):
rejects(ordering)
print(result)
print('Empty, duplicate, reverse-order, missing-id, invalid-date and conflicting-version checks passed')
Приложение к статье «Где взять опыт если без опыта не берут: пять способов выполнить настоящую задачу». Редакционный пример; условия и ограничения — в тексте статьи.