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 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='F',@ProdOpt=27,@ChngIni='@SP',@ActionCd=0
Server	DBName	PAN	Year
$Server1	$DBName1	$AcctNo1	$Tax_Year1

Deleting Record from operationsdb.

ddt: KeywordFixture	delete from operationsdb..status where product_cd = 'F' and yrseq = '{{Year}}'
Server	DBName	PAN	Year
$Server1	$DBName1	$AcctNo1	$Tax_Year1

Clear all Orphan Records, If Present

ddt: KeywordFixture	delete from {{Server}}.{{DBName}}.dbo.[EFTPSList] where Year='{{Year}}' and product_Cd='F' and trustkey in ('326671780','201301218','982137025','862957240','238013685','997793079') delete from {{Server}}.{{DBName}}.dbo.[EFTPSSet] where Year='{{Year}}' and product_Cd='F' and PrimAcct='{{PAN}}' delete from {{Server}}.{{DBName}}.dbo.eftpsset where PrimAcct='{{PAN}}' and year = '{{Year}}' and product_Cd = 'F' delete from {{Server}}.{{DBName}}.dbo.eftpslist where yrseq = '20170' and product_Cd = 'F' UPDATE BTMPRODDB.DBO.EFTPS_WIPHist set Status_Cd='V' WHERE PrimAcct='{{PAN}}' AND Status_Cd <>'V' and ProdOpt='27' AND Product_Cd='F' delete from {{Server}}.{{DBName}}.dbo.BankData WHERE AcctNo='{{PAN}}' and Year='{{Year}}' and ProdOpt='27' AND Product_Cd='F' delete from {{Server}}.{{DBName}}.dbo.Acct_WIP WHERE AcctNo='{{PAN}}' and Year='{{Year}}' and ProdOpt='27' AND Product_Cd='F' delete from OPERATIONSDB.dbo.Status WHERE ProdOpt=27 and Product_Cd='F' AND Process_Cd='520' AND YrSeq='{{Year}}' --AND Key_Field='{{PAN}}{{Year}}{{SeqNumber}}EE27F' --delete from {{Server}}.{{DBName}}.dbo.[BatchHistory] where batchopt=1 and AcctNo='{{PAN}}'and BatchType_CD='M'
Server	DBName	PAN	Year	DeleteFolderPath	DeleteAllFiles	FOLDERDELETE?
$Server1	$DBName1	$AcctNo1	$Tax_Year1	\\C605ZPUOTTFS2.tztst.loc\D_Drive\Trustez\ftp\LocalUser\EFTPS\qa\staged	Yes