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 |
Keyboard Shortcuts ?
General
- t Test page or suite
- e Edit page
- v View page (after test)
- a Add new page
Go To
- g u User Guide
- g q Quick Reference Guide
- g f Full Reference Guide
- g c Recent Changes
Edit Mode
- CTRL+s Save page
- ESC Cancel edit
Tools
- p Properties
- w Where used?
- AK+v Versions
- AK+h Page History
- / Focus on search bar
- s Open search page