Page MenuHomeSoftware Heritage
Paste P272

(An Untitled Masterwork)
ActivePublic

Authored by seirl on Jun 18 2018, 7:20 PM.
select snapshot.id as snapshot_id, snapshot_branch.name as branch_name, content.sha1, walk.*
from origin
inner join origin_visit on origin_visit.origin = origin.id
inner join snapshot on origin_visit.snapshot_id = snapshot.object_id
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.id < '\x000010'
and snapshot_branch.target_type = 'revision'
and snapshot_branch.name = 'HEAD'
and walk.type = 'file';