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
TBOT.Generic.Database

import
TBOT.Generic

Queue Compute Jobs

ddt: KeywordFixture -- get Trust and PAN Details| 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,@UseTestForms=1
Comments# AccountNumber TrustNumber TaxYear ProductCode ProductOption ComputeStatus?
Test001 673R OSMIAUTO001 2023 Tax return 1099 Success
Test002 673R OSMIAUTOCA 2023 Tax return 1099 Success
Test003 673R OSMIAUTOCT 2023 Tax return 1099 Success
Test004 673R OSMIAUTOMA 2023 Tax return 1099 Success
Test005 673R OSMIAUTOMN 2023 Tax return 1099 Success
Test006 673R OSMIAUTOMT 2023 Tax return 1099 Success
Test007 673R OSMIAUTONY 2023 Tax return 1099 Success
Test008 673R OSMIAUTORI 2023 Tax return 1099 Success



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?
673R 2023 $PAN1= $TAXYR1= $BANKDB1= $SRVNAME1=


ddt:PollingFixture select * from OPERATIONSDB.dbo.Status where Process_Cd=301 and Product_Cd='B' AND ProdOpt=4 and Key_Field Like '{{ACCTNO}}%' AND YrSeq='{{TaxYear}}0' and DB_Name='{{DBNAME}}'
ACCTNO TaxYear DBNAME PollInterval MaxInterval WAITFORDBDELETE?
673R 2023 $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
Close