Page Menu
Home
Software Heritage
Search
Configure Global Search
Log In
Paste
P272
(An Untitled Masterwork)
Active
Public
Actions
Authored by
seirl
on Jun 18 2018, 7:20 PM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
Tags
None
Subscribers
None
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'
;
Event Timeline
seirl
created this paste.
Jun 18 2018, 7:20 PM
2018-06-18 19:20:32 (UTC+2)
Log In to Comment