def gen_inserts(table_name: str, cols: list, pk: str):
    df = gen_script_table_ui(cols)
    view = st.data_editor(df, num_rows="dynamic", use_container_width=True)

    str_cols = ",".join(str(element) for element in cols)

    inserts = []

    bound = int(view.size / len(cols))

    i = 0
    while True:
        try:
            values = "','".join(str(element) for element in view.values[i])

            sql_stmnt = f"""INSERT INTO {table_name} ({str_cols}) VALUES ('{values}');"""  # noqa: E501

            inserts.append(sql_stmnt)
            i = i + 1

            if i >= bound:
                break

        except Exception as e:
            print(f"No rows: {e}")
            break

    result = "\n".join(inserts)
    st.code(
        f"""
SET DEFINE OFF;

DELETE FROM {table_name} WHERE {pk} IN ('{"','".join(str(e) for e in view[pk].values)}');

{result}

COMMIT;
""".replace(  # noqa: E501
            "'None'", "null"
        )
        .replace("'nan'", "null")
        .replace("''", "null"),  # noqa: E501
        language="sql",
        line_numbers=True,
    )