-
-
Notifications
You must be signed in to change notification settings - Fork 167
/
media_query_properties.sql
65 lines (61 loc) · 1.14 KB
/
media_query_properties.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
64
65
#standardSQL
CREATE TEMPORARY FUNCTION getMediaQueryProperties(css STRING)
RETURNS ARRAY<STRING>
LANGUAGE js
OPTIONS (library = "gs://httparchive/lib/css-utils.js")
AS '''
try {
function compute(ast) {
let ret = {};
walkRules(ast, rule => {
walkDeclarations(rule.rules, ({property, value}) => {
incrementByKey(ret, property);
});
}, {
type: "media"
});
return sortObject(ret);
}
const ast = JSON.parse(css);
let properties = compute(ast);
return Object.keys(properties);
} catch (e) {
return [];
}
''';
SELECT
client,
property,
COUNT(DISTINCT page) AS pages,
total,
COUNT(DISTINCT page) / total AS pct
FROM (
SELECT DISTINCT
client,
page,
LOWER(property) AS property
FROM
`httparchive.almanac.parsed_css`
LEFT JOIN
UNNEST(getMediaQueryProperties(css)) AS property
WHERE
date = '2021-07-01' AND
property IS NOT NULL)
JOIN (
SELECT
_TABLE_SUFFIX AS client,
COUNT(0) AS total
FROM
`httparchive.summary_pages.2021_07_01_*`
GROUP BY
client)
USING
(client)
GROUP BY
client,
total,
property
HAVING
pct >= 0.01
ORDER BY
pct DESC