"""Build a CSV task-import plan without changing external state.""" import csv import io def plan_import(csv_text: str, existing_ids: set[str]) -> dict: """Validate all CSV records and return an atomic plan for new tasks.""" if csv_text.startswith("\ufeff"): csv_text = csv_text[1:] # Complete parsing first: a syntax error overrides even a bad header. try: records = list(csv.reader(io.StringIO(csv_text, newline=""), strict=True)) except csv.Error: return { "status": "invalid", "create": [], "errors": [{"row": 0, "code": "malformed_csv"}], } if not records or records[0] != ["external_id", "title"]: return { "status": "invalid", "create": [], "errors": [{"row": 1, "code": "invalid_header"}], } create = [] errors = [] seen = set() for row, record in enumerate(records[1:], start=2): if len(record) != 2: errors.append({"row": row, "code": "wrong_field_count"}) continue external_id, title = (field.strip() for field in record) errors_before = len(errors) if not external_id: errors.append({"row": row, "code": "empty_id"}) if not title: errors.append({"row": row, "code": "empty_title"}) if len(title) > 80: errors.append({"row": row, "code": "title_too_long"}) if external_id: if external_id in seen: errors.append({"row": row, "code": "duplicate_id"}) seen.add(external_id) if len(errors) == errors_before and external_id not in existing_ids: create.append({"external_id": external_id, "title": title}) if errors: return {"status": "invalid", "create": [], "errors": errors} return {"status": "valid", "create": create, "errors": []}