"""Generated CSV only. Run in a scratch directory; writes three named sample files."""
import csv,io,json,sys
from pathlib import Path
header=['code','label','note']
rows=[['0012','A, B','two labels, one cell'],['0013','Box "Blue"','plain note'],['0014','가나다','first line\nsecond line'],['0015','empty note','']]
buf=io.StringIO(newline='');writer=csv.writer(buf,lineterminator='\r\n');writer.writerow(header);writer.writerows(rows);text=buf.getvalue()
Path('csv-boundaries-sample.csv').write_bytes(text.encode('utf-8'))
with Path('csv-boundaries-sample.csv').open(encoding='utf-8',newline='') as f:parsed=list(csv.reader(f))
assert parsed==[header]+rows
assert len(text.splitlines())==6 and len(parsed)==5
assert all(len(r)==3 for r in parsed)
assert parsed[1][0]=='0012' and parsed[2][1]=='Box "Blue"'
assert parsed[3][2]=='first line\nsecond line' and parsed[4][2]==''
naive=[line.split(',') for line in text.splitlines()];assert [len(r) for r in naive]==[3,5,3,3,1,3]
def validate(table):
 if table[0]!=header:raise ValueError('unexpected header')
 if any(len(r)!=3 for r in table[1:]):raise ValueError('wrong width')
 return True
assert validate(parsed)
rejections=[]
for name,bad in [('missing_cell',[header,['0012','label']]),('extra_cell',[header,['0012','label','note','extra']]),('wrong_header',[['id','label','note']]+rows)]:
 try:validate(bad)
 except ValueError:rejections.append(name)
 else:raise AssertionError('bad table accepted')
try:list(csv.reader(io.StringIO('code,label,note\n0012,"unfinished',newline=''),strict=True))
except csv.Error:rejections.append('unclosed_quote')
else:raise AssertionError('unclosed quote accepted')
result={'python_version':sys.version.split()[0],'method':'Generated UTF-8 CSV, comma delimiter, quotechar double quote, CRLF record terminators; no spreadsheet application tested','data_records':len(parsed)-1,'parsed_rows_including_header':len(parsed),'physical_lines':len(text.splitlines()),'parsed_widths':[len(r) for r in parsed],'naive_split_widths':[len(r) for r in naive],'all12_data_fields_roundtrip':parsed[1:]==rows,'expected_rejections':rejections,'records':rows}
Path('csv-boundaries-results.json').write_text(json.dumps(result,ensure_ascii=False,indent=2)+'\n',encoding='utf-8');print(json.dumps(result,ensure_ascii=False))
