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= |
| 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= |
Execute Data Compare - Trans1099R[?]
| ddt: CompareRecordSets | -- query in LOADTESTBASELINE select * from LOADTESTBASELINE.dbo.TrustXRef_{{DataBaseName}} A JOIN LOADTESTBASELINE.dbo.Trust_{{DataBaseName}} B ON A.TrustKey=B.TrustKey JOIN LOADTESTBASELINE.dbo.Trans1099R_{{DataBaseName}} C ON A.TrustKey=C.TrustKey WHERE B.TapeAddId='{{BaslineTapeId}}' AND C.TapeAddId='{{BaslineTapeId}}' | -- query in {{DataBaseName}} select * from {{ServerName}}.{{DataBaseName}}.dbo.TrustXRef A JOIN {{ServerName}}.{{DataBaseName}}.dbo.Trust B ON A.TrustKey=B.TrustKey JOIN {{ServerName}}.{{DataBaseName}}.dbo.Trans1099R C ON A.TrustKey=C.TrustKey WHERE B.TapeAddId=(SELECT TapeId FROM {{ServerName}}.OPERATIONSDB.DBO.LoadStats where MainAcct='{{PAN}}' and AcctNo='{{PAN1}}' AND SEQNO='{{SEQNO}}') AND C.TapeAddId=(SELECT TapeId FROM {{ServerName}}.OPERATIONSDB.DBO.LoadStats where MainAcct='{{PAN}}' and AcctNo='{{PAN1}}' AND SEQNO='{{SEQNO}}') | AcctNo,TrustNo,TranSeq | 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_Trans1099R.xml | Match |
| $AcctNo2 | $AcctNoSub2 | $SeqNo2 | $Server2 | $DBName2 | $BaslineTapeId2 | $AcctNo2_Trans1099R.xml | Match |
| $AcctNo3 | $AcctNoSub3 | $SeqNo3 | $Server3 | $DBName3 | $BaslineTapeId3 | $AcctNo3_Trans1099R.xml | Match |
| $AcctNo4 | $AcctNoSub4 | $SeqNo4 | $Server4 | $DBName4 | $BaslineTapeId4 | $AcctNo4_Trans1099R.xml | Match |
| $AcctNo5 | $AcctNoSub5 | $SeqNo5 | $Server5 | $DBName5 | $BaslineTapeId5 | $AcctNo5_Trans1099R.xml | Match |
| $AcctNo6 | $AcctNoSub6 | $SeqNo6 | $Server6 | $DBName6 | $BaslineTapeId6 | $AcctNo6_Trans1099R.xml | Match |
| $AcctNo7 | $AcctNoSub7 | $SeqNo7 | $Server7 | $DBName7 | $BaslineTapeId7 | $AcctNo7_Trans1099R.xml | Match |
| $AcctNo8 | $AcctNoSub8 | $SeqNo8 | $Server8 | $DBName8 | $BaslineTapeId8 | $AcctNo8_Trans1099R.xml | Match |
| $AcctNo9 | $AcctNoSub9 | $SeqNo9 | $Server9 | $DBName9 | $BaslineTapeId9 | $AcctNo9_Trans1099R.xml | Match |
| $AcctNo10 | $AcctNoSub10 | $SeqNo10 | $Server10 | $DBName10 | $BaslineTapeId10 | $AcctNo10_Trans1099R.xml | Match |
| $AcctNo11 | $AcctNoSub11 | $SeqNo11 | $Server11 | $DBName11 | $BaslineTapeId11 | $AcctNo11_Trans1099R.xml | Match |
| $AcctNo12 | $AcctNoSub12 | $SeqNo12 | $Server12 | $DBName12 | $BaslineTapeId12 | $AcctNo12_Trans1099R.xml | Match |
| $AcctNo13 | $AcctNoSub13 | $SeqNo13 | $Server13 | $DBName13 | $BaslineTapeId13 | $AcctNo13_Trans1099R.xml | Match |
| $AcctNo14 | $AcctNoSub14 | $SeqNo14 | $Server14 | $DBName14 | $BaslineTapeId14 | $AcctNo14_Trans1099R.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