← К статье
Скачать Python-файлСкачать исходник (Python)

Код проверки: 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')

Приложение к статье «Где взять опыт если без опыта не берут: пять способов выполнить настоящую задачу». Редакционный пример; условия и ограничения — в тексте статьи.