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/')