Advertisement
Guest User

Least imported packages in the Go stdlib

a guest
Jun 27th, 2017
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.65 KB | None | 0 0
  1. SELECT import, SUM(copies) AS COUNT FROM (
  2.   SELECT import, copies FROM
  3.   (
  4.     SELECT REGEXP_EXTRACT(content, r'import "([^"]*)"') AS import, copies
  5.     FROM [campoy-github:go_files.contents]
  6.     WHERE REGEXP_MATCH(content, r'import ".*"')
  7.   ),(
  8.     SELECT REGEXP_EXTRACT(import, r'.*"([^"]*)"') AS import, copies FROM FLATTEN(
  9.       SELECT SPLIT(REGEXP_EXTRACT(content, r'(?s)import \(([^)]*)\)'), '\n') AS import, copies
  10.       FROM [campoy-github:go_files.contents]
  11.       WHERE REGEXP_MATCH(content, r'import \(')
  12.     , import)
  13.   )
  14. )
  15. WHERE import IN (SELECT * FROM [campoy-github:go_files.stdlib])
  16. GROUP BY import
  17. ORDER BY COUNT ASC
  18. LIMIT 10
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement