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	Select A.ValueText As ProductCd from BANKCONST..Translate A Join BANKCONST..Translate B On A.TranslateCode=B.TranslateCode and A.Seq=B.Seq and A.ValueID = 1 and B.ValueID=2 where A.Translatecode={{TransCode}} and B.ValueText='{{Value}}'
TransCode	Value	ProductCd?
3002	1042-S Filing Request	$ProductCd1=

Delete Bankdata

ddt: DynamicQuery	DELETE A FROM {{Server}}.{{DBName}}.dbo.BankData A WHERE Year = '2017' and AcctNo = '{{PAN}}' and Product_Cd = '{{Product_Cd}}' DELETE A FROM {{Server}}.{{DBName}}.dbo.TrustYr A Join {{Server}}.{{DBName}}.dbo.TrustXref B On A.TrustKey=B.TrustKey WHERE YrSeq >= '20170' and YrSeq <= '20179'and AcctNo = '{{PAN}}' and NRAFiling_Dt is not Null
PAN	Server	DBName	Product_Cd
$PAN1	$Server1	$DBName1	$ProductCd1

Delete NRAExtract and Recip

ddt: DynamicQuery	DELETE A 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}}' DELETE A FROM {{Server}}.{{DBName}}.dbo.NRARecip A JOIN {{Server}}.{{DBName}}.dbo.TrustXref B ON A.TrustKey = B.TrustKey where YrSeq >= '20170' and YrSeq <= '20179' and AcctNo = '{{PAN}}'
PAN	Server	DBName
$PAN1	$Server1	$DBName1