-
-
Notifications
You must be signed in to change notification settings - Fork 164
/
css_in_js.sql
63 lines (59 loc) · 1.23 KB
/
css_in_js.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
#standardSQL
# CSS in JS. Show number of sites that using each framework or not using any.
CREATE TEMPORARY FUNCTION getCssInJS(payload STRING)
RETURNS ARRAY<STRING> LANGUAGE js AS '''
try {
var $ = JSON.parse(payload);
var css = JSON.parse($._css);
if (!Array.isArray(css.css_in_js)) {
return [];
}
// Use a safe-list to avoid parse error garbage.
var frameworks = new Set([
"Styled Components",
"Radium",
"React JSS",
"Emotion",
"Goober",
"Merge Styles",
"Styled Jsx",
"Aphrodite",
"Fela",
"Styletron",
"React Native for Web",
"Glamor"
]);
return css.css_in_js.filter(i => frameworks.has(i));
} catch (e) {
return [];
}
''';
SELECT
client,
cssInJs,
COUNT(DISTINCT url) AS pages,
total,
COUNT(DISTINCT url) / total AS pct
FROM (
SELECT
_TABLE_SUFFIX AS client,
url,
cssInJs
FROM
`httparchive.pages.2022_07_01_*`, -- noqa: L062
UNNEST(getCssInJS(payload)) AS cssInJs)
JOIN (
SELECT
_TABLE_SUFFIX AS client,
COUNT(0) AS total
FROM
`httparchive.summary_pages.2022_07_01_*` -- noqa: L062
GROUP BY
client)
USING (client)
GROUP BY
client,
cssInJs,
total
ORDER BY
pct DESC