From b383d5d1c5a6e6511a63536426ffad72926a0f5c Mon Sep 17 00:00:00 2001 From: Michael Tremer Date: Mon, 3 Feb 2020 12:08:59 +0000 Subject: [PATCH] fireinfo: Label unknown processors as "Unknown" Signed-off-by: Michael Tremer --- src/backend/fireinfo.py | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/src/backend/fireinfo.py b/src/backend/fireinfo.py index a295ca6c..e5099599 100644 --- a/src/backend/fireinfo.py +++ b/src/backend/fireinfo.py @@ -1813,10 +1813,10 @@ class Fireinfo(Object): def get_cpu_vendors_map(self, when=None): res = self.db.query("WITH profiles AS (SELECT fireinfo_profiles_with_data_at(%s) AS id) \ - SELECT vendor, COUNT(vendor)::float / (SELECT COUNT(*) FROM profiles) AS count FROM profiles \ + SELECT COALESCE(vendor, %s) AS vendor, COUNT(vendor)::float / (SELECT COUNT(*) FROM profiles) AS count FROM profiles \ LEFT JOIN fireinfo_profiles_processors ON profiles.id = fireinfo_profiles_processors.profile_id \ LEFT JOIN fireinfo_processors ON fireinfo_profiles_processors.processor_id = fireinfo_processors.id \ - WHERE NOT fireinfo_profiles_processors.processor_id IS NULL GROUP BY vendor ORDER BY count DESC", when) + WHERE NOT fireinfo_profiles_processors.processor_id IS NULL GROUP BY vendor ORDER BY count DESC", when, "Unknown") return ((CPU_VENDORS.get(r.vendor, r.vendor), r.count) for r in res) -- 2.47.3