Included page: .FrontPage.QA.Archive.TrustLoad.AutoLoad.QA.LoadAssertions.SuiteSetUp (edit)
| import |
| TBOT.Generic.Database |
| ddt: SetUp | |
| key | value |
| ConnectionString | Server=10.184.25.4,1601;database=AUTOTESTING;User Id=automation; password=automation*100 |
| RightConnection | Server=10.184.25.4,1601;database=AUTOTESTING;User Id=automation; password=automation*100 |
| BaseDir | D:\Installations\FitNesseRoot\files\CompareTables\BaseLine |
| ActualDir | D:\Installations\FitNesseRoot\files\CompareTables\Actuals |
| ResultDir | D:\_WebAPP\Files\DataLoad |
| CompareVersion | v2 |
| import |
| TBOT.Generic |
Get Details for Files that needs to be validated.
| ddt: DynamicQuery | select AcctNo as MainAcctNo , LTRIM(RTRIM(A.DB_Name)) DB_NAME, LTRIM(RTRIM(Server)) as SERVER, '{{FileName}}' as LoadFileName, '{{BaslineTapeId}}' as BaslineTapeId, '{{PAN1}}' as AcctNo, '{{NETSEQNO}}' AS RightSeqNo FROM BTMDB..Package A WHERE AcctNo='{{PAN}}' | ||||||||||||
| Comments# | PAN | PAN1 | NETSEQNO | FileName | BaslineTapeId | DB_NAME? | SERVER? | AcctNo? | BaslineTapeId? | MainAcctNo? | LoadFileName? | RightSeqNo? | AcctNo? |
| Test0001 | P61Y | P61Y | 3 | TP61Y0002_20171201_1507.TAP | 2017-12-01 15:12:00.000 | $DBName1= | $Server1= | $AcctNo1= | $BaslineTapeId1= | $AcctNo1= | $LoadFileName1= | $RightSeqNo1= | $AcctNoSub1= |
| Test0002 | 590Y | 590Y | 2 | T590Y2429_20170701_1146.TA1 | 2017-12-06 16:13:00.000 | $DBName2= | $Server2= | $AcctNo2= | $BaslineTapeId2= | $AcctNo2= | $LoadFileName2= | $RightSeqNo2= | $AcctNoSub2= |
| Test0003 | 965H | 965H | 2 | T965H0221_20170801_0941.TA1 | 2017-12-06 10:04:00.000 | $DBName3= | $Server3= | $AcctNo3= | $BaslineTapeId3= | $AcctNo3= | $LoadFileName3= | $RightSeqNo3= | $AcctNoSub3= |
| Test0004 | A541 | A541 | 4 | TA5410293_20170705_1449.TA1 | 2017-12-06 14:22:00.000 | $DBName4= | $Server4= | $AcctNo4= | $BaslineTapeId4= | $AcctNo4= | $LoadFileName4= | $RightSeqNo4= | $AcctNoSub4= |
| Test0005 | 9078 | 9078 | 3 | T90780622_20170707_1220.TA1 | 2017-12-06 14:58:00.000 | $DBName5= | $Server5= | $AcctNo5= | $BaslineTapeId5= | $AcctNo5= | $LoadFileName5= | $RightSeqNo5= | $AcctNoSub5= |
| Test0006 | 5889 | 5889 | 4 | T653T0563_20170728_0656.TA1 | 2017-12-08 10:00:00.000 | $DBName6= | $Server6= | $AcctNo6= | $BaslineTapeId6= | $AcctNo6= | $LoadFileName6= | $RightSeqNo6= | $AcctNoSub6= |
| Test0007 | 5889 | 653T | 4 | T653T0563_20170728_0656.TA1 | 2017-12-08 10:00:00.000 | $DBName7= | $Server7= | $AcctNo7= | $BaslineTapeId7= | $AcctNo7= | $LoadFileName7= | $RightSeqNo7= | $AcctNoSub7= |
| Test0008 | 675K | 675K | 9 | T675K0262_20170711_1352.TA1 | 2017-12-11 09:33:00.000 | $DBName8= | $Server8= | $AcctNo8= | $BaslineTapeId8= | $AcctNo8= | $LoadFileName8= | $RightSeqNo8= | $AcctNoSub8= |
| Test0009 | 675K | 675K | 10 | T675K0263_20170816_1035.TA1 | 2017-12-11 09:39:00.000 | $DBName9= | $Server9= | $AcctNo9= | $BaslineTapeId9= | $AcctNo9= | $LoadFileName9= | $RightSeqNo9= | $AcctNoSub9= |
| Test00010 | P11A | P11A | 37 | P11A_LD1_20170524102842_Sanitized_1Acct_201712111436 | 2017-12-08 17:21:00.000 | $DBName10= | $Server10= | $AcctNo10= | $BaslineTapeId10= | $AcctNo10= | $LoadFileName10= | $RightSeqNo10= | $AcctNoSub10= |
| Test00011 | P11A | P11A | 38 | P11A_TM1_8KN15J_201710181412_201712111439 | 2017-12-08 17:22:00.000 | $DBName11= | $Server11= | $AcctNo11= | $BaslineTapeId11= | $AcctNo11= | $LoadFileName11= | $RightSeqNo11= | $AcctNoSub11= |
| Test00012 | Q29P | Q29P | 93 | Q29P_ADK_20170310151327_201703101428_201712111448 | 2017-12-08 17:21:00.000 | $DBName12= | $Server12= | $AcctNo12= | $BaslineTapeId12= | $AcctNo12= | $LoadFileName12= | $RightSeqNo12= | $AcctNoSub12= |
| Test00013 | Q29P | Q29P | 94 | Q29P_111_TQ29P16909_20170311_0846_201712111554 | 2017-12-11 11:40:00.000 | $DBName13= | $Server13= | $AcctNo13= | $BaslineTapeId13= | $AcctNo13= | $LoadFileName13= | $RightSeqNo13= | $AcctNoSub13= |
| Test00014 | Q29P | Q29P | 95 | Q29P_111_TQ29P18068_20170808_0902_201712111610 | 2017-12-08 12:07:00.000 | $DBName14= | $Server14= | $AcctNo14= | $BaslineTapeId14= | $AcctNo14= | $LoadFileName14= | $RightSeqNo14= | $AcctNoSub14= |
| Test00015 | K482 | 569N | 18 | PG4_20170401_20170430.BRIDGE | 2017-12-14 15:39:00.000 | $DBName15= | $Server15= | $AcctNo15= | $BaslineTapeId15= | $AcctNo15= | $LoadFileName15= | $RightSeqNo15= | $AcctNoSub15= |
| Test00016 | K482 | 569N | 19 | T569N1172_20170606_0802.TA1 | 2017-12-14 16:00:00.000 | $DBName16= | $Server16= | $AcctNo16= | $BaslineTapeId16= | $AcctNo16= | $LoadFileName16= | $RightSeqNo16= | $AcctNoSub16= |
| Test00017 | 9155 | 970F | 74 | FTX515L_20170504_160044.DAT | 2017-12-15 14:17:00.000 | $DBName17= | $Server17= | $AcctNo17= | $BaslineTapeId17= | $AcctNo17= | $LoadFileName17= | $RightSeqNo17= | $AcctNoSub17= |
| Test00018 | 9155 | 970F | 75 | T970F0324_20170608_0931.TA1 | 2017-12-15 15:24:00.000 | $DBName18= | $Server18= | $AcctNo18= | $BaslineTapeId18= | $AcctNo18= | $LoadFileName18= | $RightSeqNo18= | $AcctNoSub18= |
| Test00019 | U415 | 341U | 104 | JJ370FFD1_201705030440 | 2017-12-13 09:00:00.000 | $DBName19= | $Server19= | $AcctNo19= | $BaslineTapeId19= | $AcctNo19= | $LoadFileName19= | $RightSeqNo19= | $AcctNoSub19= |
| Test00020 | U415 | 341U | 106 | T341U3065_20170615_0715.TA1 | 2017-12-13 11:12:00.000 | $DBName20= | $Server20= | $AcctNo20= | $BaslineTapeId20= | $AcctNo20= | $LoadFileName20= | $RightSeqNo20= | $AcctNoSub20= |
| Test00021 | D99V | D99V | 11 | TD99V0107_20170104_0754.TA1 | 2017-12-18 09:05:00.000 | $DBName21= | $Server21= | $AcctNo21= | $BaslineTapeId21= | $AcctNo21= | $LoadFileName21= | $RightSeqNo21= | $AcctNoSub21= |
| Test00022 | 5897 | 501G | 7 | T501G0839_20170701_1101.TA1 | 2017-12-18 11:31:00.000 | $DBName22= | $Server22= | $AcctNo22= | $BaslineTapeId22= | $AcctNo22= | $LoadFileName22= | $RightSeqNo22= | $AcctNoSub22= |
| Test00023 | 5897 | 501G | 9 | T501G0840_20170701_1102.TA1 | 2017-12-18 11:51:00.000 | $DBName23= | $Server23= | $AcctNo23= | $BaslineTapeId23= | $AcctNo23= | $LoadFileName23= | $RightSeqNo23= | $AcctNoSub23= |
| Test00024 | 2680 | 2680 | 11 | T26804419_20170712_1016.TA1 | 2017-12-19 11:42:00.000 | $DBName24= | $Server24= | $AcctNo24= | $BaslineTapeId24= | $AcctNo24= | $LoadFileName24= | $RightSeqNo24= | $AcctNoSub24= |
| Test00025 | 2680 | 2680 | 12 | T26804427_20170713_1231.TA1 | 2017-12-19 13:16:00.000 | $DBName25= | $Server25= | $AcctNo25= | $BaslineTapeId25= | $AcctNo25= | $LoadFileName25= | $RightSeqNo25= | $AcctNoSub25= |
| ddt: DynamicQuery | select top 1 B.*, LTRIM(RTRIM(A.DB_Name)) DB_NAME, LTRIM(RTRIM(Server)) as SERVER, '{{BaslineTapeId}}' as BaslineTapeId FROM BTMDB..Package A JOIN {{SERVERNAME}}.OPERATIONSDB.DBO.LoadStats B ON A.AcctNo=B.AcctNo WHERE OrigFile='{{FileName}}' and B.MainAcct='{{PAN}}' AND B.AcctNo='{{PAN1}}' AND B.SeqNo='{{SeqNo}}' ORDER BY SeqNo Desc | ||||||||
| Comments# | PAN | PAN1 | SeqNo | SERVERNAME | FileName | BaslineTapeId | DB_NAME? | SERVER? | SeqNo? |
| Test0001 | $AcctNo1 | $AcctNoSub1 | $RightSeqNo1 | $Server1 | $LoadFileName1 | $BaslineTapeId1 | $DBName1= | $Server1= | $SeqNo1= |
| Test0002 | $AcctNo2 | $AcctNoSub2 | $RightSeqNo2 | $Server2 | $LoadFileName2 | $BaslineTapeId2 | $DBName2= | $Server2= | $SeqNo2= |
| Test0003 | $AcctNo3 | $AcctNoSub3 | $RightSeqNo3 | $Server3 | $LoadFileName3 | $BaslineTapeId3 | $DBName3= | $Server3= | $SeqNo3= |
| Test0004 | $AcctNo4 | $AcctNoSub4 | $RightSeqNo4 | $Server4 | $LoadFileName4 | $BaslineTapeId4 | $DBName4= | $Server4= | $SeqNo4= |
| Test0005 | $AcctNo5 | $AcctNoSub5 | $RightSeqNo5 | $Server5 | $LoadFileName5 | $BaslineTapeId5 | $DBName5= | $Server5= | $SeqNo5= |
| Test0006 | $AcctNo6 | $AcctNoSub6 | $RightSeqNo6 | $Server6 | $LoadFileName6 | $BaslineTapeId6 | $DBName6= | $Server6= | $SeqNo6= |
| Test0007 | $AcctNo7 | $AcctNoSub7 | $RightSeqNo7 | $Server7 | $LoadFileName7 | $BaslineTapeId7 | $DBName7= | $Server7= | $SeqNo7= |
| Test0008 | $AcctNo8 | $AcctNoSub8 | $RightSeqNo8 | $Server8 | $LoadFileName8 | $BaslineTapeId8 | $DBName8= | $Server8= | $SeqNo8= |
| Test0009 | $AcctNo9 | $AcctNoSub9 | $RightSeqNo9 | $Server9 | $LoadFileName9 | $BaslineTapeId9 | $DBName9= | $Server9= | $SeqNo9= |
| Test00010 | $AcctNo10 | $AcctNoSub10 | $RightSeqNo10 | $Server10 | $LoadFileName10 | $BaslineTapeId10 | $DBName10= | $Server10= | $SeqNo10= |
| Test00011 | $AcctNo11 | $AcctNoSub11 | $RightSeqNo11 | $Server11 | $LoadFileName11 | $BaslineTapeId11 | $DBName11= | $Server11= | $SeqNo11= |
| Test00012 | $AcctNo12 | $AcctNoSub12 | $RightSeqNo12 | $Server12 | $LoadFileName12 | $BaslineTapeId12 | $DBName12= | $Server12= | $SeqNo12= |
| Test00013 | $AcctNo13 | $AcctNoSub13 | $RightSeqNo13 | $Server13 | $LoadFileName13 | $BaslineTapeId13 | $DBName13= | $Server13= | $SeqNo13= |
| Test00014 | $AcctNo14 | $AcctNoSub14 | $RightSeqNo14 | $Server14 | $LoadFileName14 | $BaslineTapeId14 | $DBName14= | $Server14= | $SeqNo14= |
| Test00015 | $AcctNo15 | $AcctNoSub15 | $RightSeqNo15 | $Server15 | $LoadFileName15 | $BaslineTapeId15 | $DBName15= | $Server15= | $SeqNo15= |
| Test00016 | $AcctNo16 | $AcctNoSub16 | $RightSeqNo16 | $Server16 | $LoadFileName16 | $BaslineTapeId16 | $DBName16= | $Server16= | $SeqNo16= |
| Test00017 | $AcctNo17 | $AcctNoSub17 | $RightSeqNo17 | $Server17 | $LoadFileName17 | $BaslineTapeId17 | $DBName17= | $Server17= | $SeqNo17= |
| Test00018 | $AcctNo18 | $AcctNoSub18 | $RightSeqNo18 | $Server18 | $LoadFileName18 | $BaslineTapeId18 | $DBName18= | $Server18= | $SeqNo18= |
| Test00019 | $AcctNo19 | $AcctNoSub19 | $RightSeqNo19 | $Server19 | $LoadFileName19 | $BaslineTapeId19 | $DBName19= | $Server19= | $SeqNo19= |
| Test00020 | $AcctNo20 | $AcctNoSub20 | $RightSeqNo20 | $Server20 | $LoadFileName20 | $BaslineTapeId20 | $DBName20= | $Server20= | $SeqNo20= |
| Test00021 | $AcctNo21 | $AcctNoSub21 | $RightSeqNo21 | $Server21 | $LoadFileName21 | $BaslineTapeId21 | $DBName21= | $Server21= | $SeqNo21= |
| Test00022 | $AcctNo22 | $AcctNoSub22 | $RightSeqNo22 | $Server22 | $LoadFileName22 | $BaslineTapeId22 | $DBName22= | $Server22= | $SeqNo22= |
| Test00023 | $AcctNo23 | $AcctNoSub23 | $RightSeqNo23 | $Server23 | $LoadFileName23 | $BaslineTapeId23 | $DBName23= | $Server23= | $SeqNo23= |
| Test00024 | $AcctNo24 | $AcctNoSub24 | $RightSeqNo24 | $Server24 | $LoadFileName24 | $BaslineTapeId24 | $DBName24= | $Server24= | $SeqNo24= |
| Test00025 | $AcctNo25 | $AcctNoSub25 | $RightSeqNo25 | $Server25 | $LoadFileName25 | $BaslineTapeId25 | $DBName25= | $Server25= | $SeqNo25= |
Execute Data Compare - Bene
| ddt: CompareRecordSets | -- query in LOADTESTBASELINE SELECT * FROM LOADTESTBASELINE.dbo.TrustXRef_{{DataBaseName}} AA JOIN LOADTESTBASELINE.dbo.Bene_{{DataBaseName}} A ON AA.TrustKey=A.TrustKey LEFT JOIN LOADTESTBASELINE.dbo.BenePerm_{{DataBaseName}} B ON B.TrustKey=A.TrustKey and A.LoadUpd_Dt= B.LoadUpd_Dt AND A.BeneNo=B.BeneNo LEFT JOIN LOADTESTBASELINE.dbo.BeneYr_{{DataBaseName}} C ON C.TrustKey=A.TrustKey and A.LoadUpd_Dt= C.TapeAddId and C.BeneNo=A.BeneNo and C.YrSeq=A.YrSeq LEFT JOIN LOADTESTBASELINE.dbo.CarbonCopy_{{DataBaseName}} D ON D.TrustKey=A.TrustKey and D.BeneNo=A.BeneNo WHERE A.LoadUpd_Dt='{{BaslineTapeId}}' | -- query in {{DataBaseName}} SELECT * FROM {{ServerName}}.{{DataBaseName}}.dbo.TrustXRef AA JOIN {{ServerName}}.{{DataBaseName}}.dbo.Bene A ON AA.TrustKey=A.TrustKey LEFT JOIN {{ServerName}}.{{DataBaseName}}.dbo.BenePerm B ON B.TrustKey=A.TrustKey and A.LoadUpd_Dt= B.LoadUpd_Dt AND A.BeneNo=B.BeneNo LEFT JOIN {{ServerName}}.{{DataBaseName}}.dbo.BeneYr C ON C.TrustKey=A.TrustKey and A.LoadUpd_Dt= C.TapeAddId and C.BeneNo=A.BeneNo and C.YrSeq=A.YrSeq LEFT JOIN {{ServerName}}.{{DataBaseName}}.dbo.CarbonCopy D ON D.TrustKey=A.TrustKey and D.BeneNo=A.BeneNo WHERE A.LoadUpd_Dt=(SELECT TapeId FROM {{ServerName}}.OPERATIONSDB.DBO.LoadStats where MainAcct='{{PAN}}' And AcctNo='{{PAN1}}' AND SEQNO='{{SEQNO}}') | AcctNo,TrustNo,YrSeq | TrustKey,TrustKey1,TrustKey2,TrustKey3,LoadUpd_Dt,LoadUpd_Dt1,CLR_Dt,TxYrBegin_Dt,TxYrEnd_Dt,Added_Dt,Chng_Dt,CLR_Dt1,Create_Dt,Create_Dt_Z,TxYrEnd_Dt_Z,Added_Dt1,Chng_Dt1,CLR_Dt2,PoolMort_Dt,Added_Dt2,Chng_Dt2,CLR_Dt3,Correction_Dt,NRAFiling_Dt,Death_Dt,CourtOrder_Dt,Initiated_Dt,Ten99Revised_Dt,EstDeath_Dt,Ten99Filing_Dt,Ten995498Filing_Dt,StTen99Filing_Dt,StTen995498Filing_Dt,TapeAddId,LastTapeId,TapeAddId1,LastTapeId1,TapeAddId2,LastTapeId2 | |||
| PAN | PAN1 | SEQNO | ServerName | DataBaseName | BaslineTapeId | ResultFile | Compare? |
| $AcctNo1 | $AcctNoSub1 | $SeqNo1 | $Server1 | $DBName1 | $BaslineTapeId1 | $AcctNo1_Bene.xml | Match |
| $AcctNo2 | $AcctNoSub2 | $SeqNo2 | $Server2 | $DBName2 | $BaslineTapeId2 | $AcctNo2_Bene.xml | Match |
| $AcctNo3 | $AcctNoSub3 | $SeqNo3 | $Server3 | $DBName3 | $BaslineTapeId3 | $AcctNo3_Bene.xml | Match |
| $AcctNo4 | $AcctNoSub4 | $SeqNo4 | $Server4 | $DBName4 | $BaslineTapeId4 | $AcctNo4_Bene.xml | Match |
| $AcctNo5 | $AcctNoSub5 | $SeqNo5 | $Server5 | $DBName5 | $BaslineTapeId5 | $AcctNo5_Bene.xml | Match |
| $AcctNo6 | $AcctNoSub6 | $SeqNo6 | $Server6 | $DBName6 | $BaslineTapeId6 | $AcctNo6_Bene.xml | Match |
| $AcctNo7 | $AcctNoSub7 | $SeqNo7 | $Server7 | $DBName7 | $BaslineTapeId7 | $AcctNo7_Bene.xml | Match |
| $AcctNo8 | $AcctNoSub8 | $SeqNo8 | $Server8 | $DBName8 | $BaslineTapeId8 | $AcctNo8_Bene.xml | Match |
| $AcctNo9 | $AcctNoSub9 | $SeqNo9 | $Server9 | $DBName9 | $BaslineTapeId9 | $AcctNo9_Bene.xml | Match |
| $AcctNo10 | $AcctNoSub10 | $SeqNo10 | $Server10 | $DBName10 | $BaslineTapeId10 | $AcctNo10_Bene.xml | Match |
| $AcctNo11 | $AcctNoSub11 | $SeqNo11 | $Server11 | $DBName11 | $BaslineTapeId11 | $AcctNo11_Bene.xml | Match |
| $AcctNo12 | $AcctNoSub12 | $SeqNo12 | $Server12 | $DBName12 | $BaslineTapeId12 | $AcctNo12_Bene.xml | Match |
| $AcctNo13 | $AcctNoSub13 | $SeqNo13 | $Server13 | $DBName13 | $BaslineTapeId13 | $AcctNo13_Bene.xml | Match |
| $AcctNo14 | $AcctNoSub14 | $SeqNo14 | $Server14 | $DBName14 | $BaslineTapeId14 | $AcctNo14_Bene.xml | Match |
| $AcctNo15 | $AcctNoSub15 | $SeqNo15 | $Server15 | $DBName15 | $BaslineTapeId15 | $AcctNo15_TrustBasic.xml | Match |
| $AcctNo16 | $AcctNoSub16 | $SeqNo16 | $Server16 | $DBName16 | $BaslineTapeId16 | $AcctNo16_TrustBasic.xml | Match |
| $AcctNo17 | $AcctNoSub17 | $SeqNo17 | $Server17 | $DBName17 | $BaslineTapeId17 | $AcctNo17_TrustBasic.xml | Match |
| $AcctNo18 | $AcctNoSub18 | $SeqNo18 | $Server18 | $DBName18 | $BaslineTapeId18 | $AcctNo18_TrustBasic.xml | Match |
| $AcctNo19 | $AcctNoSub19 | $SeqNo19 | $Server19 | $DBName19 | $BaslineTapeId19 | $AcctNo19_TrustBasic.xml | Match |
| $AcctNo20 | $AcctNoSub20 | $SeqNo20 | $Server20 | $DBName20 | $BaslineTapeId20 | $AcctNo20_TrustBasic.xml | Match |
| $AcctNo21 | $AcctNoSub21 | $SeqNo21 | $Server21 | $DBName21 | $BaslineTapeId21 | $AcctNo21_TrustBasic.xml | Match |
| $AcctNo22 | $AcctNoSub22 | $SeqNo22 | $Server22 | $DBName22 | $BaslineTapeId22 | $AcctNo22_TrustBasic.xml | Match |
| $AcctNo23 | $AcctNoSub23 | $SeqNo23 | $Server23 | $DBName23 | $BaslineTapeId23 | $AcctNo23_TrustBasic.xml | Match |
| $AcctNo24 | $AcctNoSub24 | $SeqNo24 | $Server24 | $DBName24 | $BaslineTapeId24 | $AcctNo24_TrustBasic.xml | Match |
| $AcctNo25 | $AcctNoSub25 | $SeqNo25 | $Server25 | $DBName25 | $BaslineTapeId25 | $AcctNo25_TrustBasic.xml | Match |
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