Page Menu
Home
Software Heritage
Search
Configure Global Search
Log In
Paste
P271
(An Untitled Masterwork)
Active
Public
Actions
Authored by
olasd
on Jun 18 2018, 7:14 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
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
.
id
<
'\x000010'
and
snapshot_branch
.
target_type
=
'revision'
and
snapshot_branch
.
name
=
'HEAD'
and
walk
.
type
=
'file'
;
Event Timeline
olasd
created this paste.
Jun 18 2018, 7:14 PM
2018-06-18 19:14:40 (UTC+2)
Log In to Comment