Included page: .FrontPage.QA.Extensions.SAT.SetUp (edit)

import

TBOT.Generic.Database

ddt: SetUp
key	value
ConnectionString	Server=10.184.25.13,1605;database=AUTOTESTING;User Id=automation; password=automation*100
BytesColumn	DataObject
FileExtension	ZIP
ExpectedDirectory	D:\Installations\FitNesseRoot\files\Extensions\Baseline
DownloadPath	D:\Installations\FitNesseRoot\files\Extensions\Actuals
SourceDirectory	D:\Installations\FitNesseRoot\files\Extensions\Actuals
TargetDirectory	\\C605ZPUOTTFS2.tztst.loc\D_Drive\Trustez\ftp\LocalUser\EFTPS\qa\in
CompareResultDir	D:\Installations\FitNesseRoot\files\Extensions\Result
ignorePathValidations	false
DeleteFile	true

variable defined: PAN=5010
variable defined: TaxYear=2017
variable defined: SettlementDate=08/24/2017

Import Necessary Libraries

import

TBOT.Business

TBOT.Generic.Database

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..Package where AcctNo='{{PAN}}'
Comments#	PAN	TaxYear	SeqNumber	DB_NAME?	AcctNo?	Tax_Year?	Seq_Number?	ActionDate?	Server?
Test0001	5010	2017	1	$DBName1=	$AcctNo1=	$Tax_Year1=	$Seq_Number1=	$Action_DT1=	$Server1=

Mark Filing Record as Un-Filed.

ddt: KeywordFixture	exec {{DBName}}.BANKDB_P.spUpdBankData @AcctNo='{{PAN}}',@Year={{Year}},@SeqNo=1,@ProductCd='N',@ProdOpt=27,@ChngIni='@AJ',@ActionCd=0
Server	DBName	PAN	Year
$Server1	$DBName1	$AcctNo1	$Tax_Year1

Clear all Orphan Records, If Present

ddt: KeywordFixture	UPDATE BTMPRODDB.DBO.EFTPS_WIPHist set Status_Cd='V' WHERE PrimAcct='{{PAN}}' AND Status_Cd <>'V' and ProdOpt='27' AND Product_Cd='N' DELETE FROM {{Server}}.{{DBName}}.dbo.BankData WHERE AcctNo='{{PAN}}' and Year='{{Year}}' and ProdOpt='27' AND Product_Cd='N' DELETE FROM {{Server}}.{{DBName}}.dbo.Acct_WIP WHERE AcctNo='{{PAN}}' and Year='{{Year}}' and ProdOpt='27' AND Product_Cd='N' DELETE FROM OPERATIONSDB.dbo.Status WHERE TrustKey=0 and ProdOpt=27 and Product_Cd='N' AND Process_Cd='520' AND YrSeq='{{Year}}' AND Key_Field='{{PAN}}{{Year}}{{SeqNumber}}EE27N' DELETE FROM {{Server}}.{{DBName}}.dbo.EFTPSSet where PrimAcct='{{PAN}}' and Year='{{Year}}' and Product_Cd='N' delete from {{Server}}.{{DBName}}.dbo.[EFTPSList] where Year='{{Year}}' and product_Cd='N' and trustkey in ('600127','5810109','6568445','7391122','8431857') delete from {{Server}}.{{DBName}}.dbo.Acct_WIP WHERE AcctNo='{{PAN}}' and Year='{{Year}}' and ProdOpt='27' AND Product_Cd='N' delete from OPERATIONSDB.dbo.Status WHERE ProdOpt=27 and Product_Cd='N' AND Process_Cd='520' AND YrSeq='{{Year}}' --AND Key_Field='{{PAN}}{{Year}}{{SeqNumber}}EE27N' delete from {{Server}}.{{DBName}}.dbo.[BatchHistory] where batchopt=1 and AcctNo='{{PAN}}'and BatchType_CD='I'
Server	DBName	PAN	Year	DeleteFolderPath	DeleteAllFiles	FOLDERDELETE?
$Server1	$DBName1	$AcctNo1	$Tax_Year1	\\C605ZPUOTTFS2.tztst.loc\D_Drive\Trustez\ftp\LocalUser\EFTPS\qa\staged	Yes