Included page: .FrontPage.QA.OSMI-OutOfStateMunicipalIncome.2022.SetUp (edit)

import

TBOT.Generic.Database

ddt: SetUp
key	value
ConnectionString	Server=10.153.120.216,1600;database=AUTOTESTING;User Id=automation; password=automation*100;Timeout=45
BytesColumn	DataObject
FileExtension	ZIP
ExpectedDirectory	\\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2023\BatchAutomation\OSMIReports
DownloadPath	\\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2023\BatchAutomation\OSMIReports
ExpectedDir	\\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2023\BatchAutomation\OSMIReports
ActualDir	\\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2023\BatchAutomation\OSMIReports
SourceDirectory	\\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2023\BatchAutomation\OSMIReports
ResultDir	\\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2023\BatchAutomation\OSMIReports
CompareResultDir	\\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2023\BatchAutomation\OSMIReports
skipIgnorePatterns	true
ignorePathValidations	false
DeleteFile	true
Debug	TRUE
ignoreNodes	/Envelope/Body/GetOSMIBEBankRecipResponse/GetOSMIBEBankRecipResult/diffgram/NewDataSet/OSMIBEBankRecip/RecipNo;/Envelope/Body/GetOSMIBondsFiledResponse/GetOSMIBondsFiledResult/diffgram/NewDataSet/OSMIBondsFiled/RecipNo;/Envelope/Body/GetOSMIMutualFundFiledResponse/GetOSMIMutualFundFiledResult/diffgram/NewDataSet/OSMIMutualFundFiled/RecipNo;/Envelope/Body/GetOSMIBondsFiledResponse/GetOSMIBondsFiledResult/diffgram/NewDataSet/OSMIBondsFiled/Filing_Dt;/Envelope/Body/GetOSMIMutualFundFiledResponse/GetOSMIMutualFundFiledResult/diffgram/NewDataSet/OSMIMutualFundFiled/Filing_Dt;/Envelope/Body/GetOSMIMutualFundCorrectedResponse/GetOSMIMutualFundCorrectedResult/diffgram/NewDataSet/OSMIMutualFundCorrected/Filing_Dt;/Envelope/Body/GetOSMIMutualFundCorrectedResponse/GetOSMIMutualFundCorrectedResult/diffgram/NewDataSet/OSMIMutualFundCorrected/RecipNo;/Envelope/Body/GetOSMIBondsCorrectedResponse/GetOSMIBondsCorrectedResult/diffgram/NewDataSet/OSMIBondsCorrected/Filing_Dt;/Envelope/Body/GetOSMIBondsCorrectedResponse/GetOSMIBondsCorrectedResult/diffgram/NewDataSet/OSMIBondsCorrected/RecipNo

ddt:DynamicQuery	Select convert(varchar(10),getdate(),101) As TodayDate
TodayDate?
$TodayDate=

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	Server?	DBName?
673R	$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	OSMI Report	$ProductCd1=

Delete Bankdata

ddt: DynamicQuery	DELETE A FROM {{Server}}.{{DBName}}.dbo.BankData A WHERE Year = '{{TaxYear}}' and AcctNo = '{{PAN}}' and Product_Cd = '{{Product_Cd}}'
PAN	TaxYear	Server	DBName	Product_Cd
673R	2023	$Server1	$DBName1	$ProductCd1

DeleteOSMIBE

ddt: DynamicQuery	Delete {{Server}}.{{DBName}}.dbo.OSMIBE WHERE YrSeq >= '{{TaxYear}}0'and YrSeq <= '{{TaxYear}}9' and TrustKey in (select TrustKey from {{Server}}.{{DBName}}.dbo.TrustXref Where AcctNo='{{PAN}}') Delete {{Server}}.{{DBName}}.dbo.OSMIBEBankRecip WHERE Year = {{TaxYear}} and AcctNo='{{PAN}}'
PAN	TaxYear	Server	DBName
673R	2023	$Server1	$DBName1

DeleteOrphanRecords[?]

ddt: DynamicQuery	DELETE OPERATIONSDB.dbo.Status WHERE Key_Field like '{{PAN}}%' DELETE {{Server}}.{{DBName}}.dbo.Acct_WIP WHERE AcctNo = '{{PAN}}' AND Year = {{TaxYear}} AND Product_Cd = '{{Product_Cd}}' AND Status_Cd IN('Q','E') DELETE {{Server}}.{{DBName}}.dbo.Acct_WIP WHERE AcctNo = '{{PAN}}' AND Year = {{TaxYear}} AND Product_Cd = '{{Product_Cd}}' AND Status_Cd ='D' Delete {{Server}}.{{DBName}}.dbo.Trust_WIP WHERE Trustkey in (select Trustkey from {{Server}}.{{DBName}}.dbo.TrustXref where AcctNo = '{{PAN}}')
PAN	TaxYear	Server	DBName	Product_Cd
673R	2023	$Server1	$DBName1	$ProductCd1