from pathlib import Path
from io import BytesIO
import zipfile,pytest
from importers import parse
from scoring import RULES,score
ROOT=Path(__file__).resolve().parents[1]

def test_real_race2_pdf_24_rows_and_fastest():
 p=parse((ROOT/'samples/BMW CCCT - R2.pdf').read_bytes(),'BMW CCCT - R2.pdf')
 assert len(p['rows'])==24 and p['session']=='R2' and p['date']=='2026-10-17' and p['scheduled_laps']==7
 assert p['rows'][0]['name']=='Zack Groenewald' and p['rows'][0]['best_ms']==80996
 assert sum(r['status']=='DNS' for r in p['rows'])==2;assert p['rows'][16]['best_ms']==89754
 assert p['rows'][20]['best_ms'] is None

def test_real_pdf_points():
 p=parse((ROOT/'samples/BMW CCCT - R2.pdf').read_bytes(),'sample.pdf');entries=[]
 for i,r in enumerate(p['rows']):
  r['entry_id']=str(i);entries.append({'id':str(i),'driver_id':i+1,'car_id':i+1,'name':r['name'],'number':r['number'],'cls':r['raw_class'],'eligible':True,'identity_reviewed':True})
 s=score({'entries':entries,'sessions':{'R2':{'rows':p['rows'],'scheduled_laps':7}},'attendance':[]},RULES)
 assert s['starter_count']==22 and not s['breakouts']
 winners={r['cls']:r['name'] for r in s['sessions']['R2']['rows'] if r.get('bonus')};assert winners=={'C':'Zack Groenewald','D':'Sean Teubes','E':'Zac Laden','F':'Marius Fourie'}
 assert all(r['race_points']==0 for r in s['sessions']['R2']['rows'] if r['number'] in ('146','27'));assert s['totals'][16]['total']==9
@pytest.mark.parametrize('delimiter',[',',';','\t'])
def test_csv_formats(delimiter):
 t=delimiter.join(['Pos','No.','Name','Class','Laps','Total Tm','Best Tm'])+'\n'+delimiter.join(['1','43','Alex Driver','BMW C','8','11:00.000','1:20.996'])+'\n'
 r=parse(t.encode(),'timing.csv')['rows'][0];assert r['best_ms']==80996 and r['number']=='43'

def test_duplicate_number_fails():
 text='Pos,Number,Name,Class,Laps,Best Tm\n1,43,A,C,8,1:21.000\n2,43,B,C,8,1:22.000\n'
 with pytest.raises(ValueError):parse(text.encode(),'timing.csv')
def test_invalid_extension_fails():
 with pytest.raises(ValueError):parse(b'not workbook','timing.xls')
def test_xlsx_numeric_times():
 # Minimal, ordinary OOXML worksheet fixture; no external dependency or macro execution.
 xml='''<worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><sheetData><row r="1">'''
 headers=['Pos','Number','Name','Class','Laps','Best Tm']
 for i,h in enumerate(headers):xml+=f'<c r="{chr(65+i)}1" t="inlineStr"><is><t>{h}</t></is></c>'
 xml+='</row><row r="2"><c r="A2"><v>1</v></c><c r="B2"><v>43</v></c><c r="C2" t="inlineStr"><is><t>Alex Driver</t></is></c><c r="D2" t="inlineStr"><is><t>C</t></is></c><c r="E2"><v>8</v></c><c r="F2"><v>0.0009374537037037037</v></c></row></sheetData></worksheet>'
 b=BytesIO()
 with zipfile.ZipFile(b,'w') as z:z.writestr('xl/worksheets/sheet1.xml',xml)
 assert parse(b.getvalue(),'test.xlsx')['rows'][0]['best_ms']==80996
