Included page: .FrontPage.QA.OSMI-OutOfStateMunicipalIncome.2021.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

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

UpdateOSMIBE

ddt: DynamicQuery	Update {{Server}}.{{DBName}}.dbo.OSMIBE SET Filing_Dt = null WHERE YrSeq >= '{{TaxYear}}0'and YrSeq <= '{{TaxYear}}9' and Filing_Dt is not Null and TrustKey in (select OSMIBE.TrustKey from {{Server}}.{{DBName}}.dbo.OSMIBE Join {{Server}}.{{DBName}}.dbo.TrustXref On OSMIBE.TrustKey=TrustXref.TrustKey)
PAN	TaxYear	Server	DBName
673R	2023	$Server1	$DBName1

DeleteOrphanRecords[?]

ddt: DynamicQuery	DELETE OPERATIONSDB.dbo.Status WHERE Key_Field = '{{PAN}}U' 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'
PAN	TaxYear	Server	DBName	Product_Cd
673R	2023	$Server1	$DBName1	$ProductCd1