Included page: .FrontPage.QA.Archive.ServiceAutomation.NRARollUp.SetUp (edit)

import
TBOT.Generic.Database

!*****> Setup
ddt: SetUp
key value
ConnectionString Server=10.153.120.216,1600;database=AUTOTESTING;User Id=tfathima; password=tfathima*100
BytesColumn DataObject
FileExtension zip
ExpectedDir \\C605ZPUOTTFS2.tztst.loc\_QATeam\git\data-ott\IntegrationTests\BaselineFiles\Baseline\files\QA\YrSpecSuites\2017\BatchAutomation\NRA
ExpectedDirectory \\C605ZPUOTTFS2.tztst.loc\_QATeam\git\data-ott\IntegrationTests\BaselineFiles\Baseline\files\QA\YrSpecSuites\2017\BatchAutomation\NRA\DataFiles
ActualDir \\C605ZPUOTTFS2.tztst.loc\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2017\BatchAutomation\NRA
TargetDirectory \\C605ZPUOTTFS2.tztst.loc\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2017\BatchAutomation\NRA\DataFiles
ResultDir \\C605ZPUOTTFS2.tztst.loc\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2017\BatchAutomation\NRA
DownloadPath \\C605ZPUOTTFS2.tztst.loc\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2017\BatchAutomation\NRA\DataFiles
CompareResultDir \FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2017\BatchAutomation\NRA
ignorePathValidations false
DeleteFile true
NewYearFlag false
skipIgnorePatterns true

Libraries

import
TBOT.Generic.Database


!*****> Download and Validate 1042S
DDT:KeywordFixture Select DataObject from BANKDB26..BANKDATA where Product_Cd='{{Product_Cd}}' and Year=2017 and AcctNo='{{PAN}}' and SeqNo=0 and ProdOpt ={{PRODOPT}}
Product_Cd PAN PRODOPT FileName DOWNLOAD? sourceFile destinationFile resultFileName CompareResultDir compareFiles?
Z 312G 20 312GOverWriteLonBK.txt True 312GBLOverWriteLonBK.txt 312GOverWriteLonBK.txt D:\Installations\FitNesseRoot\files\TrustTax\NRA\Results Both Files are Equal
Z 312G 30 312GOverWriteLonBO.txt True 312GBLOverWriteLonBO.txt 312GOverWriteLonBO.txt D:\Installations\FitNesseRoot\files\TrustTax\NRA\Results Both Files are Equal
Z 312G 24 312GOverWriteCANBK.txt True 312GBLOverWriteCANBK.txt 312GOverWriteCANBK.txt D:\Installations\FitNesseRoot\files\TrustTax\NRA\Results Both Files are Equal
Z 312G 34 312GOverWriteCANBO.txt True 312GBLOverWriteCANBO.txt 312GOverWriteCANBO.txt D:\Installations\FitNesseRoot\files\TrustTax\NRA\Results Both Files are Equal
Z 312G 26 312GOverWriteBELBK.txt True 312GBLOverWriteBELBK.txt 312GOverWriteBELBK.txt D:\Installations\FitNesseRoot\files\TrustTax\NRA\Results Both Files are Equal
Z 312G 36 312GOverWriteBELBO.txt True 312GBLOverWriteBELBO.txt 312GOverWriteBELBO.txt D:\Installations\FitNesseRoot\files\TrustTax\NRA\Results Both Files are Equal
Z 312G 23 312GOverWriteBRUSBK.txt True 312GBLOverWriteBRUSBK.txt 312GOverWriteBRUSBK.txt D:\Installations\FitNesseRoot\files\TrustTax\NRA\Results Both Files are Equal
Z 312G 33 312GOverWriteBRUSBO.txt True 312GBLOverWriteBRUSBO.txt 312GOverWriteBRUSBO.txt D:\Installations\FitNesseRoot\files\TrustTax\NRA\Results Both Files are Equal
Z 312G 21 312GOverWriteLuxBK.txt True 312GBLOverWriteLuxBK.txt 312GOverWriteLuxBK.txt D:\Installations\FitNesseRoot\files\TrustTax\NRA\Results Both Files are Equal
Z 312G 31 312GOverWriteLuxBO.txt True 312GBLOverWriteLuxBO.txt 312GOverWriteLuxBO.txt D:\Installations\FitNesseRoot\files\TrustTax\NRA\Results Both Files are Equal
Z 312G 25 312GOverWriteBel528BK.txt True 312GBLOverWriteBel528BK.txt 312GOverWriteBel528BK.txt D:\Installations\FitNesseRoot\files\TrustTax\NRA\Results Both Files are Equal
Z 312G 35 312GOverWriteBel528BO.txt True 312GBLOverWriteBel528BO.txt 312GOverWriteBel528BO.txt D:\Installations\FitNesseRoot\files\TrustTax\NRA\Results Both Files are Equal