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

import
TBOT.Generic.Database

import
TBOT.Generic

ddt:DynamicQuery WAITFOR DELAY '00:00:25' SELECT A.AcctNo AS PAN,2017 AS TAXYR, LTRIM(RTRIM(DB_Name)) as DB_Name, LTRIM(RTRIM(Server)) as Server FROM BTMDB.dbo.PACKAGE A WHERE AcctNo='{{ACCTNO}}'
ACCTNO PAN? TAXYR? DB_Name? Server?
312G $PAN1= $TAXYR1= $BANKDB1= $SRVNAME1=

ddt: SOAPNoNestedXMLClient http://10.184.7.166:9510/document.asmx SOAP:Action text/xml POST TemplateDownloadPDF.xml
CLIENTID SRVNAME BANKDB PAN TAXYR CHNGINI PROD_CD PRODOPT JOBTYPE DOCSEQNO OBJCD ASSETID XMLFileName nodeXpath STATUSCODE? FileName DOWNLOADFILEFROMXML?
OFFSHORE-Tasleem Fathima $SRVNAME1 $BANKDB1 $PAN1 $TAXYR1 TF Z 20 4 0 1 QI05LONBK1 GenerateQI05LONBK1.xml /Envelope/Body/GetBankDocDataResponse/GetBankDocDataResult/PACKAGE_PDF_RESPONSE/PDF OK GenerateQI05LONBK1.pdf True
OFFSHORE-Tasleem Fathima $SRVNAME1 $BANKDB1 $PAN1 $TAXYR1 TF Z 21 4 0 1 QI07LUXBK1 GenerateQI07LUXBK1.xml /Envelope/Body/GetBankDocDataResponse/GetBankDocDataResult/PACKAGE_PDF_RESPONSE/PDF OK GenerateQI07LUXBK1.pdf True
OFFSHORE-Tasleem Fathima $SRVNAME1 $BANKDB1 $PAN1 $TAXYR1 TF Z 23 4 0 1 QI10BXLBK1 GenerateQI10BXLBK1.xml /Envelope/Body/GetBankDocDataResponse/GetBankDocDataResult/PACKAGE_PDF_RESPONSE/PDF OK GenerateQI10BXLBK1.pdf True
OFFSHORE-Tasleem Fathima $SRVNAME1 $BANKDB1 $PAN1 $TAXYR1 TF Z 24 4 0 1 QI002CIBCBK1 GenerateQI002CIBCBK1.xml /Envelope/Body/GetBankDocDataResponse/GetBankDocDataResult/PACKAGE_PDF_RESPONSE/PDF OK GenerateQI002CIBCBK1.pdf True
OFFSHORE-Tasleem Fathima $SRVNAME1 $BANKDB1 $PAN1 $TAXYR1 TF Z 25 4 0 1 QI09BEBK1 GenerateQI09BEBK1.xml /Envelope/Body/GetBankDocDataResponse/GetBankDocDataResult/PACKAGE_PDF_RESPONSE/PDF OK GenerateQI09BEBK1.pdf True
OFFSHORE-Tasleem Fathima $SRVNAME1 $BANKDB1 $PAN1 $TAXYR1 TF Z 26 4 0 1 QI009BLGBBK1 GenerateQI009BLGBBK1.xml /Envelope/Body/GetBankDocDataResponse/GetBankDocDataResult/PACKAGE_PDF_RESPONSE/PDF OK GenerateQI009BLGBBK1.pdf True
OFFSHORE-Tasleem Fathima $SRVNAME1 $BANKDB1 $PAN1 $TAXYR1 TF Z 30 4 0 1 QI05LONBO3 GenerateQI05LONBO3.xml /Envelope/Body/GetBankDocDataResponse/GetBankDocDataResult/PACKAGE_PDF_RESPONSE/PDF OK GenerateQI05LONBO3.pdf True
OFFSHORE-Tasleem Fathima $SRVNAME1 $BANKDB1 $PAN1 $TAXYR1 TF Z 31 4 0 1 QI07LUXBO3 GenerateQI07LUXBO3.xml /Envelope/Body/GetBankDocDataResponse/GetBankDocDataResult/PACKAGE_PDF_RESPONSE/PDF OK GenerateQI07LUXBO3.pdf True
OFFSHORE-Tasleem Fathima $SRVNAME1 $BANKDB1 $PAN1 $TAXYR1 TF Z 33 4 0 1 QI10BXLBO3 GenerateQI10BXLBO3.xml /Envelope/Body/GetBankDocDataResponse/GetBankDocDataResult/PACKAGE_PDF_RESPONSE/PDF OK GenerateQI10BXLBO3.pdf True
OFFSHORE-Tasleem Fathima $SRVNAME1 $BANKDB1 $PAN1 $TAXYR1 TF Z 34 4 0 1 QI002CIBCBO3 GenerateQI002CIBCBO3.xml /Envelope/Body/GetBankDocDataResponse/GetBankDocDataResult/PACKAGE_PDF_RESPONSE/PDF OK GenerateQI002CIBCBO3.pdf True
OFFSHORE-Tasleem Fathima $SRVNAME1 $BANKDB1 $PAN1 $TAXYR1 TF Z 35 4 0 1 QI09BEBO3 GenerateQI09BEBO3.xml /Envelope/Body/GetBankDocDataResponse/GetBankDocDataResult/PACKAGE_PDF_RESPONSE/PDF OK GenerateQI09BEBO3.pdf True
OFFSHORE-Tasleem Fathima $SRVNAME1 $BANKDB1 $PAN1 $TAXYR1 TF Z 36 4 0 1 QI009BLGBBO3 GenerateQI009BLGBBO3.xml /Envelope/Body/GetBankDocDataResponse/GetBankDocDataResult/PACKAGE_PDF_RESPONSE/PDF OK GenerateQI009BLGBBO3.pdf True


ddt: KeywordFixture
expectedPDF targetfilename comparePDF?
Generate_London_BK1_0.pdf GenerateQI05LONBK1.pdf True
Generate_Luxembourg_BK1_0.pdf GenerateQI07LUXBK1.pdf True
Generate_Brussels_BK1_0.pdf GenerateQI10BXLBK1.pdf True
GenerateQI002CIBCBK1.pdf GenerateQI002CIBCBK1.pdf True
Generate_Belgium_BK1_0.pdf GenerateQI09BEBK1.pdf True
Generate_Belgium_BK_0.pdf GenerateQI009BLGBBK1.pdf True
Generate_London_BO3_0.pdf GenerateQI05LONBO3.pdf True
Generate_Luxembourg_BO3_0.pdf GenerateQI07LUXBO3.pdf True
Generate_Brussels_BO3_0.pdf GenerateQI10BXLBO3.pdf True
Generate_CIBC_BO3_0.pdf GenerateQI002CIBCBO3.pdf True
Generate_Belgium_BO3_0.pdf GenerateQI09BEBO3.pdf True
Generate_Belgium_BO_0.pdf GenerateQI009BLGBBO3.pdf True