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

import

TBOT.Business

TBOT.Generic.Database

TBOT.Generic.PDF

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=

Download OSMI Text Report

DDT: KeywordFixture	WAITFOR DELAY '00:00:15' use {{DBName}} select DataObject from bankdata where acctno='{{PAN}}' and year='{{TaxYear}}' and state='{{State}}' and prodopt=1 and Product_CD='{{ProductCd}}' and Object_Cd=0 and SeqNo=1
Comment	PAN	TaxYear	DBName	FileName	DOWNLOAD?	UNZIP?	GETFILES?	State	ProductCd
Test0001	673R	2023	$DBName1	StateCA.zip	True	True	$EDIFile1=	CA	$ProductCd1
Test0002	673R	2023	$DBName1	StateCT.zip	True	True	$EDIFile2=	CT	$ProductCd1
Test0003	673R	2023	$DBName1	StateMA.zip	True	True	$EDIFile3=	MA	$ProductCd1
Test0004	673R	2023	$DBName1	StateMN.zip	True	True	$EDIFile4=	MN	$ProductCd1
Test0005	673R	2023	$DBName1	StateMT.zip	True	True	$EDIFile5=	MT	$ProductCd1
Test0006	673R	2023	$DBName1	StateNY.zip	True	True	$EDIFile6=	NY	$ProductCd1

OSMI Report Text Comparison

File Compare Block

TBOT.Generic.SFTP
Comments	sourceFile	destinationFile	destinationFullFilePath	resultFileName	IgnorePattern	compareFiles?
Test0001	673R_StateCACorrected.txt	$EDIFile1	Yes			Both Files are Equal
Test0002	673R_StateCTCorrected.txt	$EDIFile2	Yes			Both Files are Equal
Test0003	673R_StateMACorrected.txt	$EDIFile3	Yes			Both Files are Equal
Test0004	673R_StateMNCorrected.txt	$EDIFile4	Yes			Both Files are Equal
Test0005	673R_StateMTCorrected.txt	$EDIFile5	Yes			Both Files are Equal
Test0006	673R_StateNYCorrected.txt	$EDIFile6	Yes			Both Files are Equal

OSMI PDF Report Comparison

PDF Compare Block

DDT: PDFFixture	Query	declare @p9 int exec OPERATIONSDB.OPERATIONSDB_P.spUpdInsStatusDoc @JobStatus=1, @AcctNo='{{PAN}}', @TrustNo='-999 ', @JobIP='', @PrintDataKey='PSRV1;{{BANKDB}};{{Year}};{{Product_Cd}};1;1;1;{{State}}; ;', @JobTypeCd=4, @JobParm1='', @PrintData='', @ApplID='TEZ', @JobID=@p9 output WAITFOR DELAY '00:00:10' SELECT PDF_File FROM OPERATIONSDB..StatusDoc where JobID=@p9 AND JobStatus=3
PAN	Year	BANKDB	State	Product_Cd	expectedPDF	actualPDF	generatePDF?	comparePDF?
673R	2023	$DBName1	CA	$ProductCd1	673R_StateCACorrected.pdf	OSMI_StateCACorrected.pdf	True	True
673R	2023	$DBName1	CT	$ProductCd1	673R_StateCTCorrected.pdf	OSMI_StateCTCorrected.pdf	True	True
673R	2023	$DBName1	MA	$ProductCd1	673R_StateMACorrected.pdf	OSMI_StateMACorrected.pdf	True	True
673R	2023	$DBName1	MT	$ProductCd1	673R_StateMNCorrected.pdf	OSMI_StateMNCorrected.pdf	True	True
673R	2023	$DBName1	MN	$ProductCd1	673R_StateMTCorrected.pdf	OSMI_StateMTCorrected.pdf	True	True
673R	2023	$DBName1	NY	$ProductCd1	673R_StateNYCorrected.pdf	OSMI_StateNYCorrected.pdf	True	True