"""إضافة عمود condition_first_detected"""
import asyncio
from sqlalchemy import text
from app.database import AsyncSessionLocal

async def add_column():
    async with AsyncSessionLocal() as session:
        try:
            await session.execute(text("""
                ALTER TABLE alert_rules 
                ADD COLUMN condition_first_detected DATETIME NULL
            """))
            print("✓ Added condition_first_detected column")
        except Exception as e:
            if "Duplicate column" in str(e):
                print("Column already exists")
            else:
                print(f"Error: {e}")

if __name__ == "__main__":
    asyncio.run(add_column())