time spent on a domain | Query for ActivityWatch

query_domain_time.py

# Returns the total non-AFK time spent on a specific domain.
# Note that this doesn't care if the browser is in focus.
# Paste this into http://localhost:5600/#/query
# Tested for ActivityWatch 0.11.0

afk_events = query_bucket(find_bucket("aw-watcher-afk_"));
web_events = query_bucket(find_bucket("aw-watcher-web")); # doesn't work with multiple browsers; pass a specific bucket name like "aw-watcher-web-firefox" if necessary
web_events = split_url_events(web_events);
DOMAINS = ["youtube.com"];
domain_events = filter_keyvals(web_events, "$domain", DOMAINS);
non_afk_events = filter_keyvals(afk_events, "status", ["not-afk"]);
window_events = filter_period_intersect(web_events, non_afk_events);

RETURN = sum_durations(domain_events);