Included page: .FrontPage.SAT.BalanceDue.SetUp (edit)

import
TBOT.Generic.Database


ddt: SetUp
key value
ConnectionString Server=10.184.25.4,1605;database=AUTOTESTING;User Id=automation; password=automation*100; Timeout=30
BytesColumn DataObject
FileExtension ZIP
ExpectedDirectory \\C605ZPUOTTFS2.tztst.loc\_QATeam\git\data-ott\IntegrationTests\BaselineFiles\Baseline\files\SAT\YrSpecSuites\2017\BatchAutomation\BalanceDue
DownloadPath \\C605ZPUOTTFS2.tztst.loc\_QATeam\FitnesseTestArtifacts\files\Actuals\SAT\YrSpecSuites\2017\BatchAutomation\BalanceDue\Actuals
SourceDirectory \\C605ZPUOTTFS2.tztst.loc\_QATeam\FitnesseTestArtifacts\files\Actuals\SAT\YrSpecSuites\2017\BatchAutomation\BalanceDue\Actuals
TargetDirectory \\C605ZPUOTTFS2.tztst.loc\D_Drive\Trustez\ftp\LocalUser\EFTPS\qa\in
CompareResultDir \\C605ZPUOTTFS2.tztst.loc\_QATeam\FitnesseTestArtifacts\files\Results\SAT\YrSpecSuites\2017\BatchAutomation\BalDues
ignorePathValidations false
DeleteFile true

import
TBOT.Generic.Database

> 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 2017 1 1 $DBName1= $Server1= $AcctNo1= $Tax_Year1= $Seq_Number1= $SetDate1=

Get Filename


Get Filename


ddt: DynamicQuery declare @filename nvarchar(max) set @filename = '{{FileVal}}' select @filename as FileName
Comments# FileVal FileName?
Test0001 massachusettsActual.txt $File1=


Capturing Action Date


Execute BTMDB..Package


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 2017 1 $DBName1= $AcctNo1= $Tax_Year1= $Seq_Number1= $Action_DT1=



Download File


Download Block


DDT: KeywordFixture SELECT DataObject, Action_Cd, CONVERT(varchar(10),Action_DT,111) as Action_DT FROM {{DataBaseName}}.dbo.BankData WHERE AcctNo='{{PAN}}' and Year={{TaxYear}} and State='MA' and ProdOpt=107 and SeqNo='{{SeqNumber}}'
Comment PAN TaxYear SeqNumber DataBaseName FileName Action_Cd? Action_DT? DataObject? DOWNLOAD? DateInput DateFormat FORMATDATE?
Test0001 $AcctNo1 $Tax_Year1 $Seq_Number1 $DBName1 $File1 1 $Action_DT1 System.Byte[] True $SetDate1 MMddyyyy $FormateDate1=


Validate Filing Status


ddt:DynamicQuery EXEC {{DataBaseName}}.BANKDB_P.spGetBalDueFilingData '{{PAN}}', {{YEAR}},{{SeqNumber}} Filing = 'Massachusetts'
Comments# PAN YEAR SeqNumber DataBaseName FilingType IsFiled?
Test0001 5010 2017 $Seq_Number1 $DBName1 Massachusetts True

******!

File Compare

!*****> Compare two Files
TBOT.Generic.SFTP
Comments sourceFile destinationFile resultFileName IgnorePattern compareFiles?
Test0001 massachusettsBase.txt $File1 $FormateDate1;10062017 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
Close