Page MenuHomeSoftware Heritage
Paste P274

(An Untitled Masterwork)
ActivePublic

Authored by seirl on Jun 18 2018, 7:28 PM.
select snapshot.id as snapshot_id, snapshot_branch.name as branch_name, content.sha1, walk.*
from (
select snapshot.object_id as object_id
from origin tablesample system (0.00001)
inner join origin_visit on origin_visit.origin = origin.id
inner join snapshot on origin_visit.snapshot_id = snapshot.object_id
group by snapshot.object_id
) as snapshot
inner join snapshot_branches on snapshot.object_id = snapshot_branches.snapshot_id
inner join snapshot_branch on snapshot_branch.object_id = snapshot_branches.branch_id
inner join revision on snapshot_branch.target = revision.id
join lateral swh_directory_walk(revision.directory) walk on true
inner join content on walk.target = content.sha1_git
where
true
and snapshot_branch.target_type = 'revision'
and snapshot_branch.name = 'HEAD'
and walk.type = 'file';