diff options
| -rw-r--r-- | python/task_server/insert_tranche_quotes.py | 11 |
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() |