diff options
| -rw-r--r-- | python/adj_index_price.py | 2 | ||||
| -rw-r--r-- | python/backfill_index.py | 2 | ||||
| -rw-r--r-- | python/bbg_newids.py | 2 | ||||
| -rw-r--r-- | python/bbg_prices.py | 2 | ||||
| -rw-r--r-- | python/http-server.py | 1 | ||||
| -rw-r--r-- | python/import_quotes.py | 2 | ||||
| -rw-r--r-- | python/insert_composite_quotes.py | 2 | ||||
| -rw-r--r-- | python/insert_index.py | 2 | ||||
| -rw-r--r-- | python/insert_tranche_quotes.py | 2 | ||||
| -rw-r--r-- | python/insert_tranche_quotes_old.py | 2 | ||||
| -rw-r--r-- | python/markit_cds.py | 2 |
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()
|