diff options
| -rw-r--r-- | python/mtm_status.py | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/python/mtm_status.py b/python/mtm_status.py index 22be1810..6032f424 100644 --- a/python/mtm_status.py +++ b/python/mtm_status.py @@ -24,7 +24,6 @@ def run(conn, date): df = df[(df["SwapType"].isin(["NEW", "ASGM", "TERM"])) & (df["Executed"])] place_holders = ",".join(["%s"] * 7) sql_str = f"INSERT INTO mtm_submissions VALUES({place_holders})" - with conn.cursor() as c: for row in df.itertuples(): cpty_id = row.BrokerSecRef @@ -61,7 +60,7 @@ def run(conn, date): row.TicketNo, ), ) - conn.commit() + conn.commit() if __name__ == "__main__": |