New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add lint process for verifying release summary table #17

Open
preaction opened this Issue Nov 29, 2017 · 0 comments

Comments

Projects
None yet
1 participant
@preaction
Member

preaction commented Nov 29, 2017

The release summary data (CPAN::Testers::Schema::Result::Release) has many rows with incorrect relationships to the uploads table (via the uploadid column). We should write a runnable module (using Beam::Runnable) that check to see that all of the dist/version information in this table is correct to the uploadid it is linked to.

If the data is incorrect, the script should fix it, but only if there is only one possible dist/version in the uploads table (see #16). In either case, the script should print out the offending row and either say that it has fixed it (and write what uploadid it fixed it to) or say that it could not be fixed automatically (and say which uploadids were available, and print the upload rows).

This process should be configured in etc/container/schema.yml and run via cron on a nightly basis.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment