1 files changed, 4 insertions, 3 deletions
diff --git a/python/intex/load_intex_collateral.py b/python/intex/load_intex_collateral.py
index cde12587..add1e127 100644
--- a/python/intex/load_intex_collateral.py
+++ b/python/intex/load_intex_collateral.py
@@ -2,11 +2,12 @@ import psycopg2
 import os, csv, datetime
 import pdb
 from common import root, sanitize_float
-from db import conn
+from db import dbconn
 import sys
 import uuid
 from intex.load_indicative import upload_cusip_data, upload_deal_data
 import logging
+from contextlib import closing
 
 logger = logging.getLogger(__name__)
 
@@ -146,6 +147,6 @@ if __name__ == "__main__":
         workdate = sys.argv[1]
     else:
         workdate = str(datetime.date.today())
-    intex_data(conn, workdate)
-    conn.close()
+    with dbconn('etdb') as etdb:
+        intex_data(etdb, workdate)
     print("done")