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/NRARollup.asmx SOAP:Action text/xml POST TemplateCreateNew.xml
SRVNAME BANKDB PAN TAXYR REQUEST PRODOPT QILIST XMLFileName STATUSCODE? RESPONSETIME?
$SRVNAME1 $BANKDB1 $PAN1 $TAXYR1 COR 11 002,009,270,297,315,528 CreateNew.xml OK $resTime1=
$SRVNAME1 $BANKDB1 $PAN1 $TAXYR1 COR 10 002,009,270,297,315,528 CreateNew.xml OK $resTime2=