11 files changed, 10 insertions, 11 deletions
diff --git a/python/adj_index_price.py b/python/adj_index_price.py
index 3dfe57d7..abd690c2 100644
--- a/python/adj_index_price.py
+++ b/python/adj_index_price.py
@@ -6,7 +6,7 @@ index='HY'
 series = [9]
 # index='IG'
 # series= [9, 11, 13, 15, 17, 19, 21, 23]
-engine = create_engine('postgresql://serenitas_user:Serenitas1@debian/serenitasdb')
+engine = create_engine('postgresql://serenitas_user@debian/serenitasdb')
 metadata = MetaData(bind=engine)
 index_quotes= Table('index_quotes', metadata, autoload=True)
 
diff --git a/python/backfill_index.py b/python/backfill_index.py
index 0ecc9ba7..4504c416 100644
--- a/python/backfill_index.py
+++ b/python/backfill_index.py
@@ -1,5 +1,5 @@
 from sqlalchemy import MetaData, create_engine, Table
-engine = create_engine('postgresql://serenitas_user:Serenitas1@debian/serenitasdb')
+engine = create_engine('postgresql://serenitas_user@debian/serenitasdb')
 import pandas as pd
 
 metadata = MetaData(bind = engine)
diff --git a/python/bbg_newids.py b/python/bbg_newids.py
index 61a3cbc2..b0b1cd40 100644
--- a/python/bbg_newids.py
+++ b/python/bbg_newids.py
@@ -4,7 +4,7 @@ from db import conn
 import numpy as np
 from bbg_helpers import init_bbg_session, retreive_data, process_msgs
 
-engine = create_engine('postgresql://et_user:Serenitas1@debian/ET')
+engine = create_engine('postgresql://et_user@debian/ET')
 
 session = init_bbg_session('192.168.1.108', 8194)
 
diff --git a/python/bbg_prices.py b/python/bbg_prices.py
index 723b35bf..2f1ee596 100644
--- a/python/bbg_prices.py
+++ b/python/bbg_prices.py
@@ -4,7 +4,7 @@ from db import conn
 import numpy as np
 import pandas as pd
 
-engine = create_engine('postgresql://et_user:Serenitas1@debian/ET')
+engine = create_engine('postgresql://et_user@debian/ET')
 session = init_bbg_session('192.168.1.108', 8194)
 
 fields_update = ["LN_ISSUE_STATUS", "AMT_OUTSTANDING", "PX_LAST","LAST_UPDATE_DT",
diff --git a/python/http-server.py b/python/http-server.py
index 9c8ebaf3..38df18f2 100644
--- a/python/http-server.py
+++ b/python/http-server.py
@@ -64,7 +64,6 @@ class MyDaemon(Daemon):
         q = redis.Redis(unix_socket_path='/var/run/redis/redis.sock')
         self.conn = psycopg2.connect(database="ET",
                                      user="et_user",
-                                     password="Serenitas1",
                                      host="debian",
                                      cursor_factory=DictCursor)
         http = MyServer(server_address, MyHandler, q, self.conn)
diff --git a/python/import_quotes.py b/python/import_quotes.py
index 8de71950..b5dde7f5 100644
--- a/python/import_quotes.py
+++ b/python/import_quotes.py
@@ -123,7 +123,7 @@ if __name__=="__main__":
     else:
         workdate = datetime.datetime.today()-BDay(1)
     workdate = workdate.date()
-    engine = create_engine('postgresql://serenitas_user:Serenitas1@debian/serenitasdb')
+    engine = create_engine('postgresql://serenitas_user@debian/serenitasdb')
     insert_cds(serenitasdb, workdate)
     # insert_index(engine, workdate)
     serenitasdb.close()
diff --git a/python/insert_composite_quotes.py b/python/insert_composite_quotes.py
index 027cd42e..8d82bc32 100644
--- a/python/insert_composite_quotes.py
+++ b/python/insert_composite_quotes.py
@@ -4,7 +4,7 @@ import csv
 import datetime
 
 ##script to load quotes from markit composite quotes csv file
-engine = create_engine('postgresql://mlpdb_user:Serenitas1@debian/mlpdb')
+engine = create_engine('postgresql://serenitas_user@debian/serenitasdb')
 metadata = MetaData(bind = engine)
 quotes = Table('tranche_quotes', metadata, autoload = True)
 ins = quotes.insert()
diff --git a/python/insert_index.py b/python/insert_index.py
index ce130fcd..bd0d8867 100644
--- a/python/insert_index.py
+++ b/python/insert_index.py
@@ -1,7 +1,7 @@
 import datetime
 from sqlalchemy import MetaData, create_engine, Table
 
-engine = create_engine('postgresql://mlpdb_user:Serenitas1@debian/mlpdb')
+engine = create_engine('postgresql://serenitas_user@debian/serenitasdb')
 metadata = MetaData(bind = engine)
 index_desc = Table('index_desc', metadata, autoload=True)
 index_ins = index_desc.insert()
diff --git a/python/insert_tranche_quotes.py b/python/insert_tranche_quotes.py
index 9eef5c62..d6cd7350 100644
--- a/python/insert_tranche_quotes.py
+++ b/python/insert_tranche_quotes.py
@@ -5,7 +5,7 @@ import csv
 import datetime
 import logging
 
-engine = create_engine('postgresql://serenitas_user:Serenitas1@debian/serenitasdb')
+engine = create_engine('postgresql://serenitas_user@debian/serenitasdb')
 metadata = MetaData(bind = engine)
 quotes = Table('tranche_quotes', metadata, autoload = True)
 ins = quotes.insert()
diff --git a/python/insert_tranche_quotes_old.py b/python/insert_tranche_quotes_old.py
index 176cfdb1..9e24a02a 100644
--- a/python/insert_tranche_quotes_old.py
+++ b/python/insert_tranche_quotes_old.py
@@ -4,7 +4,7 @@ import csv
 import datetime
 import pdb
 
-engine = create_engine('postgresql://mlpdb_user:Serenitas1@debian/mlpdb')
+engine = create_engine('postgresql://serenitas_user@debian/serenitasdb')
 metadata = MetaData(bind = engine)
 quotes = Table('tranche_quotes', metadata, autoload = True)
 ins = quotes.insert()
diff --git a/python/markit_cds.py b/python/markit_cds.py
index a433fc54..4b8c652b 100644
--- a/python/markit_cds.py
+++ b/python/markit_cds.py
@@ -57,7 +57,7 @@ if __name__=="__main__":
     download_cds_data(payload)
     payload.update({'type':'CredIndex','version':4})
     download_composite_data(payload)
-    engine = create_engine('postgresql://serenitas_user:Serenitas1@debian/serenitasdb')
+    engine = create_engine('postgresql://serenitas_user@debian/serenitasdb')
     insert_cds(serenitasdb, workdate.date())
     insert_index(engine, workdate.date())
     serenitasdb.close()