Page MenuHomeSoftware Heritage
Paste P165

sha1-of-files-at-root-named-README-multiple-ext.sql
ActivePublic
Actions

Authored by moranegg on Jun 9 2017, 2:40 PM.
SELECT distinct c.sha1
FROM revision rev
inner join directory dir on rev.directory = dir.id
inner join directory_entry_file def on def.id = any(dir.file_entries)
inner join content c on c.sha1_git = def.target
WHERE def.name IN
('readme',
'readme.markdown',
'readme.mdown',
'readme.mkdn',
'readme.md',
'readme.textile',
'readme.rdoc',
'readme.org',
'readme.creole',
'readme.mediawiki',
'readme.wiki',
'readme.rst',
'readme.asciidoc',
'readme.adoc',
'readme.asc',
'readme.pod',
'README',
'README.markdown',
'README.mdown',
'README.mkdn',
'README.md',
'README.textile',
'README.rdoc',
'README.org',
'README.creole',
'README.mediawiki',
'README.wiki',
'README.rst',
'README.asciidoc',
'README.adoc',
'README.asc',
'README.pod')

Event Timeline

moranegg created this paste.Jun 9 2017, 2:40 PM
moranegg added a comment.EditedJun 9 2017, 2:48 PM

The query is available @uffizi:/srv/storage/space/lists/sha1-of-files-at-root-named-README-multiple-ext.sql
Temporary files are available@prado:/srv/softwareheritage/postgres/export/:

  • the cost of the query : explain-sha1-of-files-at-root-named-README.txt
  • sql query : sha1-of-files-at-root-named-README-multiple-ext.sql
  • result when available: sha1-of-files-at-root-named-README-multiple-ext.txt
moranegg mentioned this in T729: Database querying on README pattern.Jun 9 2017, 2:50 PM
About · Developer information · Legal