from sqlmodel import text
from db import engine

with engine.connect() as conn:
    # Get all tables
    res = conn.execute(text("SELECT table_name FROM information_schema.tables WHERE table_schema='public'"))
    tables = [r[0] for r in res.all()]
    print("Tables:", tables)
    
    # Print columns for life_insurance
    if 'life_insurance' in tables:
        columns_res = conn.execute(text(
            "SELECT column_name, data_type FROM information_schema.columns "
            "WHERE table_name = 'life_insurance'"
        ))
        print("life_insurance columns:", columns_res.all())
