Included page: .FrontPage.QA.WebDelivery.SetUp (edit)
Contents:
| 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\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2023\BatchAutomation\WebDelivery |
| DownloadPath | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2023\BatchAutomation\WebDelivery |
| ExpectedDir | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2023\BatchAutomation\WebDelivery |
| ActualDir | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2023\BatchAutomation\WebDelivery |
| SourceDirectory | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2023\BatchAutomation\WebDelivery |
| TargetDirectory | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2023\BatchAutomation\WebDelivery |
| CompareResultDir | \ProcessngCompute\Year2020\CompareResult |
| ResultDir | \ProcessngCompute\Year2020\CompareResult |
| ignorePathValidations | false |
| DeleteFile | true |
| Debug | TRUE |
| import |
| TBOT.Generic.Database |
| import |
| TBOT.Generic |
| ddt:DynamicQuery | SELECT A.AcctNo AS PAN,'{{TaxYear}}' AS TAXYR, LTRIM(RTRIM(DB_Name)) as DB_Name, LTRIM(RTRIM(Server)) as Server FROM BTMDB.dbo.PACKAGE A WHERE AcctNo='{{ACCTNO}}' | ||||
| ACCTNO | TaxYear | PAN? | TAXYR? | DB_Name? | Server? |
| 311D | 2024 | $PAN1= | $TAXYR1= | $BANKDB1= | $SRVNAME1= |
| ddt: DynamicQuery | -- get Trust and PAN Details| DECLARE @AccountNumber nvarchar(20) = '{{AccountNumber}}' DECLARE @TrustNumber nvarchar(20) = '{{TrustNumber}}' DECLARE @ProductCd nvarchar(30) = '{{ProductCode}}' DECLARE @ProductOpt nvarchar(20) = '{{ProductOption}}' EXEC AUTOTESTING.[dbo].[QueueCompute] @AcctNo='{{AccountNumber}}', @TrustNo='{{TrustNumber}}', @Year='{{Year}}', @ProductCode='{{ProductCode}}', @ProductOption='{{ProductOption}}',@UseTestForms=1 | |||||
| Comments | AccountNumber | Year | TrustNumber | ProductCode | ProductOption | ComputeStatus? |
| 1041-Federal and state | 311D | 2024 | 000122 | Tax return | Federal and state | Success |
| 1041-Federal and state-Grantor | 311D | 2024 | 0002316910 | Tax return | Federal and state | Success |
| 1041-Federal and state-Agent | 311D | 2024 | 11007954 | Tax return | Federal and state | Success |
| 1041-Federal and state-1042s | 311D | 2024 | 115183006 | Tax return | Federal and state | Success |
| 1041-Federal only | 311D | 2024 | 001444 | Tax return | Federal Only | Success |
| 1041-Federal only-Grantor | 311D | 2024 | 038987004 | Tax return | Federal Only | Success |
| 1041-Federal only-Agent | 311D | 2024 | 101000078540 | Tax return | Federal Only | Success |
| 1041-Federal only-1042s | 311D | 2024 | 000006007 | Tax return | Federal Only | Success |
| 5227 | 311D | 2024 | 000205005 | Tax return | 5227 | Success |
| 1098 | 311D | 2024 | 410220008 | Tax return | 1098 | Success |
| 5498 | 311D | 2024 | 3344765 | Tax return | 5498 | Success |
| 1099 | 311D | 2024 | 00001-30-J | Tax return | 1099 | Success |
| 1099MISC/NEC | 311D | 2024 | 001482 | Tax return | 1099 MISC/NEC | Success |
| DDT:PollingFixture | select * from OPERATIONSDB..Status where Key_Field Like '{{ACCTNO}}%' AND YrSeq='{{TaxYear}}0' and DB_Name='{{DBNAME}}' | ||||
| ACCTNO | TaxYear | DBNAME | PollInterval | MaxInterval | WAITFORDBDELETE? |
| 311D | 2024 | $BANKDB1 | 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