Selenium Java code for Database table comparison
$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.
Ταυτότητα Εργασίας: #32183071
Σχετικά με την εργασία
17 freelancers κάνουν προσφορά κατά μέσο όρο $20/ώρα για αυτή τη δουλειά
Hello there, How are you doing? Just saw your project posted. I read the brief details and I felt I could help you with it. Let's start the chat and discuss it in detail. Please check my portfolio and reviews on my pr Περισσότερα
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 Περισσότερα
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 Περισσότερα
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 Περισσότερα
Dear Sir. I've read your post with result sets using selenium java carefully. I have worked on similar projects before and I can share my past experience with you. I can log the difference between the source and targ Περισσότερα
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 Περισσότερα
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 Περισσότερα
SDET professional with 7 years of experience in performing Automation Test Engineering Activities and Software Quality Assurance. Solid knowledge of Java and Object-Oriented Programming (OOPs) concepts. Background in d Περισσότερα
