diff options
Diffstat (limited to 'python/facility_download.py')
| -rw-r--r-- | python/facility_download.py | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/python/facility_download.py b/python/facility_download.py index f56dae7c..141f6e4f 100644 --- a/python/facility_download.py +++ b/python/facility_download.py @@ -1,7 +1,7 @@ import requests
import os
-import common
-from common import query_db
+from common import root
+from db import conn, query_db
legal = 'serecap'
username = 'serecapuser'
@@ -26,7 +26,7 @@ flag = False sqlstring = "select loanxid from markit_prices2 except (select loanxid from latest_markit_prices2)"
loan_ids = query_db(sqlstring, one=False)
-with open( os.path.join(common.root, "data", "Facility files",
+with open( os.path.join(root, "data", "Facility files",
"facility_test.csv"), "wb") as fh:
for loanxid in loan_ids:
r = requests.get('https://loans.markit.com/loanx/LoanXOneFacility.csv?LEGALENTITY={0}&USERNAME={1}&PASSWORD={2}&LOANXID={3}'.format(legal, username, password, loanxid[0]))
@@ -37,4 +37,4 @@ with open( os.path.join(common.root, "data", "Facility files", fh.write(r.content.split('\n')[1] + "\n")
flag = True
-common.conn.close()
+conn.close()
|