Selenium Java code for Database table comparison
$15-25 USD / hour
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.
Project ID: #32183071
About the project
17 freelancers are bidding on average $20/hour for this job
Hi I have seen your job description about SQL table comparison and interested in work. Please provide more details about work. Best,
===== Expert of Java and Selenium Webdriver, SQL HERE===== Dear Client! I am Andrei, experienced programmer from Russia. I have read your requirement and I noticed that I am appropriate to this project. As a skillful s More
Hello, I didn't understand how you are comparing, especially the second example which appears twice in target. Please let's engage.
Got 12 years and 8 months total experience Worked with US, UK clients Worked on CRM, ERP, Hospital Management, Travel, Insurance domains Worked on Java+Selenium for 7 years Worked on Cucumber for 1 year 10 months Worke More
Hello I checked the description and very interested in this project. I am a software developer having great experience in developing Websites and mobile app for 9 years more. SQL, Java and Selenium Webdriver are my maj More
Hello, Does you database support database link, then we can use database link and procedure and use selenium to invoke procedure, this will be over 100 times faster, the procedure will write all incorrect row data into More
Hello, First of all, we have recently done the exact same project with variation in how the test results are shown. We have built a framework where source to target db comparison is done without selenium as it does not More