Page MenuHomeSoftware Heritage

googlecode import: Clean up googlecode origin's origin_visits
Closed, MigratedEdits Locked

Description

When the loader-svn's runs will be finally done on googlecode import (that is all bug fixed + passes done), we need to clean up, for each origin, the multiple visits referenced. Indeed, they all represent the same visit (around may 2016).

We should only keep one, the latest.

Event Timeline

And also make sure the one visit date is the right one:

update origin_visit
set date='2016-05-03 15:16:32+00'
from origin o
where o.type='svn' and o.url like 'http://%.googlecode.com/svn/';