def ImportStagingCcScore(dbHelper, ftpFolderPath, fileName):
readLines = Utility.ReadLinesFromFile(
ftpFolderPath + '\\' +
Utility.FormatFtpCsvFileNameByDate(fileName, fileDateStr))
insertSqlList = []
for ln in readLines:
lnStr = ln.strip()
if lnStr != '':
valList = lnStr.split(",")
customerCreditScoreModel = CustomerCreditScore(
'file_customer_credit_score', valList[1], valList[2])
insertSqlList.append(customerCreditScoreModel.GetInsertSqlString())
if len(insertSqlList) > 0:
dbHelper.ExecuteNonQuery(['delete from file_customer_credit_score'])
dbHelper.ExecuteNonQuery(insertSqlList)
def ImportMarketSummary(dbHelper, ftpFolderPath, fileName):
readLines = Utility.ReadLinesFromFile(
ftpFolderPath + '\\' +
Utility.FormatFtpCsvFileNameByDate(fileName, fileDateStr))
insertSqlList = []
for ln in readLines:
lnStr = ln.strip()
if lnStr != '':
valList = lnStr.split(",")
marketSummaryModel = MarketingSummary('file_marketing_summary',
valList[1], valList[2],
valList[3])
insertSqlList.append(marketSummaryModel.GetInsertSqlString())
if len(insertSqlList) > 0:
dbHelper.ExecuteNonQuery(['delete from file_marketing_summary'])
dbHelper.ExecuteNonQuery(insertSqlList)
def DownloadFTPFiles(ftpFolderPath, fileList):
myFtpConn = FTPConnector('ftp.jobready123.com', '*****@*****.**',
'K#Xwx3Sp.gmL')
for fn in fileList:
tfpFn = Utility.FormatFtpCsvFileNameByDate(fn, fileDateStr)
myFtpConn.DownloadFile(tfpFn, ftpFolderPath, '/DataAnalysis/')
