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	Select AcctNo As PAN,LTRIM(RTRIM(Server)) As Server,LTRIM(RTRIM(DB_NAME)) As DBName from BTMDB..Package where AcctNo='{{PAN}}'
PAN	PAN?	Server?	DBName?
312G	$PAN1=	$Server1=	$DBName1=

ddt: DynamicQuery	Update A Set NRAIntermediaryType='BO3' FROM {{Server}}.{{DBName}}.dbo.NRAExtract A JOIN {{Server}}.{{DBName}}.dbo.TrustXref B ON A.TrustKey = B.TrustKey where YrSeq >= 20170 and YrSeq <= 20179 and AcctNo = '{{PAN}}' and TrustNo='{{TRUSTNO}}'
Server	DBName	PAN	TRUSTNO
$Server1	$DBName1	$PAN1	1042BEBO3
$Server1	$DBName1	$PAN1	1042BELGBO3
$Server1	$DBName1	$PAN1	1042BELGBO3II
$Server1	$DBName1	$PAN1	1042BXLBO3
$Server1	$DBName1	$PAN1	1042CIBCBO3
$Server1	$DBName1	$PAN1	1042LONDONBO3
$Server1	$DBName1	$PAN1	G236092
$Server1	$DBName1	$PAN1	G362972
$Server1	$DBName1	$PAN1	G192371
$Server1	$DBName1	$PAN1	G636617
$Server1	$DBName1	$PAN1	1042LUXBO3
$Server1	$DBName1	$PAN1	G638164
$Server1	$DBName1	$PAN1	1041CIBC1BO3
$Server1	$DBName1	$PAN1	G814977
$Server1	$DBName1	$PAN1	G768300
$Server1	$DBName1	$PAN1	G436397
$Server1	$DBName1	$PAN1	G173684

ddt: DynamicQuery	WAITFOR DELAY '00:00:03' Select AcctNo As PAN,LTRIM(RTRIM(Server)) As Server,LTRIM(RTRIM(DB_NAME)) As DBName from BTMDB..Package where AcctNo='{{PAN}}'
PAN	PAN?	Server?	DBName?
312G	$PAN1=	$Server1=	$DBName1=

ddt:DynamicQuery	WAITFOR DELAY '00:00:02' Select 2017 As YEAR, TRUSTKEY As TRUSTKEY FROM {{Server}}.{{DBName}}.dbo.TrustXRef WHERE ACCTNO='{{PAN}}' and TrustNo='{{TrustNo}}'
PAN	TrustNo	Server	DBName	YEAR?	TRUSTKEY?
$PAN1	G192371	$Server1	$DBName1	$Year1=	$TrustKey1=
$PAN1	G536285	$Server1	$DBName1	$Year1=	$TrustKey2=
$PAN1	1042NEW	$Server1	$DBName1	$Year1=	$TrustKey3=
$PAN1	G238863	$Server1	$DBName1	$Year1=	$TrustKey4=

Income Code Update

ddt: SOAPNoNestedXMLClient	http://10.184.7.166:9510/ten42sforms.asmx	SOAP:Action	text/xml	POST	TemplateRemoveErrors.xml	InsUpdDel1042SIncomeInfo
CLIENTID	SRVNAME	BANKDB	PAN	TAXYR	CHNGINI	TRUSTKEY	TRUSTSEQ	PERMSEQ	NRARECIPNO	ROW1	EXEMPTCD	ROW2	EXEMPTCD	ROW3	EXEMPTCD	ROW4	TAXRATE	XMLFileName	STATUSCODE?
OFFSHORE-Tasleem Fathima	$Server1	$DBName1	$PAN1	$Year1	TF	$TrustKey1	0	0	3	1	01	4	02	5	01	6	0.3	UpdateNRAIncomeCodeRollUp.xml	OK
OFFSHORE-Tasleem Fathima	$Server1	$DBName1	$PAN1	$Year1	TF	$TrustKey2	0	0	3	1	01	4	02	5	01	6	0.3	UpdateNRAIncomeCodeRollUp.xml	OK
OFFSHORE-Tasleem Fathima	$Server1	$DBName1	$PAN1	$Year1	TF	$TrustKey3	0	0	1	1	01	4	02	5	01	6	0.3	UpdateNRAIncomeCodeRollUp.xml	OK
OFFSHORE-Tasleem Fathima	$Server1	$DBName1	$PAN1	$Year1	TF	$TrustKey4	0	0	1	2	01	3	02	4	01	1	0.3	UpdateNRAIncomeCodeRollUp.xml	OK