import asyncio
from sqlalchemy import text
from app.core.database import AsyncSessionLocal

async def main():
    async with AsyncSessionLocal() as session:
        result = await session.execute(text("DESCRIBE cems_payment"))
        columns = result.fetchall()
        print("Columns in cems_payment MySQL table:")
        for col in columns:
            print(f"  Field: {col[0]}, Type: {col[1]}, Null: {col[2]}, Key: {col[3]}, Default: {col[4]}, Extra: {col[5]}")

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