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



All Transactions are deleted in SQL

ddt: DynamicQuery delete FROM {{DB_NAME}}..Trans where TrustKey={{TrustKey}}
Comments# DB_NAME TrustKey
Test0001 $DBName1 $TrustKey1


All PrepNotes[?] are deleted in SQL

ddt: DynamicQuery delete FROM {{DB_NAME}}..PrepNotes where TrustKey={{TrustKey}}
Comments# DB_NAME TrustKey
Test0001 $DBName1 $TrustKey1



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