#!/usr/bin/env python3
"""
Debug sector extraction - show raw data
"""
import csv

with open('export.csv', 'r') as f:
    reader = list(csv.DictReader(f))

def show_lines(start, count, label):
    print(f"\n{label} - Lines {start} to {start+count}:")
    print("-" * 70)
    
    miso_bytes = []
    for i in range(start, min(start + count, len(reader))):
        row = reader[i]
        if row['type'] == 'result':
            mosi = row['mosi'] if row['mosi'] else '--'
            miso = row['miso'] if row['miso'] else '--'
            print(f"  Line {i}: MOSI={mosi:6s} MISO={miso:6s}")
            
            if miso.startswith('0x'):
                miso_bytes.append(int(miso, 16))
    
    # Show collected MISO bytes
    if miso_bytes:
        print(f"\n  MISO bytes: {' '.join(f'{b:02x}' for b in miso_bytes[:32])}")
        
        # Try taking every other byte
        data = [miso_bytes[i] for i in range(1, min(33, len(miso_bytes)), 2)]
        if data:
            hex_str = ''.join(f'{b:02x}' for b in data[:16])
            ascii_str = ''.join(chr(b) if 32 <= b < 127 else '.' for b in data[:16])
            print(f"  Every other: {hex_str}")
            print(f"  ASCII: '{ascii_str}'")

# Show data around sector reads
show_lines(67864, 40, "Sector 8 area (line 67864)")
show_lines(68312, 40, "Sector 22 area (line 68312)")  
show_lines(69112, 40, "Sector 34 area (line 69112)")