import pandas as pd
import sys
sys.path.append('Backend')
from app.config.database import SessionLocal
from app.services.import_service import import_data

db = SessionLocal()
try:
    with open('Data_Tracerstudy/Data_2025_Tracer_study_D3MIF.csv', 'rb') as f:
        content = f.read()
    
    # We test what import_data does, but don't commit permanently
    res = import_data('2025', content, 'Data_2025_Tracer_study_D3MIF.csv', db)
    print("D3MIF import test result:")
    print("Status:", res['status'])
    print("Total rows:", res['stats']['total_rows'])
    print("Imported:", res['stats']['imported'])
    print("Skipped:", res['stats']['skipped'])
    print("Errors count:", len(res['stats']['errors']))
    if res['stats']['errors']:
        print("First 10 errors:")
        for err in res['stats']['errors'][:10]:
            print("  ", err)
finally:
    db.rollback()
    db.close()