FrontPage.QA.Archive.ROC.ROCTestCases.TC8

Included page: .FrontPage.QA.Archive.ROC.ROCTestCases.SetUp (edit)

variable defined: expectedPdfDirectory=D:\Installations\FitNesseRoot\files\TrustTax\ProcessngCompute\Year2017\BaselinePDF
variable defined: actualPdfDirectory=D:\Installations\FitNesseRoot\files\TrustTax\ProcessngCompute\Year2017\Actuals
variable defined: comparePdfDirectory=D:\Installations\FitNesseRoot\files\TrustTax\ProcessngCompute\Year2017\CompareResult

variable defined: expectedPdfDirectory=G:\git\data-ott\IntegrationTests\BaselineFiles\Baseline\QA\YrSpecSuites\2017\BatchAutomation\Compute
variable defined: actualPdfDirectory=G:\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2017\BatchAutomation\ROC\Actuals
variable defined: comparePdfDirectory=\ProcessngCompute\Year2017\ROC\Result

import

TBOT.Generic.Database

ddt: SetUp
key	value
ConnectionString	Server=10.184.25.4,1601;database=AUTOTESTING;User Id=automation; password=automation*100
ExpectedDir	G:\git\data-ott\IntegrationTests\BaselineFiles\Baseline\QA\YrSpecSuites\2017\BatchAutomation\Compute
ActualDir	G:\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2017\BatchAutomation\ROC\Actuals
ResultDir	\ProcessngCompute\Year2017\ROC\Result
NewYearFlag	True

!******>ROC Date

ddt:DynamicQuery	Select convert(varchar(10),getdate(),101) As ROCDate
ROCDate?
$RocDate=

import

TBOT.Generic.PDF

Check Compute and TFDOC Status

DDT: DynamicQuery	SELECT A.ComputeFlag,A.TFDocFlag,TFDocJobId as JobID FROM AUTOTESTING.dbo.ComputeStats A WHERE A.AcctNo='{{AcctNo}}' AND A.TrustNo='{{TrustNo}}' AND A.YrSeq like'2017%' AND A.ProductCode='{{ProductCode}}' AND A.ProductOption='{{ProductOption}}'
AcctNo	TrustNo	ProductCode	ProductOption	ComputeFlag?	TFDocFlag?	JobID?
310Y	MASTERACCT	Worksheet		True	True	$JobID1=
310Y	RECIEVER1	Worksheet		True	True	$JobID2=
310Y	RECIEVER2	Worksheet		True	True	$JobID3=

DDT:PDFFixture	Query	SELECT PDF_File FROM OPERATIONSDB.dbo.StatusDoc WHERE JobID='{{JobID}}'
JobID	expectedPDF	actualPDF	generatePDF?	comparePDF?
$JobID1	TaxReturn\310Y_MASTERACCT_ws_20170_0_0_1_0.pdf	MASTERACCT.pdf	True	True
$JobID2	TaxReturn\310Y_RECIEVER1_ws_20170_0_0_1_0.pdf	RECIEVER1.pdf	True	True
$JobID3	TaxReturn\310Y_RECIEVER2_ws_20170_0_0_1_0.pdf	RECIEVER2.pdf	True	True

Keyboard Shortcuts ?

General

Go To

Edit Mode

Tools

Keyboard Shortcuts `?`