import os

models_dir = r"c:\Users\sairam.c\Downloads\Tnss_python\Tnss_python\insurance-border-api\app\models"

# We want to insert 'user_id: Optional[int] = Field(default=None, foreign_key="users.id", nullable=True)'
# right after 'id: Optional[int] = Field(default=None, primary_key=True)' (or similar primary key field definition).

target_line_matches = [
    'id: Optional[int] = Field(default=None, primary_key=True)',
    'id: Optional[int] = Field(default=None, primary_key=True, description="Primary key")',
    'id: Optional[int] = Field(default=None, primary_key=True, description="Primary Key")',
    'id: Optional[int] = Field(None, primary_key=True)',
    'id: Optional[int] = Field(default=None, primary_key=True, nullable=False)',
    'id: int = Field(default=None, primary_key=True)',
]

for filename in os.listdir(models_dir):
    if not filename.endswith(".py") or filename == "__init__.py" or filename == "user.py":
        continue
        
    filepath = os.path.join(models_dir, filename)
    with open(filepath, "r", encoding="utf-8") as f:
        content = f.read()
        
    # Check if user_id is already in file
    if "user_id:" in content or "user_id :" in content:
        print(f"Skipping {filename} (already has user_id)")
        continue
        
    updated = False
    lines = content.splitlines()
    new_lines = []
    
    for line in lines:
        new_lines.append(line)
        # Strip trailing/leading space for matching
        stripped = line.strip()
        matched = False
        for pattern in target_line_matches:
            if stripped == pattern or stripped.replace(" ", "") == pattern.replace(" ", ""):
                matched = True
                break
        
        # Also match custom variations like id: Optional[int] = Field(..., primary_key=True)
        if not matched and "primary_key=True" in stripped and "id:" in stripped and "user_id" not in stripped:
            matched = True
            
        if matched:
            indent = line[:len(line) - len(line.lstrip())]
            # Insert user_id definition
            new_lines.append(f'{indent}user_id: Optional[int] = Field(default=None, foreign_key="users.id", nullable=True)')
            updated = True
            
    if updated:
        with open(filepath, "w", encoding="utf-8") as f:
            f.write("\n".join(new_lines) + "\n")
        print(f"Updated {filename}")
    else:
        print(f"Failed to automatically update {filename}")
