import json
import os

FILE_PATH = r"c:\Users\djw7ql\OneDrive - Aptiv\Antigravity\KR_Eng_Lab_Status\data\equipment.json"

def migrate():
    with open(FILE_PATH, 'r', encoding='utf-8') as f:
        data = json.load(f)
        
    for eq in data:
        # Save existing fields to current
        current = {
            "project": eq.get("project", ""),
            "item": eq.get("item", ""),
            "engineer": eq.get("engineer", ""),
            "start": eq.get("start", ""),
            "end": eq.get("end", "")
        }
        
        # Remove flat fields
        for key in ["project", "item", "engineer", "start", "end"]:
            if key in eq:
                del eq[key]
                
        # Inject history fields
        eq["previous"] = { "project": "", "item": "", "engineer": "", "start": "", "end": "" }
        eq["current"] = current
        eq["next"] = { "project": "", "item": "", "engineer": "", "start": "", "end": "" }
        
    with open(FILE_PATH, 'w', encoding='utf-8') as f:
        json.dump(data, f, indent=2, ensure_ascii=False)
        
    print("Migration complete.")

if __name__ == '__main__':
    migrate()