import sys
sys.path.append('Backend')
from app.config.database import engine, SessionLocal
from app.services.import_service import import_data

db = SessionLocal()
with open('Data_Tracerstudy/Data_2025_Tracer_study_D4TIF.csv', 'rb') as f:
    content = f.read()

res = import_data('2025', content, 'Data_2025_Tracer_study_D4TIF.csv', db)
print("Import result:", res["stats"]["imported"], "imported,", res["stats"]["skipped"], "skipped")
if res["stats"]["errors"]:
    print(f"Total errors: {len(res['stats']['errors'])}")
    for err in res["stats"]["errors"][:10]:
        print("  Error:", err)