from sqlalchemy import create_engine, text

# Database connection details
DB_HOST = "52.200.230.74"
DB_NAME = "ops_bi"
DB_USER = "admin"
DB_PASS = "D7f!r33p"

# Create connection
conn_string = f"postgresql://{DB_USER}:{DB_PASS}@{DB_HOST}/{DB_NAME}"
engine = create_engine(conn_string)

with engine.connect() as connection:
    rename_sql = text("""
        ALTER TABLE public."TARequisitions"
        RENAME TO "Merged_Requisitions";
    """)
    connection.execute(rename_sql)
    connection.commit()
    print("✅ Table renamed to 'Merged_Requisitions'.")