اعتبارسنجی کامل فروش CSV در پایتون؛ تاریخ، محصول و عددها

کد اولیهٔ فعالیت

import tempfile
from pathlib import Path
import csv
import json
from datetime import date

def normalize_row(cells):
    if len(cells) != 4:
        return None
    day_text, product, quantity_text, price_text = cells
    product = product.strip()
    try:
        day = date.fromisoformat(day_text)
        quantity = int(quantity_text)
        price = int(price_text)
    except ValueError:
        return None
    if day.isoformat() != day_text or not product or quantity <= 0 or price < 0:
        return None
    return {'date': day_text, 'product': product, 'quantity': quantity, 'unit_price': price}

def validated_sales(text):
    with tempfile.TemporaryDirectory() as folder:
        path = Path(folder) / 'sales.csv'
        path.write_text(text, encoding='utf-8')
        valid, invalid = [], 0
        with open(path, encoding='utf-8', newline='') as file:
            reader = csv.reader(file)
            next(reader, None)
            for cells in reader:
                # TODO: ignore empty lines, normalize or count rejection
                pass
        return {'rows': valid, 'invalid_rows': invalid}