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 G836186 2023 Tax return Federal and state Success
Fed&State 312G G942138 2023 Tax return Federal and state Success
Fed&State 312G G253010 2023 Tax return Federal and state Success
Fed&State 312G G563149 2023 Tax return Federal and state Success
Fed&State 312G G788075 2023 Tax return Federal and state Success
Fed&State 312G G635226 2023 Tax return Federal and state Success
Fed&State 312G G646851 2023 Tax return Federal and state Success
Fed&State 312G G001779 2023 Tax return Federal and state Success
Fed&State 312G G001982A 2023 Tax return Federal and state Success
Fed&State 312G G005502 2023 Tax return Federal and state Success
Fed&State 312G G015045 2023 Tax return Federal and state Success
Fed&State 312G G015050 2023 Tax return Federal and state Success
Fed&State 312G G017175 2023 Tax return Federal and state Success
Fed&State 312G G109866 2023 Tax return Federal and state Success
Fed&State 312G G168318 2023 Tax return Federal and state Success
Fed&State 312G G168321 2023 Tax return Federal and state Success
Fed&State 312G G168322 2023 Tax return Federal and state Success
Fed&State 312G G236055 2023 Tax return Federal and state Success
Fed&State 312G G236332 2023 Tax return Federal and state Success
Fed&State 312G G298122 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