Included page: .FrontPage.QA.NRARollUp.2023.SetUp (edit)

import
TBOT.Generic.Database

!*****> Setup
ddt: SetUp
key value
ConnectionString Server=10.153.120.216,1600;database=AUTOTESTING;User Id=automation; password=automation*100
BytesColumn DataObject
FileExtension zip
ExpectedDir \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2023\BatchAutomation\NRA-new
ExpectedDirectory \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2023\BatchAutomation\NRA-new\DataFiles
ActualDir \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2023\BatchAutomation\NRA-new
TargetDirectory \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2023\BatchAutomation\NRA-new\DataFiles
ResultDir \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2023\BatchAutomation\NRA-new
DownloadPath \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2023\BatchAutomation\NRA-new\DataFiles
CompareResultDir \FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2021\BatchAutomation\NRA-new
ignorePathValidations false
DeleteFile true
NewYearFlag false
skipIgnorePatterns true

import
TBOT.Generic.Database
TBOT.Generic

Queue Compute Jobs

ddt: DynamicQuery -- get Trust and PAN Details| WAITFOR DELAY '00:00:05' DECLARE @AccountNumber nvarchar(20) = '{{AccountNumber}}' DECLARE @TrustNumber nvarchar(20) = '{{TrustNumber}}' DECLARE @TaxYear int = {{TaxYear}} DECLARE @ProductCd nvarchar(30) = '{{ProductCode}}' DECLARE @ProductOpt nvarchar(20) = '{{ProductOption}}' EXEC AUTOTESTING.[dbo].[DotNetQueueCompute] @AcctNo=@AccountNumber, @TrustNo=@TrustNumber, @Year=@TaxYear, @ProductCode=@ProductCd, @ProductOption=@ProductOpt, @CIF ='968M',@UseTestForms=1
Comments# AccountNumber TrustNumber TaxYear ProductCode ProductOption ComputeStatus?
Fed&State 312G G310010 2023 Tax return Federal and state Success
Fed&State 312G G314490 2023 Tax return Federal and state Success
Fed&State 312G G338013 2023 Tax return Federal and state Success
Fed&State 312G G340599 2023 Tax return Federal and state Success
Fed&State 312G G379493 2023 Tax return Federal and state Success
Fed&State 312G G390545 2023 Tax return Federal and state Success
Fed&State 312G G393826 2023 Tax return Federal and state Success
Fed&State 312G G393834 2023 Tax return Federal and state Success
Fed&State 312G G393837 2023 Tax return Federal and state Success
Fed&State 312G G397843 2023 Tax return Federal and state Success
Fed&State 312G G404824 2023 Tax return Federal and state Success
Fed&State 312G G423257 2023 Tax return Federal and state Success
Fed&State 312G G456683 2023 Tax return Federal and state Success
Fed&State 312G G456968 2023 Tax return Federal and state Success
Fed&State 312G G457873 2023 Tax return Federal and state Success
Fed&State 312G G458166 2023 Tax return Federal and state Success
Fed&State 312G G496920 2023 Tax return Federal and state Success
Fed&State 312G G623113 2023 Tax return Federal and state Success
Fed&State 312G G636925 2023 Tax return Federal and state Success
Fed&State 312G G644564 2023 Tax return Federal and state Success

DDT:PollingFixture select * from OPERATIONSDB..Status where Process_Cd=301 and Product_Cd='B' AND ProdOpt=0 and Key_Field Like '{{ACCTNO}}%' AND YrSeq='{{TaxYear}}0'
ACCTNO TaxYear PollInterval MaxInterval WAITFORDBDELETE?
312G 2023 2 120 True