Page Menu
Home
Software Heritage
Search
Configure Global Search
Log In
Paste
P274
(An Untitled Masterwork)
Active
Public
Actions
Authored by
seirl
on Jun 18 2018, 7:28 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
(
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'
;
Event Timeline
seirl
created this paste.
Jun 18 2018, 7:28 PM
2018-06-18 19:28:46 (UTC+2)
Log In to Comment