Change Details

create or replace function populate_provenance_caches() returns void language plpgsql as $$ declare rev sha1_git; ori bigint; vis bigint; begin for rev in (select id from revision) loop perform swh_cache_content_revision_add(rev); end loop; for ori, vis in (select origin, visit from origin_visit) loop perform swh_cache_revision_origin_add(ori, vis); end loop; return; end $$;

create or replace function populate_provenance_caches() returns void language plpgsql as $$ declare rev sha1_git; ori bigint; vis bigint; begin -- cache population for cache_content_revision perform swh_mktemp_bytea(); insert into tmp_bytea (select id from revision); perform swh_cache_content_revision_add(); -- cache population for cache_content_revision for ori, vis in (select origin, visit from origin_visit) loop perform swh_cache_revision_origin_add(ori, vis); end loop; return; end $$;

create or replace function populate_provenance_caches() returns void language plpgsql as $$ declare rev sha1_git; ori bigint; vis bigint; begin for rev in (select id from -- cache population for cache_content_revision) loopperform swh_mktemp_bytea(); perform swh_cache_content_insert into tmp_bytea (select id from revision_add(rev);); end loop;perform swh_cache_content_revision_add(); -- cache population for cache_content_revision for ori, vis in (select origin, visit from origin_visit) loop perform swh_cache_revision_origin_add(ori, vis); end loop; return; end $$;