import asyncio
from app.database import engine
from sqlalchemy import text

async def seed_charges():
    async with engine.begin() as conn:
        await conn.execute(text("INSERT IGNORE INTO charge_master (id, code, name, description, is_active) VALUES (1, 'PENAL', 'Penal Charges', 'Late payment penal fee', 1)"))
        await conn.execute(text("INSERT IGNORE INTO charge_master (id, code, name, description, is_active) VALUES (2, 'NACH_BOUNCE', 'NACH Bounce', 'NACH Bounce charge', 1)"))
        await conn.execute(text("INSERT IGNORE INTO charge_master (id, code, name, description, is_active) VALUES (3, 'CHEQUE_BOUNCE', 'Cheque Bounce', 'Cheque Bounce charge', 1)"))
        await conn.execute(text("INSERT IGNORE INTO charge_master (id, code, name, description, is_active) VALUES (4, 'STAMP_DUTY', 'Stamp Duty', 'Stamp duty fee', 1)"))
        
    print("Seeded charge_master successfully.")

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