Before submitting an enhancement or fix, the tests outline in this guide must be performed to ensure that the new issues are not introduced. Evidence of the tests should be included in the pull request (summary output of compare).
As part of the Data Validation Tool project (https://github.com/GoogleCloudPlatform/professional-services-data-validator), the Google Database Blackbelt Team has created a great sample set of tables and data to test any data compare tool with. These tables are recommended, but not required, for use in testing any pull requests.
Evidence, summary of compare output vs expectations, should be included in any pull request. The sample data used must include all core types (character, number, timestamp, etc.). In addition, the test must be performed on two different database platforms.
Deploy the sample data under the database directory to the approriate database or use the DVT sample data.
pgcompare --init
pgcompare --discovery hr
pgcompare --reconcile --batch 0
UPDATE hr.location SET location_code=1234567890.1234567 WHERE city='Miami';
DELETE FROM hr.location WHERE city='Chicago';
INSERT INTO hr.location (longitude, latitude, city, state, zip, location_code) VALUES (-81.655647, 30.332184, 'Jacksonville', 'FL', 32257, 1234567890.123456789);
pgcompare --reconcile --batch 0
pgcompare --reconcile --batch 0 --check
pgcompare --reconcile --batch 0