Included page: .FrontPage.QA.Transactions.2025.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; TrustServerCertificate=true
BytesColumn DataObject
FileExtension ZIP
ExpectedDirectory \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2025\BatchAutomation\Transactions
DownloadPath \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2025\BatchAutomation\Transactions
SourceDirectory \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2025\BatchAutomation\Transactions
CompareResultDir \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2025\BatchAutomation\Transactions
ExpectedDir \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2025\BatchAutomation\Transactions
ActualDir \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2025\BatchAutomation\Transactions
ResultDir \\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2025\BatchAutomation\Transactions
Debug TRUE
ignorePathValidations false
DeleteFile true

import
TBOT.Generic.Database

import
TBOT.Generic


ddt:KeywordFixture SELECT LTRIM(RTRIM(DB_NAME)) as DB_NAME, AcctNo from BTMDB..Package where AcctNo='{{PAN}}'
Comments# PAN DB_NAME? AcctNo?
New 311D $DBName1= $AcctNo1=


ddt:KeywordFixture SELECT TrustKey from {{DB_NAME}}..TrustXref where TrustNo='{{TrustNo}}'
Comments# PAN TrustNo DB_NAME AcctNo TrustKey?
New 311D TRANSACTION-9 $DBName1 $AcctNo1 $TrustKey1=


Select Active Transaction

ddt:KeywordFixture select TranSeq from {{DB_NAME}}.dbo.trans where TrustKey = {{TrustKey}} and chngType !=3 order by TranSeq desc
Comments# DB_NAME TrustKey TranSeq?
Transaction1 $DBName1 $TrustKey1 $Transeq1=


Delete Transaction

ddt:KeywordFixture exec {{DB_NAME}}.BANKDB_P.spUpdTrans @TrustKey={{TrustKey}},@TranSeq={{TranSeq}},@ChngIni='ACS',@ChngType=3
Comments# PAN TrustKey DB_NAME TranSeq
Transaction1 311D $TrustKey1 $DBName1 $Transeq1


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