Add Project#latest_version assocation, keep it up-to-date on save, and backfill it.

librariesio / libraries.io

:books: The Open Source Discovery Service

https://libraries.io

GNU Affero General Public License v3.0

1.1k stars 206 forks source link

Add Project#latest_version assocation, keep it up-to-date on save, and backfill it. #3357

Closed tiegz closed 2 months ago

tiegz commented 2 months ago

(followup to https://github.com/librariesio/libraries.io/pull/3356)

a backfill migration to populate Projects#latest_version_id (this has already been run on production)
replace Project#latest_version method with a new :latest_version belongs_to association
add a set_latest_version method that updates that column after a Project is saved

tiegz commented 2 months ago

How long is the backfill expected to take / will it impact deploys going out if it takes a long time or fails for some reason? If it will, could be worth making it a rake task and manually running it on a console.

I'd mentioned in the PR description that I've already run the migration on production, and I've double-checked the data for each row too to make sure the migration was correct.