Selenium Java code for Database table comparison
Budget: $15 – $25 USD
Compare 2 result sets using selenium java.
This data is coming from source and target tables in different datbases and they have millions of rows and around 20 columns.
Below is the sample data, I want to compare these 2 resultsets and print or log these differences.
source columns
Ordnmber Cname Cnumber Ordtype Dnumber
3464772 ABCDW 647261 LL 02
3425728 ABCDL 635273 PP 10
3547352 ABCDK 636645 NN 30
3572635 ABCDZ 636234 ZZ 40
3362645 ABCDP 636256 PP 60
3423627 ABCDR 664535 JJ 10
3425728 ABCDQ 647261 LL 10
Target columns
Ordnmber Cname Cnumber Ordtype Dnumber
3464772 ABCDW 647261 CC 02
3425728 ABCDL 635273 PP 10
3547352 ABCDK 636645 NN 30
3572635 ABCDZ 636234 ZZ 40
3362645 ABCDP 636256 PP 60
3423627 ABCDR 664535 JJ 10
3425728 ABCGQ 664761 LL 10
Differene should be logged in the below format
For Ordnumber 3464772, Ordtype is LL in Source and CC in target
For Ordnumber 3425728, Cname is ABCDQ in Source and ABCGQ in target and Cnumber is 647261 in source and 664761 in target.
This data is coming from source and target tables in different datbases and they have millions of rows and around 20 columns.
Below is the sample data, I want to compare these 2 resultsets and print or log these differences.
source columns
Ordnmber Cname Cnumber Ordtype Dnumber
3464772 ABCDW 647261 LL 02
3425728 ABCDL 635273 PP 10
3547352 ABCDK 636645 NN 30
3572635 ABCDZ 636234 ZZ 40
3362645 ABCDP 636256 PP 60
3423627 ABCDR 664535 JJ 10
3425728 ABCDQ 647261 LL 10
Target columns
Ordnmber Cname Cnumber Ordtype Dnumber
3464772 ABCDW 647261 CC 02
3425728 ABCDL 635273 PP 10
3547352 ABCDK 636645 NN 30
3572635 ABCDZ 636234 ZZ 40
3362645 ABCDP 636256 PP 60
3423627 ABCDR 664535 JJ 10
3425728 ABCGQ 664761 LL 10
Differene should be logged in the below format
For Ordnumber 3464772, Ordtype is LL in Source and CC in target
For Ordnumber 3425728, Cname is ABCDQ in Source and ABCGQ in target and Cnumber is 647261 in source and 664761 in target.