1 files changed, 7 insertions, 4 deletions
diff --git a/python/task_server/insert_tranche_quotes.py b/python/task_server/insert_tranche_quotes.py
index 5ece93f1..8421e5e5 100644
--- a/python/task_server/insert_tranche_quotes.py
+++ b/python/task_server/insert_tranche_quotes.py
@@ -1,15 +1,18 @@
 from sqlalchemy import Table, create_engine, MetaData
-from sqlalchemy.exc import IntegrityError, DataError
+from sqlalchemy.exc import IntegrityError, DataError, SAWarning
 import os
 import csv
 import datetime
 import logging
+import warnings
 
 logger = logging.getLogger(__name__)
 
 engine = create_engine('postgresql://serenitas_user@debian/serenitasdb')
-metadata = MetaData(bind = engine)
-quotes = Table('tranche_quotes', metadata, autoload = True)
+metadata = MetaData(bind=engine)
+with warnings.catch_warnings():
+    warnings.simplefilter("ignore", category=SAWarning)
+    quotes = Table('tranche_quotes', metadata, autoload=True)
 ins = quotes.insert()
 
 def convert(x):
@@ -203,5 +206,5 @@ def insert_quotes(year=2016, quote_dir=None):
 
         os.unlink(os.path.join(quote_dir, quotefile))
 
-if __name__=="__main__":
+if __name__ == "__main__":
     insert_quotes()