Included page: .FrontPage.QA.BalanceDue.2020.QA.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=30 |
| BytesColumn | DataObject |
| FileExtension | ZIP |
| ExpectedDirectory | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2020\BatchAutomation\BalanceDue |
| DownloadPath | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2020\BatchAutomation\BalanceDue\Actuals |
| SourceDirectory | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2020\BatchAutomation\BalanceDue\Actuals |
| TargetDirectory | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\D_Drive\Trustez\ftp\LocalUser\EFTPS\qa\in |
| CompareResultDir | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2020\BatchAutomation\BalanceDue |
| ExpectedDir | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2020\BatchAutomation\BalanceDue |
| ActualDir | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2020\BatchAutomation\BalanceDue\Actuals |
| ResultDir | \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2020\BatchAutomation\BalanceDue |
| Debug | TRUE |
| ignorePathValidations | false |
| DeleteFile | true |
> Execute BTM Package
| ddt: KeywordFixture | SELECT DB_NAME , LTRIM(RTRIM(Server)) as Server, AcctNo,'{{TaxYear}}' AS Tax_Year, '{{SeqNumber}}' as Seq_Number from BTMDB..Package where AcctNo='{{PAN}}' | |||||||||
| Comments# | PAN | TaxYear | SeqNumber | WorkingDayStartCount | DB_NAME? | Server? | AcctNo? | Tax_Year? | Seq_Number? | GETNEXTWORKINGDAY? |
| Test0001 | 5010 | 2020 | 1 | 1 | $DBName1= | $Server1= | $AcctNo1= | $Tax_Year1= | $Seq_Number1= | $SetDate1= |
Get Filename
| ddt: DynamicQuery | declare @filename nvarchar(max) set @filename = '{{FileVal}}' select @filename as FileName | |
| Comments# | FileVal | FileName? |
| Test0001 | MinnesotaActual.txt | $File1= |
Capturing Action Date
| ddt: DynamicQuery | SELECT LTRIM(RTRIM(Server)) AS Server, LTRIM(RTRIM(DB_NAME)) AS DB_NAME , AcctNo,'{{TaxYear}}' AS Tax_Year, '{{SeqNumber}}' as Seq_Number, CONVERT(varchar(10),getdate(),111) as ActionDate FROM BTMDB.dbo.Package WHERE AcctNo='{{PAN}}' | |||||||
| Comments# | PAN | TaxYear | SeqNumber | DB_NAME? | AcctNo? | Tax_Year? | Seq_Number? | ActionDate? |
| Test0001 | 5010 | 2020 | 1 | $DBName1= | $AcctNo1= | $Tax_Year1= | $Seq_Number1= | $Action_DT1= |
> Download Block
| DDT: KeywordFixture | SELECT DataObject, Action_Cd,DataObject,CONVERT(varchar(10),Action_DT,111) as Action_DT FROM {{DataBaseName}}.dbo.bankdata WHERE acctno='{{PAN}}' and year={{TaxYear}} and state='MN' and prodopt=107 and SeqNo={{SeqNumber}} and Product_CD='F' | ||||||||
| Comment | PAN | TaxYear | SeqNumber | DataBaseName | FileName | Action_Cd? | Action_DT? | DataObject? | DOWNLOAD? |
| Test0001 | $AcctNo1 | $Tax_Year1 | $Seq_Number1 | $DBName1 | $File1 | 1 | $Action_DT1 | System.Byte[] | True |
> Failing status Validations
| ddt:DynamicQuery | EXEC {{DataBaseName}}.BANKDB_P.spGetBalDueFilingData '{{PAN}}', {{YEAR}},{{SeqNumber}} | Filing = 'Minnesota' | ||||
| Comments# | PAN | YEAR | SeqNumber | DataBaseName | FilingType | IsFiled? |
| Test0001 | 5010 | 2020 | $Seq_Number1 | $DBName1 | Minnesota | True |
> File Compare
| TBOT.Generic.SFTP | |||||
| Comments | sourceFile | destinationFile | resultFileName | IgnorePattern | compareFiles? |
| Test0001 | MinnesotaBase.txt | $File1 | 11/05/2020;$SetDate1 | Both Files are Equal | |
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