import pandas as pd

from serenitas.utils.db import dawn_engine

df = pd.read_csv("/home/serenitas/flint/irs_ticket.csv")

df.columns = (
    df.columns.str.replace(" ", "_").str.replace("[()/]", "", regex=True).str.lower()
)

df.insert(0, "bbg_ticket_id", "test")

df.to_sql("irs_tickets", con=dawn_engine, index=False, if_exists="append")